Saving many rows with Spread and ADO.Net

[Earl]

I was using Spread for awhile and then haven't played with it for several
months, so I've somewhat lost focus on the data updating ... Anyway, what
I'm trying to do is save many rows from one page of the Spread back to the
database. Is there a better method than looping through through the rows and
submitting a dataadapter update for each iteration of the loop??

 

[Val Mazur \(MVP\)]

Hi,

You do not need to call Update of the dataadapter for each row. When you
call Update method, then DataAdapter will update, delete and insert all the
affected rows. But it does it internally using loop anyway