OleDbDataAdapter.RowUpdating Event
Occurs during Update before a command is executed against the data source. The attempt to update is made. Therefore, the event occurs.
Assembly: System.Data (in System.Data.dll)
When you use Update, there are two events that occur per 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, the first returned result is placed in the DataRow.
If there are output parameters, they are placed in the DataRow.
The OnRowUpdated event is raised.
AcceptChanges is called.
The following example shows the RowUpdating and RowUpdated events being used.
Public Sub CreateDataAdapter(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString) Dim adapter As OleDbDataAdapter = New OleDbDataAdapter( _ "SELECT * FROM Customers WHERE CustomerID = 'ALFKI'", connection) adapter.InsertCommand = New OleDbCommand( _ "INSERT INTO Customers (CustomerID, CompanyName) VALUES(?, ?)", _ connection) adapter.InsertCommand.Parameters.Add( _ "@CustomerID", OleDbType.VarChar, 5, "CustomerID") adapter.InsertCommand.Parameters.Add( _ "@CompanyName", OleDbType.VarChar, 30, "CompanyName") connection.Open() Dim custDS As DataSet = New DataSet() adapter.Fill(custDS, "Customers") Dim custRow As DataRow = custDS.Tables("Customers").NewRow() custRow("CustomerID") = "NEWCO" custRow("CompanyName") = "New Company" custDS.Tables("Customers").Rows.Add(custRow) ' add handlers AddHandler adapter.RowUpdating, _ New OleDbRowUpdatingEventHandler(AddressOf OnRowUpdating) AddHandler adapter.RowUpdated, _ New OleDbRowUpdatedEventHandler(AddressOf OnRowUpdated) adapter.Update(custDS, "Customers") ' remove handlers RemoveHandler adapter.RowUpdating, _ New OleDbRowUpdatingEventHandler(AddressOf OnRowUpdating) RemoveHandler adapter.RowUpdated, _ New OleDbRowUpdatedEventHandler(AddressOf OnRowUpdated) Dim row As DataRow For Each row In custDS.Tables("Customers").Rows If row.HasErrors Then Console.WriteLine(row.RowError) Next End Using End Sub Sub OnRowUpdating(ByVal sender As Object, _ ByVal args As OleDbRowUpdatingEventArgs) If args.StatementType = StatementType.Insert Then Dim writer As System.IO.TextWriter = _ System.IO.File.AppendText("Inserts.log") writer.WriteLine("{0}: Customer {1} Inserted.", _ DateTime.Now, args.Row("CustomerID")) writer.Close() End If End Sub Sub OnRowUpdated(ByVal sender As Object, _ ByVal args As OleDbRowUpdatedEventArgs) If args.Status = UpdateStatus.ErrorsOccurred Then args.Row.RowError = args.Errors.Message args.Status = UpdateStatus.SkipCurrentRow End If End Sub
Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98
The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.