NGWS SDK Documentation  

This is preliminary documentation and subject to change.
To comment on this topic, please send us email at ngwssdk@microsoft.com. Thanks!

SQLDataSetCommand RowUpdating Event

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

The following declaration shows the syntax for a method that handles the RowUpdating event.

[Visual Basic]
Private Sub SQLDataSetCommandName_RowUpdating( _
   ByVal sender As Object, _
   ByVal e As SQLRowUpdatingEventArgs _
)
[C#]
private void SQLDataSetCommandName_RowUpdating(
   object sender,
   SQLRowUpdatingEventArgs e
);
[C++]
private: void SQLDataSetCommandName_RowUpdating(
   Object* sender,
   SQLRowUpdatingEventArgs* e
);
[JScript]
private SQLDataSetCommandName_RowUpdating(
   sender : Object,
   e : SQLRowUpdatingEventArgs
);

Parameters

sender
The source of the event.
e
A SQLRowUpdatingEventArgs that contains the event data. The following SQLRowUpdatingEventArgs properties provide information specific to this event.
Property Description
Command
[To be supplied.]

Remarks

When using Update, there are two events that occur per 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 fires

3) The command executes

4) if the command is set to FirstReturnedRecord, then the first ruturned result is placed in the DataRow

5) if there are output parameters, they are placed in the DataRow

6) The OnRowUpdated event fires.

7) AcceptChanges is called.

See Also

SQLDataSetCommand Class | SQLDataSetCommand MembersTopic | System.Data.SQL Namespace