用StringBuilder动态建表与插入数据

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Data;

 

//连接字符串，可修改
    string ConnectionString = "Data Source=A-FA8619ED2B234//SQLEXPRESS;Initial Catalog=test;User ID=wxg;Password=test";
  
      

            /// <summary>
            /// 判断是否存在表
            /// </summary>
            /// <param name="table">表名</param>
            /// <returns></returns>
            public bool HasTable(string table)
            {

                SqlConnection conn = new SqlConnection(ConnectionString);
                string strSql = "select * from dbo.sysobjects where id = object_id(N'[dbo].[" + table + "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1";
                conn.Open();
                SqlCommand cmd = new SqlCommand(strSql, conn);
                SqlDataReader dr = cmd.ExecuteReader();
                return dr.Read();

            }
       
        /// <summary>
            /// 动态建表
            /// </summary>
            /// <param name="ProjectID">以项目号作为表名,如123</param>
            ///<param name="PollID">问卷编号</param>
            ///<param name="Answer">答案列名</param>
            ///<param name="Len">全部列的长度数组</param>
          
        public void CreateTable(string ProjectID, string PollID, string Answer, int[] Len)
            {
                SqlConnection conn = new SqlConnection(ConnectionString);

                //如果有同名表存在
                if (HasTable(ProjectID))
                {
                    MessageBox.Show("表" +