DataSet.HasChanges Method

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

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

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

C#

public bool HasChanges();

Returns

Boolean

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.

C#

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

• Using DataSets in ADO.NET

HasChanges(DataRowState)

Source:

DataSet.cs

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

C#

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

Parameters

rowStates

DataRowState

One of the DataRowState values.

Returns

Boolean

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.

C#

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

• Using DataSets in ADO.NET