c# asp .net 動態建立sql資料庫表的方法

複製代碼 代碼如下://必須的命名空間
using System;
using System.Data;
using System.Data.SqlClient;
//中間常規內容略
string tabName = "table1";
//聲明要建立的表名，你也可以改為從textbox中擷取；
string sqlStr = "create table ";
sqlStr += tabName + "( ";
sqlStr += "col0 numeric identity(1,1) primary key,";
//col0為列名，同樣可以改為通過從textbox中擷取
//identity(1,1)是標記遞增種子
//primary key定義主鍵
sqlStr += "col1 varchar(20),";
sqlStr += "col2 smalldatetime,";
sqlStr += "col3 varchar(20),";
sqlStr += "col4 int,";
sqlStr += "col5 varchar(20),";
sqlStr += " )";

//執行個體化sql串連
SqlConnection conn = new SqlConnection("server=.; database=dbName; uid=sa; pwd=sa");
conn.Open();
//執行個體化sql命令
SqlCommand cmd = new SqlCommand(sqlStr, conn);
//執行sql命令
cmd.ExecuteNonQuery();
//關閉串連
conn.Close();

My Code：複製代碼 代碼如下: string tabName = "Job";
string sqlStr = "create table ";
sqlStr += tabName + "( ";
sqlStr += "Id int identity(1,1) primary key,";
//col0為列名，同樣可以改為通過從textbox中擷取
//identity(1,1)是標記遞增種子
//primary key定義主鍵

sqlStr += "num int,";
sqlStr += "Colour varchar(50),";

sqlStr += "Other varchar(50),";
sqlStr += " )";

//執行個體化sql串連
string sss = "Data Source=(local);Initial Catalog=" + dataconnect + ";Integrated Security=True";
SqlConnection conn = new SqlConnection(sss );
conn.Open();

//執行個體化sql命令
SqlCommand cmd = new SqlCommand(sqlStr, conn);

//執行sql命令
cmd.ExecuteNonQuery();

//關閉串連
conn.Close();