System.Data.Common Namespace   DbDataAdapter Class

Returned when an error occurs during a fill operation.

[ VB ]
Public Event FillError As FillErrorEventHandler

[ C# ]
public event FillErrorEventHandler FillError;

[ C++ ]
public: __event FillErrorEventHandler* FillError;

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

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.

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.

The following example demonstrates how to catch and handle a FillError event. The examples assumes that you have created a SqlDataAdapter and a DataSet.

protected static void OnFillError ( object sender, FillErrorEventArgs args ) {
   if ( args.Errors.GetType ( ) == typeof ( System.OverflowException ) ) {

      // code to handle Precision Loss

      args.Continue = true;
   }
}

Private Shared Sub OnFillError ( 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

DbDataAdapter Members   FillErrorEventArgs Class   FillErrorEventHandler Delegate