Export (0) Print
Expand All

DataSet.HasChanges Method

Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows.

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

'Declaration
Public Function HasChanges As Boolean

Return Value

Type: System.Boolean
true if the DataSet has changes; otherwise false.

The following example uses the GetChanges method to create a second DataSet object that 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() Then  
        Exit Sub 
    End If 

    ' Create temporary DataSet variable. 
    ' 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.
    myOleDbDataAdapter.Update(tempDataSet)
End Sub

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft