c# asp .net 动态创建sql数据库表的方法

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();

（编辑：威海站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!