事务（Transaction）

 <div>
    请输入转账金额：<asp:TextBox ID="TextBox1" runat="server">
    </asp:TextBox>
        <asp:Button ID="Button1"
        runat="server" Text="转账" οnclick="Button1_Click" />
    </div>

 

 

 protected void Page_Load(object sender, EventArgs e)
        {
            //Transfer();
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Transfer();
        }
        protected void Transfer()
        {

           //创建数据库连接对象
            SqlConnection conn = new SqlConnection();

           //连接数据库
            conn.ConnectionString=@"Data Source=A102-34/SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True";
            conn.Open();

           // 利用当前建立的连接开始一个数据库事务
            SqlTransaction trans = conn.BeginTransaction();

           //创建命令
            SqlCommand comm = new SqlCommand();

            //命令连接到数据库对象
            comm.Connection = conn;

           //将命令添加到一个事务
            comm.Transaction = trans;
            try
            {

                string num = TextBox1.Text.Trim();
                comm.CommandText= "update T_Account set balance=balance-'"+num+"' where userAccount=2";
                comm.ExecuteNonQuery();
                comm.CommandText = "update T_Account set balance=balance+'" + num + "'where userAccount=3";
                comm.ExecuteNonQuery();

               //提交事务
                trans.Commit();
            }
            catch (SqlException ex)
            {

               //事务回滚
                trans.Rollback();
                Response.Write(ex.Message);
              
            }
            finally
            {
                conn.Close();
            }
        }