关于我们

质量为本、客户为根、勇于拼搏、务实创新

< 返回新闻公共列表

c# mssql 事务例子

发布时间:2019-11-16 17:32:25

c# mssql 事务例子

 //执行事务 先插入到主表 让后创建表
                using (SqlTransaction tran = SqlHelper.BeginTransaction(SqlEasy.connString))
                {
                    try
                    {
                        string insertMain="insert into nw_customform (title,table_name,sort_id) values ('" + this.txtTitle.Text + "','" + this.txtTable.Text + "'," + this.txtSortId.Text + ")";
                        //先执行添加主表事务
                        SqlHelper.ExecuteTranNonQuery(tran, CommandType.Text, insertMain);
                        //再执行创建数据表事务
                        SqlHelper.ExecuteTranNonQuery(tran, CommandType.Text, sb.ToString());
                        tran.Commit();//提交事务
                        Response.Redirect("form_list.aspx");
                    }
                    catch (System.Data.SqlClient.SqlException err)
                    {
                        tran.Rollback();//如果失败回滚事务
                        Response.Write(err);
                        throw;
                    }
                }



/template/Home/Zkeys/PC/Static