Rowupdating event in asp
Where a lot of records are being retrieved, you may want to retrieve in batches.The Select Arguments object gives you two key tools for doing this: the Start Row Index property (which specifies how many to skip over) and the Total Row Count (which specifies the number to retrieve).
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.
On the first step of the wizard click on "New Connection" button to open a dialog as shown in Figure 1.