How can we cancel all changes done in dataset in ADO.NET? Dot Net Interview Questions

punjabtechnicaluniversity.blogspot.in

For tracking down changes Dataset has two methods which comes as rescue “GetChanges “and “HasChanges”. GetChanges Return’s dataset which are changed since it was loaded or since Acceptchanges was executed.

HasChanges

This property indicate’s has any change’s been made since the dataset was loaded or acceptchanges method was executed. If we want to revert or abandon all change’s since the dataset was loaded use

“RejectChanges”.

Note:- One of the most misunderstood things about these properties is that it tracks the changes of actual database.That’s a fundamental mistake , actually the changes are related to only changes with dataset and has nothing to with changes happening in actual database.As dataset are disconnected and do not know anything about the changes happening in actual database.