C# Dataset undo changes

Question

I want to know how to undo changes to a dataset prior to save.
At the moment I insert storedprocedure to the database or dataset, but now I want to undo the insert.
Can someone point me to the right direction.

David Smith · Answer

Im using infragistics ultragrid this UpdateData() updates or commits any modified information. Im commenting out this function. The rejectchange function is still not working, Im going to try something else

David Smith · Answer

Im using infragistics ultragrid this UpdateData() updates or commits any modified information. Im commenting out this function. The rejectchange function is still not working, Im going to try something else

Mamta M · Answer

What is the UpdateData method doing? Is it a method you created? Perhaps that method is affecting the changes. You can check the RowState of the rows before calling this method to verify if RejectChanges has succeeded.

David Smith · Answer

I stilll not gettting it to work. When I refresh the ultragrid or look in the table to undo the changes, the changes are still the same the logic have is below. this.tableBindingSource.CancelEdit(); this.demoDataSet.RejectChanges(); this.ultraGrid.UpdateData();

Mamta M · Answer

The DataSet.RejectChanges() method is the answer to your needs. Read more about it here: http://msdn.microsoft.com/en-us/library/system.data.dataset.rejectchanges.aspx

C# Dataset undo changes

Answers (5)