TransactionStateChangeEventArgs Class

In This Topic

Base class for TransactionStateChangedEventArgs and TransactionStateChangingEventArgs classes.

Syntax

Visual Basic
C#

'Declaration
 
Public MustInherit Class TransactionStateChangeEventArgs 
   Inherits System.EventArgs

public abstract class TransactionStateChangeEventArgs : System.EventArgs

Example

This sample demonstrates how the common base TransactionStateChangeEventArgs class for TransactionStateChanged and TransactionStateChanging envent arguments allows using more general code.

csharp

MySqlConnection connection = new MySqlConnection(
    "User Id=root;Host=localhost;Database=Test;");
   connection.TransactionStateChanged += new TransactionStateChangedEventHandler(connection_TransactionStateChange);
   connection.TransactionStateChanging += new TransactionStateChangingEventHandler(connection_TransactionStateChange);
   connection.Open();
   // ...
MySqlTransaction transaction = connection.BeginTransaction();
   // ...
   transaction.Commit();
   // ...

void connection_TransactionStateChange(object sender, TransactionStateChangeEventArgs e) {

        // common actions that must be done before and after the transaction state change
        // ...

        if (e is TransactionStateChangingEventArgs) {
                // actions before the transaction state change
                // ...
        }
        else { // e is TransactionStateChangedEventArgs
                // actions after the transaction state change
                // ...
        }
}

Visual Basic

Dim connection As New MySqlConnection( _
    "User Id=root;Host=localhost;Database=Test;")
AddHandler connection.TransactionStateChanged, New TransactionStateChangedEventHandler(AddressOf &_ Me.connection_TransactionStateChange)
        AddHandler connection.TransactionStateChanging, New TransactionStateChangingEventHandler(AddressOf &_ Me.connection_TransactionStateChange)
        connection.Open()
        ' ...
        Dim Transaction As OracleTransaction
        Transaction = connection.BeginTransaction()
        ' ...
        Transaction.Commit()
        ' ...

        Private Sub connection_TransactionStateChange(ByVal sender As Object, ByVal e As TransactionStateChangeEventArgs)
        ' common actions that must be done before and after the transaction state change
        '...
        If TypeOf e Is TransactionStateChangingEventArgs Then
                ' actions before the transaction state change
                ' ...
        Else ' e is TransactionStateChangedEventArgs
                ' actions after the transaction state change
                ' ...
        End If
End Sub

Inheritance Hierarchy

System.Object
   System.EventArgs
      Devart.Common.TransactionStateChangeEventArgs
         Devart.Common.TransactionStateChangedEventArgs
         Devart.Common.TransactionStateChangingEventArgs

Reference

TransactionStateChangeEventArgs Members
Devart.Common Namespace

Send Feedback