Example #1
0
        public String GetCountBlog(String id)
        {
            string sql    = string.Empty;
            short  retval = 0;

            sql    = "SELECT ISNULL(COUNT(ID),0) FROM " + Functions.TABLEPREFIX + "BLOG where CATEGORIESID=" + id;
            retval = Convert.ToInt16(SQLMs.RunScalar(sql));
            return("" + retval);
        }
Example #2
0
        public bool GetCountBlog(int id)
        {
            string sql    = string.Empty;
            short  retval = 0;

            sql    = "SELECT ISNULL(COUNT(ID),0) FROM " + Functions.TABLEPREFIX + "BLOG where CATEGORIESID=" + id;
            retval = Convert.ToInt16(SQLMs.RunScalar(sql));
            if (retval > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            };
        }