SqlCeDataAdapter.RowUpdated Event

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Occurs during Update after a command is executed against the data source. The attempt to update is made, so the event fires.

  [Visual Basic]
  Public Event RowUpdated As SqlCeRowUpdatedEventHandler
[C#]
public event SqlCeRowUpdatedEventHandler RowUpdated;
[C++]
public: __event SqlCeRowUpdatedEventHandler* RowUpdated;

[JScript] In JScript, you can handle the events defined by a class, but you cannot define your own.

Event Data

The event handler receives an argument of type SqlCeRowUpdatedEventArgs containing data related to this event. The following SqlCeRowUpdatedEventArgs properties provide information specific to this event.

Property Description
Command Gets the SqlCeCommand executed when Update is called.
Errors (inherited from RowUpdatedEventArgs) Gets any errors generated by the .NET Framework data provider when the Command was executed.
RecordsAffected (inherited from RowUpdatedEventArgs) Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.
Row (inherited from RowUpdatedEventArgs) Gets the DataRow sent through an Update.
StatementType (inherited from RowUpdatedEventArgs) Gets the type of SQL statement executed.
Status (inherited from RowUpdatedEventArgs) Gets the UpdateStatus of the Command property.
TableMapping (inherited from RowUpdatedEventArgs) Gets the DataTableMapping sent through an Update.

Remarks

When using Update, there are two events that occur for each data row updated. The order of execution is as follows:

  1. The values in the DataRow are moved to the parameter values.
  2. The OnRowUpdating event is raised.
  3. The command executes.
  4. If the command is set to FirstReturnedRecord, then the first returned result is placed in the DataRow.
  5. The OnRowUpdated event is raised.
  6. AcceptChanges is called.

Requirements

.NET Framework Security:

See Also

SqlCeDataAdapter Class | SqlCeDataAdapter Members | System.Data.SqlServerCe Namespace

Syntax based on .NET Framework version 1.1.
Documentation version 1.1.1.

Send comments on this topic.

© Microsoft Corporation. All rights reserved.