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)

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
Available since 1.1
Return to top
Show: