/// <summary>
/// 判断数据库是否存在
/// </summary>
/// <param name="db">数据库的名称</param>
/// <param name="connKey">数据库的连接Key</param>
/// <returns>true:表示数据库已经存在；false，表示数据库不存在</returns>
public Boolean IsDBExist(string db, string connKey)
{
Helper.SQLSERVER.SqlServer_tool SqlServer_tool = new Helper.SQLSERVER.SqlServer_tool();
//string connToMaster = ConfigurationManager.ConnectionStrings[connKey].ToString();
string createDbStr = " select * from master.dbo.sysdatabases where name " + "= '" + db + "'";
bool dt_count = SqlServer_tool.Select_count(createDbStr, connKey);
return(dt_count);
}
/// <summary>
/// 判断数据库表是否存在
/// </summary>
/// <param name="db">数据库</param>
/// <param name="tb">数据库表名</param>
/// <param name="connKey">连接数据库的key</param>
/// <returns></returns>
public Boolean IsTableExist(string db, string tb, string connKey)
{
Helper.SQLSERVER.SqlServer_tool SqlServer_tool = new Helper.SQLSERVER.SqlServer_tool();
//string connToMaster = ConfigurationManager.ConnectionStrings[connKey].ToString();
string createDbStr = "use " + db + " select 1 from sysobjects where id = object_id('" + tb + "') and type ='U'";
//在指定的数据库中 查找该表是否存在
bool dt_count = SqlServer_tool.Select_count(createDbStr, connKey);
return(dt_count);
}