save all records with changes

[nev]

i do...

bindingsource.endedit()
tableadapter.update(dataset.datatable)

this is ok but it can only save the current record at a time. i want to make changes to many records and save them all simultaneously.

how can i do that?

[nev]

i want to do something like batch update.

[Shashi Sadasivan]

the update command checks all the rows, and updates them one by one if they have been changed.
So really that does the job.

I generally never let the user manually edit a lot of rows and then expect them to save it. But there are always scenarios where at the back end i have to update a bunch of rows based on what the user instructed.
I have been iterating each row of the datatable, and edit the sutiable ones.
once done i use the update method to update all rows.


So you dont have to really save it each time the user makes a change to a single row

[nev]

the update command checks all the rows, and updates them one by one if they have been changed.
So really that does the job.

I generally never let the user manually edit a lot of rows and then expect them to save it. But there are always scenarios where at the back end i have to update a bunch of rows based on what the user instructed.
I have been iterating each row of the datatable, and edit the sutiable ones.
once done i use the update method to update all rows.


So you dont have to really save it each time the user makes a change to a single row

in my form i have a bound checkbox. let's say for the first two rows, both are unchecked. i go to the 1st record and check it then i go to the next record and check it also. then, i do the update. but when i check the database, only the second record which was the current record gets updated. what may seem to be the problem?

[Shashi Sadasivan]

Are the checkboxes the values that have to be updated?
or are they in an unbound column which determines if that row has to be updated?

[nev]

Are the checkboxes the values that have to be updated?
or are they in an unbound column which determines if that row has to be updated?

they are bound. i drag n drop it from my datasources pane. before doing so, i changed it first from textbox into checkbox.