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.