void btnImplicitLocal_Click(object sender, EventArgs e)
{
    // Create the TransactionScope
    using (TransactionScope oTranScope = new TransactionScope())
    {
        using (SqlConnection oCn1 = new SqlConnection(this.sCn1))
        {
            SqlCommand oCmd = new SqlCommand(this.sSQL, oCn1);
            oCn1.Open();
            oCmd.ExecuteNonQuery();
            oCn1.Close();
        }

        // Tell the transaction scope that the transaction is in a
        // consistent state and can be committed
        oTranScope.Consistent = true; // oTranScope.Complete() in beta 2

        // The following bracket completes, commits, and disposes 
        // the transaction
    }
}

void btnImplicitLocalWithOptions_Click(object sender, EventArgs e)
{
  // Create the TransactionOptions object
  TransactionOptions oTranOpt = new TransactionOptions();

  // Set the Isolation Level
  oTranOpt.IsolationLevel =
    System.Transactions.IsolationLevel.ReadCommitted;

  // Set the timeout to be 2 minutes
  // Uses the (hours, minutes, seconds) constructor
  TimeSpan oTime = new TimeSpan(0, 2, 0);
  oTranOpt.Timeout = oTime;

  // Create the TransactionScope with the RequiresNew transaction 
  // setting and the TransactionOptions object I just created
  using (TransactionScope oTranScope = 
    new TransactionScope(TransactionScopeOption.RequiresNew, oTranOpt))
  {
    using (SqlConnection oCn1 = new SqlConnection(this.sCn1))
    {
      SqlCommand oCmd = new SqlCommand(this.sSQL, oCn1);
      oCn1.Open();
      oCmd.ExecuteNonQuery();
      oCn1.Close();
    }

    // Tell the transaction scope that the transaction is in a
    // consistent state and can be committed
    oTranScope.Consistent = true;

    // The following bracket completes and disposes the transaction
  }
}

void btnImplicitDistributed_Click(object sender, EventArgs e)
{
    // Create the TransactionScope
    using (TransactionScope oTranScope = new TransactionScope())
    {
        // Open a connection to SQL Server 2005
        using (SqlConnection oCn1 = new SqlConnection(this.sCn1))
        {
            SqlCommand oCmd1 = new SqlCommand(this.sSQL, oCn1);
            oCn1.Open();
            // At this point, the connection is in the transaction scope, 
            // which is a lightweight transaction.
            oCmd1.ExecuteNonQuery();
            oCn1.Close();
        }
        // Open a connection to SQL Server 2000
        using (SqlConnection oCn2 = new SqlConnection(this.sCn2))
        {
            SqlCommand oCmd2 = new SqlCommand(this.sSQL, oCn2);
            oCn2.Open();
            // The connection is enlisted in the transaction scope, 
            // which is now promoted to a distributed transaction
            // controlled by MSDTC
            oCmd2.ExecuteNonQuery();
            oCn2.Close();
        }
        // Tell the transaction scope to commit when ready 
        oTranScope.Consistent = true;
        // The following bracket completes and disposes the transaction
    }
}

// Create the Transaction (it is now lightweight)
// Note that for Beta 2 this has been changed
// to CommittableTransaction.
ICommittableTransaction oTran = Transaction.Create();

// Open a connection to SQL Server 2005
using (SqlConnection oCn1 = new SqlConnection(this.sCn1))
{
    SqlCommand oCmd1 = new SqlCommand(this.sSQL, oCn1);
    oCn1.Open();

    // The connection is not yet enlisted in the transaction scope 
    oCn1.EnlistTransaction();

    // Now the connection is enlisted in the transaction scope 
    oCmd1.ExecuteNonQuery((ITransaction)oTran);
    oCn1.Close();
}

// Tell the transaction to commit 
oTran.Commit();