Next, drag and drop a Required Field Validation control below the Text Box.Set the Control To Validate property of Required Field Validator control to Text Box1 (i.e. Also, set its Error Message property to "Please enter company name".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.You can not attach validation controls directly to these Text Boxes.We need to convert these Bound Fields to Template Fields.Now from the smart tag of the Grid View choose "Edit Template" and then select "Edit Item Template" of Company Name column.
Now you can specify the columns that you want in your Grid View.However, most of the real world cases call for validating the data being edited or deleted. Drag and drop an SQL Data Source control on the web form.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.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.