Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

UpdateBatchSize and Objectdatasource

0 views
Skip to first unread message

rote

unread,
Oct 11, 2007, 4:14:36 AM10/11/07
to
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

bruce barker

unread,
Oct 11, 2007, 11:44:09 AM10/11/07
to
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)

0 new messages