动态创建sql数据库表代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】动态创建sql数据库表
作者:Dezai.CN / 发布于2012/1/17/ 593
<div><span style="color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">/必须的命名空间</span></div>
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">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 += " )";
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">//实例化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();
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">我的代码：
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">string tabName = "Job";
 string sqlStr = "create table ";
 sqlStr += tabName + "( ";
 sqlStr += "Id int identity(1,1) primary key,";
 //col0为列名，同样可以改为通过从textbox中获取
 //identity(1,1)是标记递增种子
 //primary key定义主键
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">sqlStr += "num int,";
 sqlStr += "Colour varchar(50),";
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">sqlStr += "Other varchar(50),";
 sqlStr += " )";
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">//实例化sql连接
 string sss = "Data Source=(local);Initial Catalog=" + dataconnect + ";Integrated Security=True";
 SqlConnection conn = new SqlConnection(sss );
 conn.Open();
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">//实例化sql命令
 SqlCommand cmd = new SqlCommand(sqlStr, conn);
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">//执行sql命令
 cmd.ExecuteNonQuery();
<p style="margin-top: 5px; margin-right: auto; margin-bottom: 5px; margin-left: auto; color: rgb(75, 75, 75); font-family: verdana, Arial, helvetica, sans-seriff; line-height: 19px; ">//关闭连接
 conn.Close();
试试其它关键字
　动态创建sql数据库表　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)