ADO.NET两种事务处理方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Transactions;

namespace dotNET数据访问
{
    public partial class 事务处理 : System.Web.UI.Page
    {
        string conn = "Data Source=.;Initial Catalog=test;Integrated Security=True";
        SqlConnection con;
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            
            con = new SqlConnection(conn);
            con.Open();
            //启动一个事务。
            SqlTransaction myTran = con.BeginTransaction();

            SqlCommand myCom = new SqlCommand();
            myCom.Connection = con;
            myCom.Transaction = myTran;
            try
            {
                myCom.CommandText = "insert into fenye(value) values(‘zz‘)";//这条没有插入数据库
                myCom.ExecuteNonQuery();
                myCom.CommandText = "insert into fenye2(value) values(‘zz2‘)";
                myCom.ExecuteNonQuery();
                myTran.Commit();
                Response.Write("成功执行！1");
            }
            catch (Exception Ex)
            {
                myTran.Rollback();
                //创建并且返回异常的错误信息
                Response.Write(Ex.ToString());
                Response.Write("写入数据库失败");
            }
            finally
            {
                con.Close();
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            using (TransactionScope tsCope = new TransactionScope())
            {
                using (con = new SqlConnection(conn))
                {
                    SqlCommand cmd = new SqlCommand("insert into fenye(value) values(‘zz‘)", con);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
                using (con = new SqlConnection(conn))
                {
                    SqlCommand cmd = new SqlCommand("insert into fenye2(value) values(‘zz2‘)", con);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
                Response.Write("执行成功！2");
                tsCope.Complete();
            }
        }
    }
}