C# 创建数据库 (分不多,小弟先谢了) 因为数据库比较大,所以逐句的写很费时,记得以前用 VB 可以 用 *.mdf 和 *.ldf 这两个文件创建数据库那 C# 中 怎么写呢?望高手指点一二 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 可以用SQL Server自己带的RESTORE来处理,RESTORE DATABASE { database_name | @database_name_var } < file_or_filegroup > [ ,...n ] [ FROM < backup_device > [ ,...n ] ] [ WITH [ RESTRICTED_USER ] [ [ , ] FILE = { file_number | @file_number } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ] [ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ] [ ,...n ] [ [ , ] NORECOVERY ] [ [ , ] { NOREWIND | REWIND } ] [ [ , ] { NOUNLOAD | UNLOAD } ] [ [ , ] REPLACE ] [ [ , ] RESTART ] [ [ , ] STATS [ = percentage ] ] ] SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);SqlCommand comm=new SqlCommand();comm.Connection=conn; string sql="";sql="CREATE TABLE @tablename";sql+="( ";sql+="date_in datetime,";sql+="user_id int,";sql+="myuser_name varchar(200)";sql+=")";comm.CommandText=sql;SqlParameter parm1=new SqlParameter("@tablename",SqlDbType.VarChar(20));parm1.Value=s;comm.Parameters.Add(parm1);conn.Open();comm.ExecuteNonQuery(); 恩,我已经找到方法了,回复人: singlepine(小山) ( ) 信誉:178 的回答 还算靠普,所以分给你 c# excel 插件 在别的电脑上怎么样注册 如何把一个DataTable分成多个DataTble c# 监视注册表改动! 高人帮个忙 在线查看word文档 怎么打开一个已有的excel 文件? 如何在一个页面获取文件,但不实行上传,而在另一个页面实现上传的操作呢(急) 高手请进!一个经典难题?~~~在线等 交通银行支付接口 MFC中的单文档多视在C#中如何实现,求代码~!!!!!!!分不够再加~~ 一个时间转换问题 求师
RESTORE DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [ , ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ]
[ ,...n ]
[ [ , ] NORECOVERY ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]
SqlCommand comm=new SqlCommand();
comm.Connection=conn;
string sql="";
sql="CREATE TABLE @tablename";
sql+="( ";
sql+="date_in datetime,";
sql+="user_id int,";
sql+="myuser_name varchar(200)";
sql+=")";
comm.CommandText=sql;
SqlParameter parm1=new SqlParameter("@tablename",SqlDbType.VarChar(20));
parm1.Value=s;
comm.Parameters.Add(parm1);
conn.Open();
comm.ExecuteNonQuery();
的回答 还算靠普,所以分给你