Hi,

I am very interesting to know if anyone has a way to achieve undo functionality for dataset/datatable.

I have a situation where I bring in a dataset which consists of many datatables, and I use bindingsource (tables and relationships) to allow user to modify the data. All the changes a user makes will change the value in datatable directly.

The problem i have is that I would like to allow user to undo their changes in memory.

for example
1. user open a form and edit information, then close. (1st try)
2. user open the same form again and edit same information. (2nd try) User click cancel to reject the changes.
3. user click save to save (1try) to the dataset/datatable back to database using UPDATE.

I will greatly appreciate if anyone can share their thoughts on this, maybe provide a solution for me.

thanks a lot