日期:2014-05-17  浏览次数:20442 次

asp.net 在登录界面上判断是否存在数据库DB_Happy,急 急 急
asp。net在登录界面上判断是否存在数据库DB_Happy 如果有的话就不用再附加了, 如果没有则附加一个数据库DB_Happy


请大家把代码写的详细一点,如果有用马上给分! 谢谢了

------解决方案--------------------
string str = "select name from sysdatabases WHERE name='RfIDMeeting'";
SqlCommand myCommand = new SqlCommand(str, myConn);
string haha = Convert.ToString(myCommand.ExecuteScalar());
if (haha != "RfIDMeeting") //不存在数据库
{
//str = "IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'" + DbName + "')" + "begin EXEC sp_detach_db " + DbName + " end " + "EXEC sp_attach_db @dbname ='MarryHappy',@filename1=N'" + strMdf + "',@filename2=N'" + strLdf + "'";
str = "EXEC sp_attach_db @dbname ='RfIDMeeting',@filename1=N'" + strMdf + "',@filename2=N'" + strLdf + "'";
myCommand = new SqlCommand(str, myConn);
myCommand.ExecuteNonQuery();
}


照这种方式改你要的代码就可以了