/// <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); }