I'm binding a dataset to a DataGridView at runtime and all the data is displaying fine. The tricky part is getting the changes back to the database. I'm the not sure what event to implement a handler for to get the changes back to the database. I've used CellValidated, but cannot figure out to verify if the cell is dirty, as can only seem to see IsCurrentCellDirty. Even if that is the case, the DataBoundItem, which is the DataSet row, has the new values but the RowState == DataRowState.Unchanged. So when I call the tableadapter update, nothing happens.

If I manually force the row by calling SetModified, it seems to reset the rows values to whats in the database.

I'm sure I'm missing something really simple, so in summary, can someone tell me what event handler I need to implement to submit changes back to the database.

Thanksin advance.