Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
HasErrors Property

DataSet.HasErrors Property

Gets a value indicating whether there are errors in any of the DataTable objects within this DataSet.

Namespace:  System.Data
Assembly:  System.Data (in System.Data.dll)

[BrowsableAttribute(false)]
public bool HasErrors { get; }

Property Value

Type: System.Boolean
true if any table contains an error;otherwise false.

Each DataTable in a DataSet also has a HasErrors property. Use the HasErrors property of the DataSet first, to determine if any table has errors, before checking individual DataTable objects. If a DataTable has errors, the GetErrors method returns an array of DataRow objects containing the errors.

The following example uses the HasErrors property to determine whether a DataSet object contains errors. If so, the errors for each DataRow in each DataTable are printed.

private void CheckForErrors()
{
    if(!DataSet1.HasErrors)
    {
        DataSet1.Merge(DataSet2);
    }
    else
    {
        PrintRowErrs(DataSet1);
    }
}

private void PrintRowErrs(DataSet dataSet)
{
    foreach(DataTable table in dataSet.Tables)
    {
        foreach(DataRow row in table.Rows)
        {
            if(row.HasErrors)
            {
                Console.WriteLine(row.RowError);
            }
        }
    }
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft