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

DataRow.GetColumnsInError Method

Gets an array of columns that have errors.

[Visual Basic]
Public Function GetColumnsInError() As DataColumn()
[C#]
public DataColumn[] GetColumnsInError();
[C++]
public: DataColumn* GetColumnsInError() [];
[JScript]
public function GetColumnsInError() : DataColumn[];

Return Value

An array of DataColumn objects that contain errors.

Remarks

The GetColumnsInError allows you to reduce the number of DataColumn objects that must be processed for errors by returning only those columns that have an error. Errors can be set to individual columns with the SetColumnError method. To further reduce the number of processing, check the DataRow class's HasErrors property to first determine if a DataRow has errors before invoking GetColumnsInError.

Use the ClearErrors method to clear all errors on the row, including the RowError.

Example

[Visual Basic, C#, C++] The following example uses the HasErrors to check for errors. If the row has errors, the GetColumnsInError method returns the array of columns with errors that can then be resolved. The ClearErrors method is then called to clear all errors.

[Visual Basic] 
Private Sub GetAllErrs(ByVal myRow As DataRow)
    ' Declare an array variable for DataColumn objects.
    Dim colArr() As DataColumn 
    ' If the Row has errors, check use GetColumnsInError.
    Dim i As Integer
    If myRow.HasErrors Then 
       ' Get the array of columns in error.
       colArr = myRow.GetColumnsInError()
       For i = 0 to colArr.GetUpperBound(0)
          ' Insert code to fix errors on each column.
          Console.WriteLine(colArr(i).ColumnName)
       Next i
    ' Clear errors after reconciling.
    myRow.ClearErrors()
    End If
 End Sub

[C#] 
private void GetAllErrs(DataRow myRow){
    // Declare an array variable for DataColumn objects.
    DataColumn[] colArr; 
    // If the Row has errors, check use GetColumnsInError.
    if(myRow.HasErrors){
       // Get the array of columns in error.
       colArr = myRow.GetColumnsInError();
       for(int i = 0; i < colArr.Length; i++){
          // Insert code to fix errors on each column.
          Console.WriteLine(colArr[i].ColumnName);
       }
    // Clear errors after reconciling.
    myRow.ClearErrors();
    }
 }

[C++] 
private:
void GetAllErrs(DataRow* myRow){
    // Declare an array variable for DataColumn objects.
    DataColumn* colArr[]; 
    // If the Row has errors, check use GetColumnsInError.
    if(myRow->HasErrors){
       // Get the array of columns in error.
       colArr = myRow->GetColumnsInError();
       for(int i = 0; i < colArr->Length; i++){
          // Insert code to fix errors on each column.
          Console::WriteLine(colArr[i]->ColumnName);
       }
    // Clear errors after reconciling.
    myRow->ClearErrors();
    }
 }

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework

See Also

DataRow Class | DataRow Members | System.Data Namespace | ClearErrors | GetColumnError | GetErrors | HasErrors | RowError | SetColumnError

Show:
© 2015 Microsoft