DataTable.GetChanges Method

Definition

Namespace:

System.Data

Assembly:

System.Data.Common.dll

Gets a copy of the DataTable containing all changes made to it since it was last loaded, or since AcceptChanges() was called.

Overloads

GetChanges()	Gets a copy of the DataTable that contains all changes made to it since it was loaded or AcceptChanges() was last called.
GetChanges(DataRowState)	Gets a copy of the DataTable containing all changes made to it since it was last loaded, or since AcceptChanges() was called, filtered by DataRowState.

GetChanges()

Source:

DataTable.cs

Gets a copy of the DataTable that contains all changes made to it since it was loaded or AcceptChanges() was last called.

public:
 System::Data::DataTable ^ GetChanges();

public System.Data.DataTable? GetChanges ();

member this.GetChanges : unit -> System.Data.DataTable

Public Function GetChanges () As DataTable

Returns

DataTable

A copy of the changes from this DataTable, or null if no changes are found.

Examples

private void UpdateDataTable(DataTable table,
    OleDbDataAdapter myDataAdapter)
{
    DataTable xDataTable = table.GetChanges();

    // Check the DataTable for errors.
    if (xDataTable.HasErrors)
    {
        // Insert code to resolve errors.
    }

    // After fixing errors, update the database with the DataAdapter
    myDataAdapter.Update(xDataTable);
}

Private Sub UpdateDataTable(table As DataTable, _
    myDataAdapter As OleDbDataAdapter)

    Dim xDataTable As DataTable = table.GetChanges()

    ' Check the DataTable for errors.
    If xDataTable.HasErrors Then
        ' Insert code to resolve errors.
    End If

    ' After fixing errors, update the database with the DataAdapter 
    myDataAdapter.Update(xDataTable)
End Sub

Remarks

Creates a new DataSet containing a copy of all rows in the original DataSet that have pending changes. Relationship constraints can cause additional unchanged rows to be added to the new DataSet if the unchanged rows contain primary keys corresponding to foreign keys in the changed rows. The method returns null (Nothing in Visual Basic) if there are no rows in the original DataSet with pending changes.

See also

• DataTables
• Handling DataTable Events

GetChanges(DataRowState)

Source:

DataTable.cs

Gets a copy of the DataTable containing all changes made to it since it was last loaded, or since AcceptChanges() was called, filtered by DataRowState.

public:
 System::Data::DataTable ^ GetChanges(System::Data::DataRowState rowStates);

public System.Data.DataTable? GetChanges (System.Data.DataRowState rowStates);

member this.GetChanges : System.Data.DataRowState -> System.Data.DataTable

Public Function GetChanges (rowStates As DataRowState) As DataTable

Parameters

rowStates

DataRowState

One of the DataRowState values.

Returns

DataTable

A filtered copy of the DataTable that can have actions performed on it, and later be merged back in the DataTable using Merge(DataSet). If no rows of the desired DataRowState are found, the method returns null.

Examples

private void ProcessDeletes(DataTable table,
    OleDbDataAdapter adapter)
{
    DataTable changeTable = table.GetChanges(DataRowState.Deleted);

    // Check the DataTable for errors.
    if (changeTable.HasErrors)
    {
        // Insert code to resolve errors.
    }

    // After fixing errors, update the database with the DataAdapter
    adapter.Update(changeTable);
}

Private Sub ProcessDeletes(table As DataTable, _
    adapter As OleDbDataAdapter)

   Dim changeTable As DataTable = table.GetChanges(DataRowState.Deleted)

   ' Check the DataTable for errors.
   If table.HasErrors Then
      ' Insert code to resolve errors.
   End If

   ' After fixing errors, update the database with the DataAdapter 
   adapter.Update(changeTable)
End Sub

Remarks

The GetChanges method is used to produce a second DataTable object that contains only the changes introduced into the original. Use the rowStates argument to specify the type of changes the new object should include.

Relationship constraints may cause unchanged parent rows to be included.

See also

• DataTables
• Handling DataTable Events