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