读书人

asp.net打包附加数据库解决办法

发布时间: 2012-02-03 22:02:47 作者: rapoo

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

读书人网 >asp.net

热点推荐