Roll Back after Fill Dataset

Question

How to roll back after fill data into dataset ?

Abdu Rafeeq · Answer

Hai senthil, my actual complaint is given below DbDataAdapter dbAd = DbFactory.CreateDataAdapter(); dbAd.SelectCommand = Command; DataSet Ds = new DataSet(); dbAd.Fill(Ds); Here this fill method data saved successfully in database This sitaution how to rollback saved data... here my commnad text is "exec Procedure"

Abdu Rafeeq · Answer

Hai senthil, my actual complaint is given below DbDataAdapter dbAd = DbFactory.CreateDataAdapter(); dbAd.SelectCommand = Command; DataSet Ds = new DataSet(); dbAd.Fill(Ds); Here this fill method data saved successfully in database This sitaution how to rollback saved data... here my commnad text is "exec Procedure"

Senthilkumar · Answer

Hi Abdu, There are some methods in the dataset. //Create the dataset DataSet dataSet = new DataSet(); //Load the dataset dataSet = RetrieveDataSets("SELECT * FROM Employees"); //Do changes in DataSet //Check any changes before do the roll back if (dataSet.HasChanges()) { dataSet.RejectChanges(); } Hope this will help you.

Roll Back after Fill Dataset

Answers (3)