DataTable.GetChanges Method (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.

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

'Declaration
Public Function GetChanges ( _
	rowStates As DataRowState _
) As DataTable

Parameters

rowStates
Type: System.Data.DataRowState

One of the DataRowState values.

Return Value

Type: System.Data.DataTable
A filtered copy of the DataTable that can have actions performed on it, and later be merged back in the DataTable using Merge. If no rows of the desired DataRowState are found, the method returns Nothing.

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.

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

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft