DataSet.GetChanges Method (DataRowState)
Assembly: System.Data (in system.data.dll)
'Declaration Public Function GetChanges ( _ rowStates As DataRowState _ ) As DataSet 'Usage Dim instance As DataSet Dim rowStates As DataRowState Dim returnValue As DataSet returnValue = instance.GetChanges(rowStates)
One of the DataRowState values.
Return ValueA 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.
Private Sub UpdateDataSet(ByVal dataSet As DataSet) ' Check for changes with the HasChanges method first. If Not dataSet.HasChanges(DataRowState.Modified) Then Exit Sub End If ' Create temporary DataSet variable and ' GetChanges for modified rows only. Dim tempDataSet As DataSet = _ dataSet.GetChanges(DataRowState.Modified) ' Check the DataSet for errors. If tempDataSet.HasErrors Then ' Insert code to resolve errors. End If ' After fixing errors, update the data source with ' the DataAdapter used to create the DataSet. adapter.Update(tempDataSet) End Sub
Windows 98, Windows 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 .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.