DataSet.HasChanges Method

Definition

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

Overloads

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.

HasChanges()

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 ();

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);
}

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

HasChanges(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, filtered by DataRowState.

public bool HasChanges (System.Data.DataRowState rowStates);

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);
}

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