I want to allow users to edit multiple rows in a grid and then when they confirm they want to save the changes check for the DataChanged bool on each row. However, the changes are being commited as soon as aI leave the row. is there a way of stopping this - I've set the update mode to OnUpdate but can't seem to get this working.
Why you care if it commits a save or not?
I think the important moment here is "when" you want to those change to update on the database.
My suggestion is to let users do what ever they want then when they want to save then
check the rowstate of datatable that bind to the grid. If you want to save these change then do
Datatable.AcceptChange and send to database.
If you dont want to save then call following twoLines
DataTable.RejectChange
MyGrid.Update