leodo@blog

SqlTransaction myTrans = null;
SqlConnection conn = new SqlConnection(Config.CONN_STRING);
conn.Open();
try
{
       myTrans = conn.BeginTransaction();
       SqlCommand cmd = new SqlCommand();
       cmd.Transaction=myTrans;
       cmd.Connection=conn;

       string sql = "";
                                                                               
       cmd.CommandText=sql;
       cmd.ExecuteNonQuery();
       myTrans.Commit();
}

catch(Exception exp)
{
       myTrans.Rollback();
       Response.Write(exp.Message);
}