日期:2014-05-19  浏览次数:20449 次

asp.net打包附加数据库
private   void   CreateDataBase(string   DataName,string   strMdf,string   strLdf)
{
String   str;
SqlConnection   myConn   =   new   SqlConnection   ();
myConn.ConnectionString   =string.Format( "server={0};   user   id={1};   password={2};   Database={3} ",this.Context.Parameters[ "server "],this.Context.Parameters[ "user "],this.Context.Parameters[ "pwd "],this.Context.Parameters[ "dbname "]);
//EXEC   sp_detach_db   @dbname   =   'BX_FreightMileage_2 '//需要先将数据库分离出来
str   =   "EXEC   sp_attach_db   @dbname   =   ' "+   DataName   + " ',   @filename1   =   ' "+   strMdf   + " ',@filename2= ' "+strLdf+ " ' ";
SqlCommand   myCommand   =   new   SqlCommand(str,   myConn);
   
myConn.Open();
myCommand.ExecuteNonQuery();
myConn.Close();
   
}  
错误提示   用户sa   登陆失败。打包时的连接数据库字符串应如何改写??

------解决方案--------------------
连接的代码写在web.config里面不就行了吗?
------解决方案--------------------
up
------解决方案--------------------
up