Click on the "Advanced" button and check the "Generate INSERT, UPDATE and DELETE statements" checkbox (Figure 3). Now that you have configured the SQL Data Source control let's bind it with a Grid View control. Open its smart tag and configure it as shown in Figure 4.
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.
This will display the template designer for the column as shown in Figure 6.
Next, drag and drop a Required Field Validation control below the Text Box.
:icon_rolleyes: I'll fight a little more on my own and I'll post the results.