dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlTransaction Class / Commit Method
Example

On this page
    Commit Method (MySqlTransaction)
    On this page
    Commits the database transaction.
    Syntax
    'Declaration
     
    Public Overrides Sub Commit() 
    public override void Commit()
    Remarks
    The Commit method is equivalent to the SQL COMMIT statement.
    Example
    The following example creates a MySqlConnection and a MySqlTransaction. It also demonstrates how to use the MySqlConnection.BeginTransaction, Commit, and Rollback methods.
    public void RunMySqlTransaction(string myConnString)
    {
      MySqlConnection mySqlConnection = new MySqlConnection(myConnString);
      mySqlConnection.Open();
    
      MySqlCommand mySqlCommand = new MySqlCommand();
      MySqlTransaction myTrans;
    
      // Start a local transaction
      myTrans = mySqlConnection.BeginTransaction();
      // Assign transaction object for a pending local transaction
      mySqlCommand.Transaction = myTrans;
    
      try
      {
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
        mySqlCommand.ExecuteNonQuery();
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')";
        mySqlCommand.ExecuteNonQuery();
        myTrans.Commit();
        Console.WriteLine("Both records are written to database.");
      }
      catch(Exception e)
      {
        myTrans.Rollback();
        Console.WriteLine(e.ToString());
        Console.WriteLine("Neither record was written to database.");
      }
      finally
      {
        mySqlConnection.Close();
      }
    }
    Public Sub RunMySqlTransaction(myConnString As String)
      Dim mySqlConnection As New MySqlConnection(myConnString)
      mySqlConnection.Open()
    
      Dim mySqlCommand As New MySqlCommand()
      Dim myTrans As MySqlTransaction
    
      ' Start a local transaction
      myTrans = mySqlConnection.BeginTransaction()
      ' Assign transaction object for a pending local transaction
      mySqlCommand.Transaction = myTrans
    
      Try
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
        mySqlCommand.ExecuteNonQuery()
        mySqlCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')"
        mySqlCommand.ExecuteNonQuery()
        myTrans.Commit()
        Console.WriteLine("Both records are written to database.")
      Catch e As Exception
        myTrans.Rollback()
        Console.WriteLine(e.ToString())
        Console.WriteLine("Neither record was written to database.")
      Finally
        mySqlConnection.Close()
      End Try
    End Sub
    See Also