SqlCeDataAdapter.RowUpdating Event
.NET Framework 3.0
Occurs during a call to Update before an update command is executed against the data source. The attempt to update is made, and then this event fires.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
'Declaration Public Event RowUpdating As SqlCeRowUpdatingEventHandler 'Usage Dim instance As SqlCeDataAdapter Dim handler As SqlCeRowUpdatingEventHandler AddHandler instance.RowUpdating, handler
/** @event */ public void add_RowUpdating (SqlCeRowUpdatingEventHandler value) /** @event */ public void remove_RowUpdating (SqlCeRowUpdatingEventHandler value)
In JScript, you can handle the events defined by a class, but you cannot define your own.
Not applicable.
When using Update, there are two events that occur for each data row updated. The order of execution is as follows:
-
The values in the DataRow are moved to the parameter values.
-
The OnRowUpdating event is raised.
-
The command executes.
-
If the command is set to FirstReturnedRecord, then the first returned result is placed in the DataRow.
-
The OnRowUpdated event is raised.
-
AcceptChanges is called.
The following example shows the RowUpdating and RowUpdated events in use.
Public Sub Snippet5() ' Create DataAdapter ' Dim adp As New SqlCeDataAdapter("SELECT * FROM products", "Data Source = MyDatabase.sdf") Dim cb As New SqlCeCommandBuilder(adp) ' Create and fill the dataset (select only first 5 rows) ' Dim ds As New DataSet() adp.Fill(ds, 0, 5, "Table") ' Modify dataSet ' Dim table As DataTable = ds.Tables("Table") table.Rows(1)("Product Name") = "Asian Chai" ' Add handlers ' AddHandler adp.RowUpdating, AddressOf OnRowUpdating AddHandler adp.RowUpdated, AddressOf OnRowUpdated ' Update, this operation fires two events (RowUpdating/RowUpdated) ' adp.Update(ds, "Table") ' Remove handlers ' RemoveHandler adp.RowUpdating, AddressOf OnRowUpdating RemoveHandler adp.RowUpdated, AddressOf OnRowUpdated End Sub 'Snippet5 Private Shared Sub OnRowUpdating(ByVal sender As Object, ByVal e As SqlCeRowUpdatingEventArgs) Console.WriteLine("OnRowUpdating") Console.WriteLine(e.Command.CommandText) Console.WriteLine(e.StatementType) Console.WriteLine(e.Status) End Sub 'OnRowUpdating Private Shared Sub OnRowUpdated(ByVal sender As Object, ByVal e As SqlCeRowUpdatedEventArgs) Console.WriteLine("OnRowUpdated") Console.WriteLine(e.Command.CommandText) Console.WriteLine(e.StatementType) Console.WriteLine(e.Status) End Sub 'OnRowUpdated
Community Additions
ADD
Show: