ADO.NET in a Nutshell
| FillError |
| 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.
| RowUpdated |
| {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. |
| RowUpdating |
| {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. |