GetChanges Method (DataRowState)
Collapse the table of content
Expand the table of content

DataSet.GetChanges Method (DataRowState)

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

Namespace: System.Data
Assembly: System.Data (in

DataSet^ GetChanges (
	DataRowState rowStates
public DataSet GetChanges (
	DataRowState rowStates
public function GetChanges (
	rowStates : DataRowState
) : DataSet
Not applicable.



One of the DataRowState values.

Return Value

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

The GetChanges method is used to produce a second DataSet 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.

This returned copy is designed to be merged back in to this original DataSet. Relationship constraints may cause parent rows marked Unchanged to be included. If no rows of the desired DataRowState are found, the GetChanges method returns a null reference (Nothing in Visual Basic).

The following example uses the GetChanges method to create a second DataSet object, which is then used to update a data source.

No code example is currently available or this language may not be supported.

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

© 2015 Microsoft