I have a datagrid associated with the recordset object.
There are insert/update/delete buttons in the same screen to do respective operations on the grid.Delete and Insert works fine.But when i change some cell value and move the control out of cell it automatically updates the grid and in turn updates the database table.But i want this should be only updated after clicking the Update button.

In simple the changes should be saved to the database only after clicking the Update button.

I feel AfterColUpdate and BeforeColUpdate events will not solve this problem.

I am using VC++ with Sybase backend.