Export (0) Print
Expand All

DataSet.HasChanges Method (DataRowState)

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

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

'Declaration
Public Function HasChanges ( _
	rowStates As DataRowState _
) As Boolean

Parameters

rowStates
Type: System.Data.DataRowState

One of the DataRowState values.

Return Value

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

Examine the HasChanges property of the DataSet before invoking the GetChanges method.

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

.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
Show:
© 2015 Microsoft