Loading

Only post to database on button click event but still edit data in Grid.

Donnelly James

On a form with a DataGrid I want to allow users to edit data but not actually post to the database until they press the save button and if they press the cancel button I want for all changes made in the Grid to the data to be undone. How can I do this?

Donnelly

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mamta M16y ago
Accepted answer
Use a data adapter. Call the data adpter's Update method when the user clicks Save. Call the dataset or data table's RejectChanges method when the user clicks Cancel.
Following articles may help:
http://support.microsoft.com/kb/308055/en-us
http://msdn.microsoft.com/en-us/library/xzb1zw3x.aspx
0
hariom16y ago
Donnelly you can use Runtime Datatable and store the updated data into datatable and finally update whole table record into main database.
0