判断数据库、数据表是否存在

 

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