DataRow.RowError Property

 

Gets or sets the custom error description for a row.

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

Public Property RowError As String

Property Value

Type: System.String

The text describing an error.

Uses the HasErrors property to first determine whether a DataRow contains errors.

The following example sets error text for ten rows of a table displayed in a DataGrid control.

Private Sub SetRowErrors(ByVal table As DataTable)
    ' Set error text for ten rows. 
    Dim i As Integer
    For i = 0 to 10
        ' Insert column 1 value into each error.
        table.Rows(i).RowError = "ERROR: " & _
            table.Rows(i)(1).ToString()
    Next
    ' Get the DataSet for the table, and test it for errors.
    Dim dataSet As DataSet = table.DataSet
    TestForErrors(dataSet)
End Sub

Private Sub TestForErrors(ByVal dataSet As DataSet)
    ' Test for errors. If DataSet has errors, 
    ' test each table.
    If dataSet.HasErrors
        Dim tempDataTable As DataTable
        For Each tempDataTable in dataSet.Tables
            ' If the table has errors, then print them.
            If(tempDataTable.HasErrors) Then 
                PrintRowErrs(tempDataTable)
            End If
        Next
        ' Refresh the DataGrid to see the error-marked rows.
        DataGrid1.Refresh()
    End If
End Sub

Private Sub PrintRowErrs(ByVal table As DataTable)
    Dim row As DataRow
    For Each row in table.Rows
       If(row.HasErrors) Then
          Console.WriteLine(row.RowError)
       End If
    Next
End Sub

.NET Framework
Available since 1.1
Return to top
Show: