DataBase update on form changing

Question

I have a form with a dataset in which the user adds data. If the user tries to close the form I want to capture the changes made to the dataset (and havnt been written already to the table) and update the table accordingly. For some reason I cannot capture the changes made to the dataset. How do I do this? Here is my form closing event --> private void DivFrmClosing(object sender System.ComponentModel.CancelEventArgs e) { ..... DataSet changedData = dataSet11.GetChanges(); if (changedData != null) dbUpdate(); // method which updates database ..... } changedData remains null even if I have uncommitted data in my dataset. Please help!!

Andrzej Wegierski · Answer

Try EndEdit() on current row (I use DataView to avoid sorting on DataGrid; not tested): DataTable myTable=dataSet11.Tables[myTable]; Int row=myDataGrid.CurrentRowIndex; myTable.DefaultView[row].Row.EndEdit(); See EndEdit methods in help.