29.5 Events Reference

FillErrorEventHandler FillError;

The FillError event is raised when an error is encountered during a Fill( ) operation.

Example

The following code demonstrates how to handle the FillError event:

SqlDataAdapter da;

// ... code to set up the data adapter

da.FillError += new FillErrorEventHandler(da_FillError);

DataSet ds = new DataSet();

da.Fill(ds);



private void da_FillError(object sender, FillErrorEventArgs e);
{
    MessageBox.Show("RowUpdating");
    
    // continue the Fill with the rows remaining in the data source
    // despite the error
    e.Continue = true;
}

Notes

The event handler receives an argument of type FillErrorEventArgs containing properties that provide specific information about the event as described in Table 29-17.

Table 29-17. FillErrorEventArgs properties

Property	Description
Continue	Gets or sets a value that controls whether the Fill( ) operation continues despite the error.
DataTable	The DataTable being filled when the error occurred.
Errors	The Exception being handled.
Values	An object array containing the values for the row being filled when the error occurred.

This information can be used to handle the event appropriately and determine if the Fill( ) operation should continue processing the DataAdapter Fill( ) operation. To continue processing, set the Continue property of the FillErrorEventArgs argument to true; this results in the Fill( ) operation resuming with the next row in the data source.

If an error is encountered while processing the Fill( ) operation, and the FillError( ) event isn't handled, an exception is raised.

{Sql | OleDb}RowUpdatingEventHandler RowUpdating;

The RowUpdated event is raised after the command to reconcile a row with the data source row has been executed.

Example

The following code demonstrates how to handle the RowUpdated event:

SqlDataAdapter da;

// ... code to set up the data adapter

da.RowUpdated + =new SqlRowUpdatedEventHandler(da_RowUpdated);


private void da_RowUpdated(object sender, SqlRowUpdatedEventArgs e);
{
    MessageBox.Show("RowUpdated");
}

Notes

The event handler receives an argument of type RowUpdatedEventArgs containing properties that provide specific information about the event as described in Table 29-18.

Table 29-18. RowUpdatedEventArgs properties

Property	Description
Command	Gets the Command executed to perform the Update( ).
Errors	Gets any errors generated by the .NET data provider when the Command executes to perform the Update( ).
RecordsAffected	Gets the number of rows that deleted, changed, or inserted as a result of executing the Command.
Row	Gets the DataRow used in the Update( ).
StatementType	Gets the type of SQL statement (DELETE, INSERT, or UPDATE) executed in the Update( ).
Status	Gets or sets the UpdateStatus of the Command as described in Table 29-19.
TableMapping	Gets the DataTableMapping used in the Update( ).

Table 29-19 lists and describes the values in the UpdateStatus enumeration.

Table 29-19. UpdateStatus enumeration

Value	Description
Continue	Continue processing rows.
ErrorsOccurred	Raise an error as a result of the update.
SkipAllRemainingRows	Do not update the current and remaining rows.
SkipCurrentRow	Do not update the current row and continue processing the remaining rows.

{Sql | OleDb}RowUpdatedEventHandler RowUpdated;

The RowUpdating event is raised before the command to reconcile a row with the data source row has been executed.

Example

The following code demonstrates how to handle the RowUpdating event:

SqlDataAdapter da;

// ... code to set up the data adapter

da.RowUpdating += new SqlRowUpdatingEventHandler(da_RowUpdating);

private void da_RowUpdating(object sender, SqlRowUpdatingEventArgs e);
{
    MessageBox.Show("RowUpdating");
}

Notes

The event handler receives an argument of type RowUpdatingEventArgs containing properties that provide specific information about the event as described in Table 29-20.

Table 29-20. RowUpdatingEventArgs

Property	Description
Command	Gets or sets the Command that executes to perform the update.
Errors	Gets any errors generated by the .NET provider when the Command executes to perform the update.
Row	Gets the DataRow that is used in the update.
StatementType	Gets the type of SQL statement (DELETE, INSERT, or UPDATE) that is executed in the update.
Status	Gets or sets the UpdateStatus of the Command as described in Table 29-19.
TableMapping	Gets the DataTableMapping that is used in the update.