/// <summary> /// 判断数据库是否存在 /// </summary> /// <param name="databaseName"></param> /// <returns></returns> private static bool DataBaseIsExist(string databaseName) { int i = 0; try { using (SqlConnection conn = new SqlConnection(_connectString)) { conn.Open(); string sql = string.Format("select COUNT(*) from sys.databases where name='{0}' ", databaseName); using (SqlCommand comm = new SqlCommand(sql, conn)) { i = Convert.ToInt32(comm.ExecuteScalar()); } } } catch (Exception) { } return i > 0; } /// <summary> /// 判断数据表是否存在 /// </summary> /// <param name="tableName">表名</param> /// <returns></returns> private static bool DataTabelIsExist(string tableName) { int i = 0; try { using (SqlConnection conn = new SqlConnection(_connectString)) { conn.Open(); string sql = string.Format("use aqmdb select COUNT(*) from sysobjects where name='{0}'", tableName); using (SqlCommand comm = new SqlCommand(sql, conn)) { i = Convert.ToInt32(comm.ExecuteScalar()); } } } catch (Exception) { } return i > 0; }