关闭

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

370人阅读 评论(0) 收藏 举报

  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();
            }
        }

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:109598次
    • 积分:2074
    • 等级:
    • 排名:千里之外
    • 原创:29篇
    • 转载:132篇
    • 译文:0篇
    • 评论:18条
    最新评论
    C#图表
    正则表达式