dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlTransaction Class / Rollback Method / Rollback() Method
Example

On this page
    Rollback() Method
    On this page
    Rolls back a database transaction from a pending state.
    Syntax
    'Declaration
     
    Public Overloads Overrides Sub Rollback() 
    public override void Rollback()
    Remarks
    The Rollback method is equivalent to the SQL ROLLBACK statement. The transaction can only be rolled back from a pending state (after MySqlConnection.BeginTransaction has been called, but before Commit is called).
    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