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
'Usage
Dim instance As DataSet
Dim returnValue As Boolean

returnValue = instance.HasChanges
public boolean HasChanges ()
public function HasChanges () : boolean
Not applicable.

Return Value

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

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, 1.0

XNA Framework

Supported in: 1.0

Community Additions

ADD
Show:
© 2014 Microsoft