DbDataAdapter.FillError Event

Returned when an error occurs during a fill operation.

Public Event FillError As FillErrorEventHandler
[C#]
public event FillErrorEventHandler FillError;
[C++]
public: __event FillErrorEventHandler* FillError;

[JScript] In JScript, you can handle the events defined by a class, but you cannot define your own.

Event Data

The event handler receives an argument of type FillErrorEventArgs containing data related to this event. The following FillErrorEventArgs properties provide information specific to this event.

Property	Description
Continue	Gets or sets a value indicating whether to continue the fill operation despite the error.
DataTable	Gets the DataTable being updated when the error occurred.
Errors	Gets the errors being handled.
Values	Gets the values for the row being updated when the error occurred.

Remarks

The FillError event allows a user to determine whether or not the fill operation should continue after the error occurs. Examples of when the FillError event might occur are:

• The data being added to a DataSet cannot be converted to a common language runtime type without losing precision.
• The row being added contains data that violates a Constraint that must be enforced on a DataColumn in the DataSet.

An InvalidCastException exception is generated if an application does not declare a function to handle the FillError event.

Note   The FillError event is not returned if the source of the error is generated at the data source.

Example

[Visual Basic, C#, C++] The following example demonstrates how to catch and handle a FillError event. The examples assumes that you have created a SqlDataAdapter and a DataSet.

 
Private Shared Sub FillError(sender As Object, args As FillErrorEventArgs)
  If args.Errors.GetType() Is Type.GetType("System.OverflowException") Then
    ' Code to handle Precision Loss

    args.Continue = True
  End If
End Sub    

[C#] 
protected static void FillError(object sender, FillErrorEventArgs args)
{
  if (args.Errors.GetType() == typeof(System.OverflowException))
  {
    //Code to handle Precision Loss

    args.Continue = true;
  }
}

[C++] 
static void FillError(Object* sender, FillErrorEventArgs* args) {
 
    if (args->Errors->GetType() == __typeof(System::OverflowException))
    {
        //Code to handle Precision Loss
        args->Continue = true;
    }
}

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button 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

See Also

DbDataAdapter Class | DbDataAdapter Members | System.Data.Common Namespace