/// <summary>

        /// 执行查询

        /// </summary>

        /// <param name="Querys">T-SQL语句的List泛型集合 T是string </param>

        /// <returns>返回影响行数</returns>

        public static int ExecuteNonQuery(List<string> Querys)

        {

            using (SqlConnection con = new SqlConnection(connectionString))

            {

                using (SqlCommand com = new SqlCommand())

                {

                    com.Connection = con;

                    con.Open();

                    SqlTransaction sqlTran = con.BeginTransaction();

                    try

                    {

                        com.Transaction = sqlTran;

                        int row = 0; ;

                        foreach (string str in Querys)

                        {

                            if (str.Length > 1)

                            {

                                com.CommandText = str;

                                row += com.ExecuteNonQuery();

                            }

                        }

                        sqlTran.Commit();

                        con.Close();

                        com.Clone();

                        con.Dispose();

                        com.Dispose();

                        return row;

                    }

                    catch (SqlException e)

                    {

                        sqlTran.Rollback();

                        throw new Exception(e.Message);

                    }

                }

            }

        }

private void Submit()

        {

            // 声明定义事务

            using (TransactionScope ts = new TransactionScope())

            {

                try

                {

                    // 事务方法体

                    Sub1();

                  Sub2();



                    // 提交事务并回滚

                    ts.Complete();

                }

                catch

                { }

            }



            this.GvBind();

        }



   private static void Sub2()

        {

            DbHelperSQL.ExecuteSql("INSERT INTO Items(Item) VALUES(''aa'')");

        }



  private static void Sub1()

        {

            DbHelperSQL.ExecuteSql("INSERT INTO Items(Item) VALUES(101)");

        }