'Declaration Public Event RowUpdating As PgSqlRowUpdatingEventHandler |
public event PgSqlRowUpdatingEventHandler RowUpdating |
Event Data
The event handler receives an argument of type PgSqlRowUpdatingEventArgs containing data related to this event. The following PgSqlRowUpdatingEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Command | Gets or sets the PgSqlCommand to execute when System.Data.Common.DbDataAdapter.Update() is called. |
| Errors | (Inherited from System.Data.Common.RowUpdatingEventArgs) |
| Row | (Inherited from System.Data.Common.RowUpdatingEventArgs) |
| StatementType | (Inherited from System.Data.Common.RowUpdatingEventArgs) |
| Status | (Inherited from System.Data.Common.RowUpdatingEventArgs) |
| TableMapping | (Inherited from System.Data.Common.RowUpdatingEventArgs) |
Remarks
The event handler receives an argument of type PgSqlRowUpdatingEventArgs containing data related to this event. The following PgSqlRowUpdatingEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| PgSqlRowUpdatedEventArgs.Command | Gets the PgSqlCommand executed when System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) is called. |
| Errors (inherited from System.Data.Common.RowUpdatingEventArgs) | Gets any errors generated by the .NET data provider when the System.Data.Common.DbDataAdapter.Command(System.Data.DataSet) was executed. |
| Row (inherited from System.Data.Common.RowUpdatingEventArgs) | Gets the System.Data.DataRow to sent through an System.Data.Common.DbDataAdapter.Update(System.Data.DataSet). |
| StatementType (System.Data.Common.RowUpdatingEventArgs) | Gets the type of SQL statement to execute. |
| Status (inherited from System.Data.Common.RowUpdatingEventArgs) | Gets the UpdateStatus of the System.Data.Common.DbDataAdapter.Command(System.Data.DataSet). |
| TableMapping (inherited from System.Data.Common.RowUpdatingEventArgs) | Gets the DataTableMapping to sent through an System.Data.Common.DbDataAdapter.Update(System.Data.DataSet). |
When using the System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) method, there are two events that occur per data row updated. The order of execution is as follows:
- The values in the System.Data.DataRow are moved to the parameter values.
- The RowUpdating event is raised.
- The command executes.
- If the System.Data.UpdateRowSource enumeration is set to System.Data.UpdateRowSource.FirstReturnedRecordS, the first returned result is placed in the System.Data.DataRow.
- If there are output parameters, they are placed in the System.Data.DataRow.
- The RowUpdated event is raised.
- System.Data.DataRow.AcceptChanges is called.
See Also