Next Select your database and Set “Save Entity connection string in Web.config as” option true giving name Sample Entities.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 Grid View control is a tabular databound control but sometimes it is used like a spreadsheet control. NET 2.0 and is an improved version of the Data Grid control. We can use this to display data from a database and edit, sort and select the data.
There can be several approaches taken for validating data. For our example we are going to use Customers table of Northwind database. Open its smart tag and choose "Configure Data Source" option to start Configure Data Source wizard.
Here, we set the Data Source of the Grid View to Sql Data Source1. We also enable paging, sorting and editing features of the Grid View.
By default when the Grid View controls goes in edit mode, it displays Text Boxes for entering values.
Many a times in our applications we use primary keys to get control of the particular record in the gridview.
For this situation, many developers use invisible columns (Hidden columns) in the gridview to identify that row.