Tuesday, June 19, 2012

DataTable AcceptChanges


The DataTable’s AcceptChanges() method commits the changed done to the DataRow and the DataTable’s RejectChanges() method rolls back the changes done to the DataRow.

Now let us see with an example, on how the rowstate property gets affected by calling the AcceptChanges() method of the DataTable.

 Let us add a new row to a DataTable, and perform various operations on the row to observer the change in the RowState of the row.

// Fill the DataTable with your own logic
// Here we will fill the table by calling the Domain class.
clsEmployee objEmp = new clsEmployee();
DataTable dtEmployee = objEmp.GetEmployeeList();
DataRow drEmp;
//
// Add a new Row and perform data changes
drEmp = dtEmployee.NewRow();   // RowState - Detached
dtEmployee.Rows.Add(drEmp);    // RowState - Added
dtEmployee.AcceptChanges();    // RowState - Unchanged
drEmp["ID"] = 3134;            // RowState - Modified
dtEmployee.AcceptChanges();    // RowState - Unchanged
drEmp.Delete();                // RowState - Deleted
dtEmployee.AcceptChanges();    // RowState - Detached
gvEmployees.DataSource = dtEmployee;

Notice that, every time you call the DataTable’s AcceptChanges() method, the changes are committed to the DataTable and the RowState is reset to Unchanged.

The following are the changes of RowState of the DataRows in the DataTable, before and after calling the DataTable’s AcceptChanges() method.

RowState before calling AcceptChanges()
RowState after calling AcceptChanges()
Impact on the Row
Added
Unchanged
New row is commited to the DataTable
Modified
Unchanged
Data Changes to the row are committed to the DataTable
Deleted
Detached
Row is Permanently Removed from the DataTable

The AcceptChange() method can also be called on the individual DataRows in the DataTable, calling the DataTable’s AcceptChanges() method, will commit the changes of all the DataRows in the DataTable.


Search Flipkart Products:
Flipkart.com

No comments: