This documentation is archived and is not being maintained.

DbDataAdapter.FillError Event

.NET Framework 1.1

Returned when an error occurs during a fill operation.

[Visual Basic]
Public Event FillError As FillErrorEventHandler
public event FillErrorEventHandler FillError;
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.


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.


[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.

[Visual Basic] 
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    

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

    args.Continue = true;

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 Language Filter in the upper-left corner of the page.


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