This article will give you an overview of how to use an ASP.As you might have guessed this is not efficient while dealing with large number of rows.Fortunately Sql Data Adapter allows you to execute updates in batches. number of rows to be treated as a single batch via Update Batch Size property.There are also two events associated with this that you can use � Row Updating and Row Updated. in the absence of batch update, both of these events are raised for each and every row being updated.For example, if we are updating 100 rows, both of these rows are raised for 100 times.NET Grid View completely, and how to use Row Editing, Row Updating, Row Deleting, Row Command, Row Data Bound, Row Canceling Edit, and Pagination in a Data Grid.event is raised when a row's Update button is clicked, but after the Grid View control updates the row.You can also indicate whether the exception was handled in the event-handling method by setting the On Row Updated Row Canceling Edit On Row Canceling Edit Row Deleted On Row Deleted Row Deleting On Row Deleting Row Editing On Row Editing Row Updating On Row Updating Grid View Class System. before that i want just using Find control and casting and then retrieving all lot code. If values are same they could notify user to change the value(give new cell value).On the other hand the variable update will hold value equal to (number of rows in the table) / (batch size). NET 2.0, the Data Adapter provides a property called Update Batch Size which allows you to execute queries in a batch. He is a published author and has authored or co-authored books for Apress and Wrox press.This significantly reduces the database roundtrips and hence is more efficient in terms of performance. Having embraced the Yoga way of life he also teaches Ajapa Yoga to interested individuals.