System.Data.OleDb Namespace

Represents the method that will handle the RowUpdating event of an OleDbDataAdapter.

[ VB ]
Public Delegate Sub OleDbRowUpdatingEventHandler ( _
   ByVal sender As Object, _
   ByVal e As OleDbRowUpdatingEventArgs _
)

[ C# ]
public delegate void OleDbRowUpdatingEventHandler (
   object sender,
   OleDbRowUpdatingEventArgs e
);

[ C++ ]
public __gc __delegate void OleDbRowUpdatingEventHandler (
   Object* sender,
   OleDbRowUpdatingEventArgs* e
 )

In [ JScript ], you can use the delegates in the .NET Framework, but you cannot define your own.

The declaration of your event handler must have the same parameters as the OleDbRowUpdatingEventHandler delegate declaration.

sender

The source of the event.

e

The OleDbRowUpdatingEventArgs that contains the event data.

The handler is not required to perform any action, and your code should avoid generating exceptions or allowing exceptions to propagate to the calling method. Any exceptions that do reach the caller are ignored.

The handler may use the OleDbRowUpdatingEventArgs to influence the processing of the updates. For example, the handler may opt to skip the update of the current row or skip the update of all remaining rows. Note that the rows are updated in the order that they were received from the data source.

When you create an OleDbRowUpdatingEventArgs delegate, you identify the method that will handle the event. To associate the event with your event handler, add an instance of the delegate to the event. The event handler is called whenever the event occurs, unless you remove the delegate.

For more information about event handler delegates, see Web Forms Events and Handlers.

The following shows how to programmatically add and remove a RowUpdating event handler.

// add handler
myAdapter.RowUpdating += new OleDbRowUpdatingEventHandler ( OnRowUpdating );

myAdapter.Update ( custDS, "Customers" );

// remove handler
myAdapter.RowUpdating -= new OleDbRowUpdatingEventHandler ( OnRowUpdating );

' add handler
AddHandler myAdapter.RowUpdating, _
   New OleDbRowUpdatingEventHandler ( AddressOf OnRowUpdating )

myAdapter.Update ( custDS, "Customers" )

' remove handler
RemoveHandler myAdapter.RowUpdating, _
   New OleDbRowUpdatingEventHandler ( AddressOf OnRowUpdating )

The following shows how to code a simple handler that receives control whenever the RowUpdating event occurs.

void OnRowUpdating ( object sender, OleDbRowUpdatingEventArgs e ) {
   if ( e.Status == UpdateStatus.ErrorsOccurred ) {
      e.Row.RowError = e.Errors.Message;
      e.Status = UpdateStatus.SkipCurrentRow;
   }
}

Sub OnRowUpdating ( sender As Object, e As OleDbRowUpdatingEventArgs )
   If e.Status = UpdateStatus.ErrorsOccurred Then
      e.Row.RowError = e.Errors.Message
      e.Status = UpdateStatus.SkipCurrentRow
   End If
End Sub

OleDbDataAdapter.RowUpdating Event   OleDbRowUpdatingEventArgs Class

Books and more ...

Custom Search