TransactionStateChanged Event

In This Topic

Occurs when the state of the transaction is changed.

Syntax

Visual Basic
C#

'Declaration
 
Public Event TransactionStateChanged As TransactionStateChangedEventHandler

public event TransactionStateChangedEventHandler TransactionStateChanged

Example

This sample demonstrates how to use the TransactionStateChanged and TransactionStateChanging events.

csharp

SugarConnection connection = new SugarConnection(
     "server=https://your_company.sugaropencloud.eu;user id=admin;password=AmFFA4ZryM;");
     connection.TransactionStateChanged += new TransactionStateChangedEventHandler(connection_TransactionStateChanged);
     connection.TransactionStateChanging += new TransactionStateChangingEventHandler(connection_TransactionStateChanging);
     connection.Open();

     // ...
SugarTransaction tr = connection.BeginTransaction();
     // ...
     tr.Commit();
     // ...

void connection_TransactionStateChanging(object sender, TransactionStateChangingEventArgs e) {

        if (e.Action == TransactionAction.Commit) {
                // do somthing...
        }
}

void connection_TransactionStateChanged(object sender, TransactionStateChangedEventArgs e) {
     
        if (e.Action == TransactionAction.Commit) {
                // do somthing...
        }
}

Visual Basic

Dim connection As New SugarConnection( _
    "server=https://your_company.sugaropencloud.eu;user id=admin;password=AmFFA4ZryM;")
AddHandler connection.TransactionStateChanged, New TransactionStateChangedEventHandler(AddressOf &_ Me.connection_TransactionStateChanged)
        AddHandler connection.TransactionStateChanging, New TransactionStateChangingEventHandler(AddressOf &_ Me.connection_TransactionStateChanging)
        connection.Open()
        '...
        Dim Transaction As SugarTransaction
        Transaction = connection.BeginTransaction()
        '...
        Transaction.Commit()
        '...

        Private Sub connection_TransactionStateChanged(ByVal sender As Object, ByVal e As TransactionStateChangedEventArgs)
        If (e.Action = TransactionAction.Commit) Then
                '...
        End If
End Sub

Private Sub connection_TransactionStateChanging(ByVal sender As Object, ByVal e As TransactionStateChangingEventArgs)
        If (e.Action = TransactionAction.Commit) Then
                '...
        End If
End Sub

Reference

DbConnectionBase Class
DbConnectionBase Members

Send Feedback