Validating gridview 100 dating wives
Before fetching the records into gridview, check for the null values through the query.
Insert only those records in the grid which does not have null values. Now you can select the record from dataset where your second column is not null.
The Template Field's to provide a more foolproof user interface.
Specifically, this tutorial takes the example created in the Examining the Events Associated with Inserting, Updating, and Deleting tutorial and augments the editing and inserting interfaces to include appropriate validation.
The Grid View and Details View controls in the examples we've explored over the past three tutorials have all been composed of Bound Fields and Check Box Fields (the field types automatically added by Visual Studio when binding a Grid View or Details View to a data source control through the smart tag).
One of the most important features provided by Rad Grid View is the data validation.
Data validation features enable you to take complete control of the data entered in your grid's cells. This is the validation that is built into the business object implementation.
When editing a row in a Grid View or Details View, those Bound Fields that are not read-only are converted into textboxes, from which the end user can modify the existing data.
Similarly, when inserting a new record into a Details View control, those Bound Fields whose (the default) are rendered as empty textboxes, into which the user can provide the new record's field values.
In this way you will not have the records with null values in gridview. so you have taken the data from excel into dataset...