How to: Locate Rows that Have Errors

When working with individual columns and rows of data, there may be times when a record contains an error. You can Check the HasErrors property to determine if errors exist in a DataSet, DataTable, or DataRow.

To locate a row that has errors

1. Check the HasErrors property to see if there are any errors in the dataset.

2. If the HasErrors property is true, iterate through the collections of tables, then the rows to find the row with the error.

   Private Sub FindErrors()
       Dim table As Data.DataTable
       Dim row As Data.DataRow
   
       If DataSet1.HasErrors Then 
   
           For Each table In DataSet1.Tables
               If table.HasErrors Then 
   
                   For Each row In table.Rows
                       If row.HasErrors Then 
   
                           ' Process error here. 
                       End If 
                   Next 
               End If 
           Next 
       End If 
   End Sub
   

   private void FindErrors() 
   {
       if (dataSet1.HasErrors)
       {
           foreach (DataTable table in dataSet1.Tables)
           {
               if (table.HasErrors)
               {
                   foreach (DataRow row in table.Rows)
                   {
                       if (row.HasErrors)
                       {
                           // Process error here.
                       }
                   }
               }
           }
       }
   }
   

See Also

Other Resources

Getting Started with Data Access

Connecting to Data in Visual Studio

Preparing Your Application to Receive Data

Fetching Data into Your Application

Displaying Data on Forms in Windows Applications

Editing Data in Your Application

Validating Data

Saving Data

Data Resources