怎样用C#生成数据表? 请问怎样实现用c#写一段代码在SQL数据库中生成一个表? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 写个建表的SQL语句,然后用ExecuteNonQuery执行它 String CreateCmd = 建表SQL Server语句;SqlCommand Com = new SqlCommand(CreateCmd,Cn);Com.Connection.Open();Com.ExecuteNonQuery();Com.Connection.Close(); SqlCommand cmd=xxxSqlConn.CreateCommand();cmd.Command=@"CREATE TABLE [dbo].[RTblEQMProps] ( [IntID] [binary] (8) NOT NULL , [Z_BranchID_Z] [int] NOT NULL , [Z_VS_Z] [int] NOT NULL , [Z_VE_Z] [int] NOT NULL , [Col17000] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17001] [datetime] NULL , [Col17002] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17003] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17004] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17005] [bit] NULL , [Col17006] [smallint] NULL , [Col17007] [smallint] NULL , [Col17008] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17009] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17010] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17031] [smallint] NULL , [Col17011] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17012] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17014] [tinyint] NULL , [Col17058] [bit] NULL , [Col17013] [int] NULL , [Col17015] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17026] [int] NULL , [Col17033] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17034] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17035] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17036] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17037] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17039] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17040] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17042] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [Col17043] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]";cmd.ExecuteNonQuery(); cmd.CommandText==@"CREATE TABLE [dbo].[RTblEQMProps] (................刚少打了个"Text" 那 Connection = ?? Public Connection As New SqlClient.SqlConnection()Connection.ConnectionString="連數據庫代碼"你想在哪個數據庫中建表就連到哪個數據中去 FileStream与BinaryReader 一起使用~求解~~ 如何做出一个漂亮的界面? 子窗体打开的窗体如何设置它的父窗体 一个十分奇怪的问题,大家快来看看吧! 本人初学VC#,请各位帮忙一个关于添加事件的问题!!!1 寻找c#高手,解决一个问题,能够解决者付费 请教大数据量的问题 ★★关于的上网的开程序!★★ gridview里templatefield的headertext如何作按钮? C# 遍历右键二级菜单 新手提问,大家帮忙 冰天雪地跪求答案:那位达人能将这段代码转换成C#~~ 急急急~~~
SqlCommand Com = new SqlCommand(CreateCmd,Cn);Com.Connection.Open();
Com.ExecuteNonQuery();
Com.Connection.Close();
cmd.Command=@"CREATE TABLE [dbo].[RTblEQMProps] (
[IntID] [binary] (8) NOT NULL ,
[Z_BranchID_Z] [int] NOT NULL ,
[Z_VS_Z] [int] NOT NULL ,
[Z_VE_Z] [int] NOT NULL ,
[Col17000] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17001] [datetime] NULL ,
[Col17002] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17003] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17004] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17005] [bit] NULL ,
[Col17006] [smallint] NULL ,
[Col17007] [smallint] NULL ,
[Col17008] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17009] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17010] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17031] [smallint] NULL ,
[Col17011] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17012] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17014] [tinyint] NULL ,
[Col17058] [bit] NULL ,
[Col17013] [int] NULL ,
[Col17015] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17026] [int] NULL ,
[Col17033] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17034] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17035] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17036] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17037] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17039] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17040] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17042] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Col17043] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]";
cmd.ExecuteNonQuery();
................
刚少打了个"Text"
Public Connection As New SqlClient.SqlConnection()
Connection.ConnectionString="連數據庫代碼"你想在哪個數據庫中建表就連到哪個數據中去