C#实现数据库事务处理示例代码

  private void btn_submit_Click(object sender,System.EventArgs e)
        {
            string strconn = ConfigurationSettings.AppSettings["dsn"];
            SqlConnection cnn = new SqlConnection(strconn);
            SqlCommand cmd = new SqlCommand();
            SqlTransaction transaction = null;

            try
            {
                 cnn.Open();


                // 先插入分店shop表，再插入经理Manager表，并将其作为一个事务进行处理
                 transaction = cnn.BeginTransaction();
                 cmd.Transaction = transaction;
                 cmd.Connection = cnn;


                // 插入分店shop表
                string shopstr = "insert into shop values('" + tbx_shopid.Text+"','" + tbx_shopname.Text+"','" + tbx_shopaddress.Text+"','" + tbx_shopphone.Text+"')";
                 cmd.CommandType=CommandType.Text;
                 cmd.CommandText = shopstr;
                 cmd.ExecuteNonQuery();

                // 插入经理Manager表
                string managerstr = "insert into manager values('" + tbx_managerid.Text+"','" + tbx_managerpassword.Text+"','" + tbx_managername.Text+"','" + tbx_shopid.Text+"')";
                 cmd.CommandType=CommandType.Text;
                 cmd.CommandText = managerstr;
                 cmd.ExecuteNonQuery();

                // 提交事务
                 transaction.Commit();
                 lbl_msg.Text="添加分店操作成功";
            }
            catch(Exception ex)
            {
                 lbl_msg.Text="添加分店操作失败";
                 transaction.Rollback();
            }
            finally
            {
                 cnn.Close();
            }
        }