At the end of this wizard, a “connection Strings” element will be added to your Web.config file.
In the next step, select the table and the specific columns you want to retrieve.
I am using Template Field’s Item Template and Edit Item Template for providing read only and editing interface of the same column in the Grid View.
By Default, Grid View control displays Item Template which directly shows the Product Name and Unit Price columns but when user clicks Edit button Grid View automatically switches to Edit Item Template and display the control available inside Edit Item Template for user editing.
Now you have to specify which database the Sql Data Source control will get data from. Click Next two times, leaving the default connection String name.
Font-Names="Verdana" Font-Size="10" Data Key Names="Product ID" Auto Generate Columns="false" onrowcancelingedit="Grid View1_Row Canceling Edit" onrowediting="Grid View1_Row Editing" onrowupdating="Grid View1_Row Updating"In the above code, I set two properties Show Edit Button and Show Cancel Button of Command Field.
These properties will automatically render Edit, Update and Cancel buttons inside Grid View column.
Select Both Category and Customer tables Give Model Namespace and click on Finish. NET Gridview Footer row for inserting record, inbuilt way to edit and delete records.
The visitors to a web site can typically be divided into two groups: the users and the administrators.