Hi Priya Vaithianathan,

I am not sure about what you mean by “not saved� Did you mean the changes are not update to database, or did you mean the changes are not committed to underlying data list (DataTable)?

I performed a test to save the changes to database, but I cannot reproduce the problem on Windows Vista. I guess you may forget to validate the changes. Validation is a required part of updating the data in a bound control. Once the form and all bound controls are validated, any current edits need to be committed. Finally, the table adapter needs to push its changes back to the database. To do this, put the following three lines in the save event handler on your form:

Best regards.
Rong-Chun Zhang

Windows Forms General FAQs
Windows Forms Data Controls and Databinding FAQs

I meant the underlying datatable when I said "not saved". This datatable is an intermediate which is pushed back to another class which takes care of the database update. Therefore there is no dataadapter or dataset involved here (another class just returns this datatable). The problem I am facing is, when I edit a row in the datagridview, only when come to the next row of the datagrid the first row is pushed into the datatable. If I edit the row's cells one by one and keep my cursor on the same row, then the data entered is not pushed into the datatable. The datatable's RowChanged and RowChanging event are called when the datagrid loses focus in XP (i.e when I click Ok to save changes). But in Vista the event fires only when the cursor is shifted to the next row in datagridview. This is a WPF application and I am using WindowsFormsHost to host the datagridview.

HiPriya Vaithianathan,

It seems it is a question about focus. The changes made in a DataGridView aren’t committed until you move to another row. To work around this, we can try to use DataGridView.CommitEdit to manually commit the changes and call EndEidt for the BindingSource object.

Let me know if this helps, if not, could you please show us of your code to reproduce your problem?

Best regards.
Rong-Chun Zhang

Windows Forms General FAQs
Windows Forms Data Controls and Databinding FAQs

Where are you using this code snippet? In CellValueChanged or CellValidating?

You can try to use the above code in the save button click event handler

Best regards.
Rong-Chun Zhang

Windows Forms General FAQs
Windows Forms Data Controls and Databinding FAQs

Hi. I have gone through your article and made changes accordingly. I added these lines:

this.Validate();

this.bindingSource1.EndEdit();

this.adapter.Update(this.table);

I have got the same problem and used the below code but its not working

if (this.dataGridView1.IsCurrentCellDirty)

this.dataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit);

Akhil.N.P

What happened to this discussion? It stopped mid way with no answer.

I had this same problem, and this is how I fixed it:

Me.Validate()
MyDataTable.EndEdit()
MyAdapter.Update(MyDataTable)

DO NOT call MyDataTable.AcceptChanges before running this code. That call sets the state of all rows in the DataTable to Unchanged, so the adapter doesn't see anything that needs to be updated.

This is how Rong-Chun explained it above in his first response and it seems to make sense, and it works. I'm using Vista 64-bit, .NET 2.0, VS 2008.