asp.net 事务回滚

最新推荐文章于 2022-10-07 17:19:20 发布

weixin_34191734

最新推荐文章于 2022-10-07 17:19:20 发布

阅读量245

点赞数

CC 4.0 BY-SA版权

文章标签：测试

原文链接：http://www.cnblogs.com/tiger8000/archive/2011/10/08/2201784.html

       string getTitle = this.TextBox1.Text;
        string getAuthor = this.TextBox2.Text;
        string sql = "insert into 表(title,author) values ('" + getTitle + "','" + getAuthor + "'); select @@identity AS RID";

       //string sql = "insert into DepartMent(DepartMentName,DepartMentCode) values ('" + getName + "','" + getCode + "');insert into DepartMent(ID,DepartMentName) values ('"+@@identity +"','新部门测试')";
        string connStr = System.Configuration.ConfigurationManager.AppSettings["fff"].ToString();

        SqlConnection myconn = new SqlConnection(connStr);
        SqlCommand mycomm = new SqlCommand(sql,myconn);
        myconn.Open();
        SqlTransaction myTrans = myconn.BeginTransaction();
        mycomm.Transaction = myTrans;

        try
        {
            mycomm.ExecuteNonQuery();
            myTrans.Commit();
        }
        catch
        {
            myTrans.Rollback();
        }
        finally
        {
            myconn.Close();
        }

转载于:https://www.cnblogs.com/tiger8000/archive/2011/10/08/2201784.html