There can be several approaches taken for validating data. On the first step of the wizard click on “New Connection” button to open a dialog as shown in Figure 1.
Enter the database details as per your setup and click on OK.
Net grid view control can be customized in many ways according to our requirements basically, in a situation where we want to add the data row from the grid view interface.
In this case, when the Data Table is not empty, then the last blank row will appear if we enable “Show Footer” property of Grid View to true and vice versa.
This will convert them from Bound Field to Template Field.
Let’s proceed further by validating on the server side.
We will use the Custom Validator control for this purpose.
One note will be helpful for you, while describing Columns in Grid View if you are using a boundfield then create objects of the control using cells[index] in the rowupdateing event of Grid View, but if you are using controls itself like Label or textboxes etc then use Fincontrol("stringid").
This article will give you an overview of how to use an asp: Grid View completely, and how to use Row Editing, Row Updating, Row Deleting, Row Command, Row Data Bound, Row Canceling Edit, and Pagination in a Data Grid.