DataGridView

[mehrdadc48]

Hi. I have a DataGridView, now I want to use edit feature of it. for save changes to DB, the way that I know is that read all rows of DataGridView and update all rows in DB (even rows that have no changes) What is better way, that only changes be updated?

Best wishes

[rahvyn6]

I use this in the CellLeave event to update the underlying dataAdapter. Before calling this however, I loop through the grid to ensure that no values being updated are going to throw up errors. dataAdapter.Update(table);