DataTable.GetErrors DataTable.GetErrors DataTable.GetErrors DataTable.GetErrors Method

定義

取得包含錯誤之 DataRow 物件的陣列。Gets an array of DataRow objects that contain errors.

public:
 cli::array <System::Data::DataRow ^> ^ GetErrors();
public System.Data.DataRow[] GetErrors ();
member this.GetErrors : unit -> System.Data.DataRow[]
Public Function GetErrors () As DataRow()

傳回

具有錯誤之 DataRow 物件的陣列。An array of DataRow objects that have errors.

範例

下列範例會使用GetErrors方法來傳回具有錯誤之DataRow物件的陣列。The following example uses the GetErrors method to return an array of DataRow objects that have errors.

private void PrintAllErrs(DataSet dataSet)
{
    DataRow[] rowsInError; 
  
    foreach(DataTable table in dataSet.Tables)
    {
        // Test if the table has errors. If not, skip it.
        if(table.HasErrors)
        {
            // Get an array of all rows with errors.
            rowsInError = table.GetErrors();
            // Print the error of each column in each row.
            for(int i = 0; i < rowsInError.Length; i++)
            {
                foreach(DataColumn column in table.Columns)
                {
                    Console.WriteLine(column.ColumnName + " " + 
                        rowsInError[i].GetColumnError(column));
                }
                // Clear the row errors
                rowsInError[i].ClearErrors();
            }
        }
    }
}
Private Sub PrintAllErrs(ByVal dataSet As DataSet)
    Dim rowsInError() As DataRow
    Dim table As DataTable  
    Dim i As Integer
    Dim column As DataColumn
    For Each table In dataSet.Tables
       ' Test if the table has errors. If not, skip it.
       If table.HasErrors Then
          ' Get an array of all rows with errors.
          rowsInError = table.GetErrors()
          ' Print the error of each column in each row.
          For i = 0 To rowsInError.GetUpperBound(0)
             For Each column In table.Columns
                Console.WriteLine(column.ColumnName, _
                rowsInError(i).GetColumnError(column))
             Next
             ' Clear the row errors
          rowsInError(i).ClearErrors
          Next i
       End If
    Next
End Sub

備註

傳回已DataRow RowError設定的物件清單。Returns the list of DataRow objects that have RowError set. 例如,使用Update ContinueUpdateOnError設為true的呼叫時,可能會發生錯誤。For example, errors can occur when calling Update with ContinueUpdateOnError set to true. DataSet請不要AcceptChanges在上叫用,直到您解決所有DataTable錯誤,然後重新提交進行更新。Do not invoke AcceptChanges on the DataTable until you resolve all errors and resubmit the DataSet for updating.

適用於

另請參閱