c#添加事物（全部執行和帶儲存點的執行）

標籤：style   blog   http   color   os   io   2014   ar   

全部執行

 protected void Button2_Click(object sender, EventArgs e)        {            // 執行事務            SqlConnection con = new SqlConnection(str);            con.Open();            SqlTransaction tran = con.BeginTransaction();            try            {                SqlCommand cmd1 = new SqlCommand("INSERT INTO Code( name ) VALUES ( ‘ww1‘)", con);                SqlCommand cmd2 = new SqlCommand("INSERT INTO Code( name ) VALUES ( ‘ww2‘)", con);                cmd1.Transaction = tran;                cmd2.Transaction = tran;                cmd1.ExecuteNonQuery();                cmd2.ExecuteNonQuery();                tran.Commit();            }            catch            {                tran.Rollback();            }            finally            {                con.Close();                GetData();            }        }

執行帶儲存點的事務

 protected void Button3_Click(object sender, EventArgs e)        {            // 執行帶儲存點的事務            // 執行事務            SqlConnection con = new SqlConnection(str);            con.Open();            SqlTransaction tran = null;            tran = con.BeginTransaction();            try            {                SqlCommand cmd1 = new SqlCommand("INSERT INTO Code( name ) VALUES ( ‘ww3‘)", con);                SqlCommand cmd2 = new SqlCommand("INSERT INTO Code( name ) VALUES ( ‘ww4‘)", con);                cmd1.Transaction = tran;                cmd1.ExecuteNonQuery();                tran.Save("One");                cmd2.Transaction = tran;                cmd2.ExecuteNonQuery();                tran.Rollback("One");                tran.Commit();            }            catch            {                tran.Rollback();            }            finally {                con.Close();                GetData();            }        }