>>>偶想把如下字符串送给一个string变量,不知如何设置?string s = @"EXEC sp_attach_db @dbname = N'tour',
@filename1 = N'F:\clj\tour_Data.mdf',
@filename2 = N'F:\clj\tour_log.ldf'";orstring s = @"EXEC sp_attach_db @dbname = N'tour', @filename1 = N'F:\clj\tour_Data.mdf', @filename2 = N'F:\clj\tour_log.ldf'";or you mean?string sDBName = "tour";
string sFileName1 = @"F:\clj\tour_Data.mdf";
string sFileName2 = @"F:\clj\tour_log.ldf";string s = String.Format("EXEC sp_attach_db @dbname = N'{0}', @filename1 = N'{1}', @filename2 = N'{2}'", sDBName, sFileName1, sFileName2);
@filename1 = N'F:\clj\tour_Data.mdf',
@filename2 = N'F:\clj\tour_log.ldf'";orstring s = @"EXEC sp_attach_db @dbname = N'tour', @filename1 = N'F:\clj\tour_Data.mdf', @filename2 = N'F:\clj\tour_log.ldf'";or you mean?string sDBName = "tour";
string sFileName1 = @"F:\clj\tour_Data.mdf";
string sFileName2 = @"F:\clj\tour_log.ldf";string s = String.Format("EXEC sp_attach_db @dbname = N'{0}', @filename1 = N'{1}', @filename2 = N'{2}'", sDBName, sFileName1, sFileName2);
string strSQL = @"EXEC sp_attach_db @dbname = N'tour',
@filename1 = N'F:\clj\tour_Data.mdf',
@filename2 = N'F:\clj\tour_log.ldf'";
//新建数据库连接
string strConn="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=tour;"; SqlConnection myConn=new SqlConnection(strConn);
//打开数据库
myConn.Open();
//新建Sql命令
SqlCommand myCommand=new SqlCommand();
//设置Sql命令属性
myCommand.Connection=myConn;
myCommand.CommandText=strSQL;
myCommand.CommandType=CommandType.StoredProcedure;
//执行数据库查询
myCommand.ExecuteNonQuery();
//取消命令
myCommand.Dispose();
myConn.Close();
string strConn="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=master;";3.
comment out
//myCommand.CommandType=CommandType.StoredProcedure;
按照你提示我的写法,还是不行!
能帮我想帮吗?
难道
string strSQL = @"EXEC sp_attach_db @dbname = N'tour',
@filename1 = N'F:\clj\tour_Data.mdf',
@filename2 = N'F:\clj\tour_log.ldf'";
这个代码不能实现吗?