Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
FillError Event
Collapse the table of content
Expand the table of content

DbDataAdapter.FillError Event

.NET Framework 1.1

Returned when an error occurs during a fill operation.

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

[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    

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

See Also

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

Show:
© 2015 Microsoft