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)

'Declaration
Public ReadOnly Property HasErrors As Boolean
'Usage
Dim instance As DataSet
Dim value As Boolean

value = instance.HasErrors

/** @property */
public boolean get_HasErrors ()

public function get HasErrors () : boolean

Property Value

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 Sub CheckForErrors()
    If Not DataSet1.HasErrors Then
        DataSet1.Merge(DataSet2)
    Else
       PrintRowErrs(DataSet1)
    End If
End Sub
 
Private Sub PrintRowErrs(ByVal dataSet As DataSet)
    Dim row As DataRow
    Dim table As DataTable
    For Each table In  dataSet.Tables
       For Each row In table.Rows
          If row.HasErrors Then
             Console.WriteLine(row.RowError)
          End If
       Next
    Next
End Sub

Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show: