Roll Back after Fill Dataset

Abdu Rafeeq14y ago

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 Rafeeq14y ago

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"

Senthilkumar14y ago

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.