DataTable.RejectChanges Method

Definition

Namespace:

System.Data

Assembly:

System.Data.Common.dll

Source:

DataTable.cs

Rolls back all changes that have been made to the table since it was loaded, or the last time AcceptChanges() was called.

public:
 void RejectChanges();

public void RejectChanges ();

member this.RejectChanges : unit -> unit

Public Sub RejectChanges ()

Examples

The following example makes several changes to a DataTable, but rejects the changes by invoking the RejectChanges method.

private void ShowRejectChanges(DataTable table)
{
    // Print the values of row 1, in the column named "CompanyName."
    Console.WriteLine(table.Rows[1]["CompanyName"]);

    // Make Changes to the column named "CompanyName."
    table.Rows[1]["CompanyName"] = "Taro";

    // Reject the changes.
    table.RejectChanges();

    // Print the original values:
    Console.WriteLine(table.Rows[1]["CompanyName"]);
}

Private Sub ShowRejectChanges(table As DataTable)
    ' Print the values of row 1, in the column named "CompanyName."
    Console.WriteLine(table.Rows(1)("CompanyName"))

    ' Make Changes to the column named "CompanyName."
    table.Rows(1)("CompanyName") = "Taro"

    ' Reject the changes.
    table.RejectChanges()

    ' Print the original values:
    Console.WriteLine(table.Rows(1)("CompanyName"))
End Sub

Remarks

When RejectChanges is called, any DataRow objects that are still in edit-mode cancel their edits. New rows are removed. Rows with the DataRowState set to Modified or Deleted return back to their original state.

See also

• DataTables
• Handling DataTable Events