System.Data Namespace DataSet Class
Returns a copy of the DataSet containing all changes made to it since it was last loaded, or since AcceptChanges was called.
1. Returns a copy of the DataSet that contains all changes made to it since it was loaded or AcceptChanges was last called.
2. Returns a copy of the DataSet containing all changes made to it since it was last loaded, or since AcceptChanges was called, filtered by DataRowState.
The following example uses the GetChanges method to create a second DataSet object that is then used to update a data source.
NOTE: This example uses one of the overloaded versions of GetChanges. For other examples that may be available, see the individual overload topics.
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 here ...
}
// after fixing errors, update the DBMS with the DataAdapter
// used to create the DataSet.
myOleDbDataAdapter.Update ( xDataSet );
}
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 DBMS with the DataAdapter
' used to create the DataSet.
myOleDbDataAdapter.Update ( xDataSet )
End Sub |
| |
C# |
VB |
DataSet Members HasChanges HasErrors
