UpdateBatchSize and Objectdatasource

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
 
B

bruce barker

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,007
Latest member
obedient dusk

Latest Threads

Top