|
Submitted by
meghanjoshi
(Monday, December 19, 2005)
When you use SqlDataAdapter for performing updates, the SqlDataAdapter propagates the updates one by one. That means if there are 100 rows to be updated the SqlDataAdapter will execute 100 separate operations against the database. As you might have guessed this is not efficient while dealing with large number of rows. Fortunately SqlDataAdapter allows you to execute updates in batches. You can specify the batch size i.e. number of rows to be treated as a single batch via UpdateBatchSize property.
Read More
Marketplace
(Sponsored Links) |
|
|
|
|
 |
|
|
 |
|
|
|
|
|
|