Name

RowUpdating

Synopsis

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