Export (0) Print
Expand All

DataSet.HasChanges Method (DataRowState)

.NET Framework 1.1

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

[Visual Basic]
Overloads Public Function HasChanges( _
   ByVal rowStates As DataRowState _
) As Boolean
[C#]
public bool HasChanges(
 DataRowState rowStates
);
[C++]
public: bool HasChanges(
 DataRowState rowStates
);
[JScript]
public function HasChanges(
   rowStates : DataRowState
) : Boolean;

Parameters

rowStates
One of the DataRowState values.

Return Value

true, if the DataSet has changes; otherwise, false.

Remarks

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

Example

[Visual Basic, C#, C++] The following example uses the GetChanges method to create a second DataSet object that is then used to update a data source.

[Visual Basic] 
Private Sub UpdateDataSet(ByVal myDataSet As DataSet)
   ' Check for changes with the HasChanges method first.
   If Not myDataSet.HasChanges(DataRowState.Modified) Then Exit Sub
   ' Create temporary DataSet variable.
   Dim xDataSet As DataSet
   ' GetChanges for modified rows only.
   xDataSet = myDataSet.GetChanges(DataRowState.Modified)
   ' Check the DataSet for errors.
   If xDataSet.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(xDataSet)
End Sub

[C#] 
private void UpdateDataSet(DataSet myDataSet){
   // Check for changes with the HasChanges method first.
   if(!myDataSet.HasChanges(DataRowState.Modified)) return;
   // Create temporary DataSet variable.
   DataSet xDataSet;
   // GetChanges for modified rows only.
   xDataSet = myDataSet.GetChanges(DataRowState.Modified);
   // Check the DataSet for errors.
   if(xDataSet.HasErrors){
      // Insert code to resolve errors.
   }
   // After fixing errors, update the data source with the DataAdapter 
   // used to create the DataSet.
   myOleDbDataAdapter.Update(xDataSet);
}

[C++] 
private:
 void UpdateDataSet(DataSet* myDataSet){
    // Check for changes with the HasChanges method first.
    if(!myDataSet->HasChanges(DataRowState::Modified)) return;
    // Create temporary DataSet variable.
    DataSet* xDataSet;
    // GetChanges for modified rows only.
    xDataSet = myDataSet->GetChanges(DataRowState::Modified);
    // Check the DataSet for errors.
    if(xDataSet->HasErrors){
       // Insert code to resolve errors.
    }
    // After fixing errors, update the data source with the DataAdapter 
    // used to create the DataSet.
    myOleDbDataAdapter->Update(xDataSet);
 }

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework

See Also

DataSet Class | DataSet Members | System.Data Namespace | DataSet.HasChanges Overload List | GetChanges

Show:
© 2014 Microsoft