判断数据库是否存在相同数据

判断数据库是否存在相同数据,是常常用到一个功能,除了select外,还有其他方法吗?在这也向大家请教一下!

(UrlAdd.aspx.cs)中示例代码

//判断网址是否存在

            if (Navigation.BeUrl(url))
            {
                sperror.InnerText = "网址你已经存在数据库了!";
                return;
            }

查询网址是否存在数据库

public static bool BeUrl(string url)
        {
            string sql = "SELECT count(1) FROM [navurl] WHERE [url]=@url";
            SqlParameter parameters = new SqlParameter("@url", SqlDbType.VarChar,50);
            parameters.Value = url;
            return DbHelper.Exists(sql, parameters);
           

        }

 DbHelper部分代码

     #region 查询是否存在相同数据

         public static bool Exists(string strSql)
        {
            object obj = DbHelper.GetSingle(strSql);
            int cmdresult;
            if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
            {
                cmdresult = 0;
            }
            else
            {
                cmdresult = int.Parse(obj.ToString());
            }
            if (cmdresult == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
        }
        public static bool Exists(string strSql, params SqlParameter[] cmdParms)
        {
            object obj = DbHelper.GetSingle(strSql, cmdParms);
            int cmdresult;
            if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
            {
                cmdresult = 0;
            }
            else
            {
                cmdresult = int.Parse(obj.ToString());
            }
            if (cmdresult == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
        }
        #endregion

转载于:https://www.cnblogs.com/lgh/archive/2008/12/12/1353489.html