aspdotnet-suresh offers C#articles and tutorials,csharp dot net,articles and tutorials, VB.

Inside the Row Updating event u can code for updation ex: Protected Sub Grid View1_Row Updating(By Val sender As Object, By Val e As System.

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 next step select Customer ID, Company Name, Contact Name and Country columns (Figure 2).

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.