How to save DataGridView to temp dataset
I have a DataGridView that loads and seems to work so far. What I want to be able to do now is allow the user to make changes to the DataGridView but also allow rollback until they hit the save button.
So what I was thinking of doing was saving the DataGridView each time they make a change into a temp dataset that I will rebind to the DataGridView every time they make a change until they hit the save button that will then save the dataset to SQL.
So my questions are:
Is this a good way to do this?
And how do I go about saving the DataGridView to a tempo dataset?
As always thanks again for the help.
(using VS 2005 C# and SQL 2005)