If we set the batch size to 10 then Row Updating will be raised for 100 times where as Row Updated will be raised only for 10 times.Following code illustrates use of this feature: Notice how we have attached event handlers to the Row Updating and Row Updated events.I’m using visual studio 2008 and sql server 2008 for this sample.In general, gridview control is used to populate the data in tabular format from different datasources and basically it derived from webcontrol class.I am using Template Field’s Item Template and Edit Item Template for providing read only and editing interface of the same column in the Grid View.By Default, Grid View control displays Item Template which directly shows the Product Name and Unit Price columns but when user clicks Edit button Grid View automatically switches to Edit Item Template and display the control available inside Edit Item Template for user editing.Once you execute the above table and insert scripts, you will get the below records in the table initially to load data into gridview control.Execute the below SP_Customer stored procedure in sql server database which is used to handle insert, update, select and delete a record into customer table.
Create the customer table in your own test database using below table script and insert some records initially to load gridview with data.
That means if there are 100 rows to be updated the Sql Data Adapter will execute 100 separate operations against the database.
As you might have guessed this is not efficient while dealing with large number of rows.
A friend asked me to help him out on this and frankly it has me completely stumped as well.
I have a Grid View control and use old style manual binding with a Data Source property and invoke the Data Bind() method.