UpdateBatchSize and Objectdatasource

  • Thread starter Thread starter rote
  • Start date Start date
R

rote

I was looking into ObjectDatasource and i could do a sort of batchupdate by
using a gridview i looped through the controls and updated multiple values.
But when i look at the updates in sql it did it multiple times so for
example if i have 10 rows to update it called the update 10 times.
But i have read somehwhere about using this new stuff in ADO.NET 2.0 called
UpdateBatchSize but the samples i saw was only with SqlAdapter
which i'm not using.
Is it possible to use this with an ObjectDatasource(using SqlCommand with
Sqlparameters)
Thanks in advance
 
not really. while you could try to cache the updates and batch them, you
get no notification of completion (last call to update). you could cache
the updates, and have the form code call a "commit" to write the actual sql.

-- bruce (sqlwork.com)
 
Back
Top