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