Ajit Kumar

• Nov 24th, 2005

 

Data set maintains state of each row. For new entry row state is Inserted, For modified row it is Modifies and for deleted row , the row state is deleted.

Sathiyavathi

• Mar 28th, 2006

 

Hi,

   We can do it using GetChanges() which gets a copy of the dataset that contains all changes made to it since it was loaded.For ex:

  private void UpdateDataSet(DataSet myDataSet){
     if(!myDataSet.HasChanges(DataRowState.Modified)) 

        return;
   DataSet xDataSet;

//To get modified row only
      xDataSet = myDataSet.GetChanges(DataRowState.Modified); 

      if(xDataSet.HasErrors){
      // Insert code to resolve errors.
   }
   myOleDbDataAdapter.Update(xDataSet);
}