'Declaration Public Event RowUpdating As SQLiteRowUpdatingEventHandler
public event SQLiteRowUpdatingEventHandler RowUpdating
Event Data
The event handler receives an argument of type SQLiteRowUpdatingEventArgs containing data related to this event. The following SQLiteRowUpdatingEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Command | Gets or sets the SQLiteCommand 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 SQLiteRowUpdatingEventArgs containing data related to this event. The following SQLiteRowUpdatingEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| SQLiteRowUpdatedEventArgs.Command | Gets the SQLiteCommand 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