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("表" +