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 登陆失败。打包时的连接数据库字符串应如何改写??
{
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 登陆失败。打包时的连接数据库字符串应如何改写??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货