Transaction类的一个例子,比较好的注释

最新推荐文章于 2024-07-25 13:12:13 发布

原创最新推荐文章于 2024-07-25 13:12:13 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#insert #string #数据库 #button #object #email

C# 同时被 2 个专栏收录

7 篇文章

订阅专栏

MS-SQL数据库

2 篇文章

订阅专栏

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Configuration;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Transactions;

public partial class _Default : System.Web.UI.Page 
{
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection s1 = new SqlConnection(WebConfigurationManager.ConnectionStrings["sqlconnstring_t1"].ConnectionString);
        SqlConnection s2 = new SqlConnection(WebConfigurationManager.ConnectionStrings["sqlconnstring_t2"].ConnectionString);
        string queryString1 = string.Empty;
        string queryString2 = string.Empty;
        queryString1 = string.Format(" insert into t1(name,pwd,email) values('{0}','{1}','{2}') ",this.TextBox1.Text,this.TextBox2.Text,this.TextBox3.Text);
        queryString2 = string.Format(" insert into t2(name,state) values('{0}','{1}') ",this.TextBox4.Text,this.TextBox5.Text);
        
        SqlCommand sc1 = new SqlCommand(queryString1,s1);    //传输的    
        SqlCommand sc2 = new SqlCommand(queryString2, s2);
        s1.Open();
        SqlTransaction sqlTran1 = s1.BeginTransaction();	//开始事务处理的
        s2.Open();
        SqlTransaction sqlTran2 = s2.BeginTransaction();
        using (TransactionScope transScope = new TransactionScope())		//TranscaionScope使代码块成为事务性代码
        {
            try
            {
                sc1.Transaction = sqlTran1;		//设置Transaction的命令
                sc1.ExecuteScalar();			//执行命令
                sc2.Transaction = sqlTran2;
                sc2.ExecuteScalar();
            }
            catch(SqlException ex)
            {
                sqlTran1.Rollback();
                sqlTran2.Rollback();
                s1.Close();	//如果不增加数据库事务，连接关闭时，数据会写入数据库
                s2.Close();
                return;
            }
            sqlTran1.Commit();			//提交事务
            sqlTran2.Commit();    
            transScope.Complete();		//指示范围中的所有操作都已成功完成。当您对范围中的所有操作都已成功完成感到满意时，应该仅调用此方法一次
            s1.Close();
            s2.Close();
        }
    }
}