DataSet.HasChanges Method
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows.
HasChanges() |
Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows. |
HasChanges(DataRowState) |
Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows, filtered by DataRowState. |
- Source:
- DataSet.cs
- Source:
- DataSet.cs
- Source:
- DataSet.cs
Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows.
public:
bool HasChanges();
public bool HasChanges ();
member this.HasChanges : unit -> bool
Public Function HasChanges () As Boolean
Returns
true
if the DataSet has changes; otherwise, false
.
Examples
The following example uses the GetChanges method to create a second DataSet object that is then used to update a data source.
private void UpdateDataSet(DataSet dataSet)
{
// Check for changes with the HasChanges method first.
if(!dataSet.HasChanges()) return;
// Create temporary DataSet variable.
DataSet tempDataSet;
// GetChanges for modified rows only.
tempDataSet = dataSet.GetChanges(DataRowState.Modified);
// Check the DataSet for errors.
if(tempDataSet.HasErrors)
{
// Insert code to resolve errors.
}
// After fixing errors, update the data source with
// the DataAdapter used to create the DataSet.
myOleDbDataAdapter.Update(tempDataSet);
}
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
See also
Applies to
.NET 9 and other versions
Product | Versions |
---|---|
.NET | Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9 |
.NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
.NET Standard | 2.0, 2.1 |
- Source:
- DataSet.cs
- Source:
- DataSet.cs
- Source:
- DataSet.cs
Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows, filtered by DataRowState.
public:
bool HasChanges(System::Data::DataRowState rowStates);
public bool HasChanges (System.Data.DataRowState rowStates);
member this.HasChanges : System.Data.DataRowState -> bool
Public Function HasChanges (rowStates As DataRowState) As Boolean
Parameters
- rowStates
- DataRowState
One of the DataRowState values.
Returns
true
if the DataSet has changes; otherwise, false
.
Examples
The following example uses the GetChanges method to create a second DataSet object, which is then used to update a data source.
private void UpdateDataSet(DataSet dataSet)
{
// Check for changes with the HasChanges method first.
if(!dataSet.HasChanges(DataRowState.Modified)) return;
// Create temporary DataSet variable and
// GetChanges for modified rows only.
DataSet tempDataSet =
dataSet.GetChanges(DataRowState.Modified);
// Check the DataSet for errors.
if(tempDataSet.HasErrors)
{
// Insert code to resolve errors.
}
// After fixing errors, update the data source with
// the DataAdapter used to create the DataSet.
adapter.Update(tempDataSet);
}
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
Remarks
Examine the HasChanges property of the DataSet
before invoking the GetChanges method.
See also
Applies to
.NET 9 and other versions
Product | Versions |
---|---|
.NET | Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9 |
.NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
.NET Standard | 2.0, 2.1 |
.NET feedback
.NET is an open source project. Select a link to provide feedback: