C#

public void RunSqlTransaction(string myConnString) <br />
 {<br />
    SqlConnection myConnection = new SqlConnection(myConnString);<br />
    myConnection.Open();<br />
<br />
    SqlCommand myCommand = myConnection.CreateCommand();<br />
    SqlTransaction myTrans;<br />
<br />
    // Start a local transaction<br />
    myTrans = myConnection.BeginTransaction();<br />
    // Must assign both transaction object and connection<br />
    // to Command object for a pending local transaction<br />
    myCommand.Connection = myConnection;<br />
    myCommand.Transaction = myTrans;<br />
<br />
    try<br />
    {<br />
      myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";<br />
      myCommand.ExecuteNonQuery();<br />
      myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";<br />
      myCommand.ExecuteNonQuery();<br />
      myTrans.Commit();<br />
      Console.WriteLine("Both records are written to database.");<br />
    }<br />
    catch(Exception e)<br />
    {<br />
      try<br />
      {<br />
        myTrans.Rollback();<br />
      }<br />
      catch (SqlException ex)<br />
      {<br />
        if (myTrans.Connection != null)<br />
        {<br />
          Console.WriteLine("An exception of type " + ex.GetType() +<br />
                            " was encountered while attempting to roll back the transaction.");<br />
        }<br />
      }<br />
    <br />
      Console.WriteLine("An exception of type " + e.GetType() +<br />
                        " was encountered while inserting the data.");<br />
      Console.WriteLine("Neither record was written to database.");<br />
    }<br />
    finally <br />
    {<br />
      myConnection.Close();<br />
    }<br />
}