Export (0) Print
Expand All

DataTable.GetChanges Method ()

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

Namespace: System.Data
Assembly: System.Data (in system.data.dll)

public DataTable GetChanges ()
public DataTable GetChanges ()
public function GetChanges () : DataTable
Not applicable.

Return Value

A copy of the changes from this DataTable, or a null reference (Nothing in Visual Basic) if no changes are found.

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 a null reference (Nothing in Visual Basic) (Nothing in Visual Basic) if there are no rows in the original DataSet with pending changes.

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);
}

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0

XNA Framework

Supported in: 1.0

Community Additions

ADD
Show:
© 2014 Microsoft