定义批量执行多条SQL语句的方法

//定义批量执行多条SQL语句的方法
    public bool executeTransaction(string[] strSql)
    {
        bool flag = false;
        con = getCon();//得到连接
        cmd.Connection = con;//命令对象
        SqlTransaction myTransaction;　//声明一个SQL事物类型
        myTransaction = con.BeginTransaction();//基于一个连接初始化事物
        try
        {
            /*
            for (int i = 0; i < strSql.Length; i++)
            {
                cmd.Transaction = myTransaction;//指定SQL命令语句　的事物
                cmd.CommandText = strSql[i];//给定命令语句
                cmd.ExecuteNonQuery();//执行SQL语句
            }
             * */
            int i = 0;
            /*
            while(i<strSql.Length)
            {
                cmd.Transaction = myTransaction;//指定SQL命令语句　的事物
                cmd.CommandText = strSql[i];//给定命令语句
                cmd.ExecuteNonQuery();//执行SQL语句
                i += 1;
            }*/
            /*
            do
            {
                cmd.Transaction = myTransaction;//指定SQL命令语句　的事物
                cmd.CommandText = strSql[i];//给定命令语句
                cmd.ExecuteNonQuery();//执行SQL语句
                i += 1;
            } while (i < strSql.Length);
             */
         
            foreach (string sql in strSql)//遍历
            {
                cmd.Transaction = myTransaction;//指定SQL命令语句　的事物
                cmd.CommandText = sql;//给定命令语句
                cmd.ExecuteNonQuery();//执行SQL语句
            }
            myTransaction.Commit();
            flag = true;
        }
        catch (Exception e)
        {
            myTransaction.Rollback();
            flag = false;
        }
        finally
        {
            clear();
        }
    
        return flag;
    }
}

 

       this.RadioButtonList1.DataTextField = "voteItem"; //指定要显示的字段
       this.RadioButtonList1.DataValueField = "voteDetailsID";//指定主键字段