public int totalPage() { if (keywork == null) { return(0); } query = "SELECT COUNT(*) FROM dbo.Product WHERE "; query += " name LIKE '%" + keywork + "%' "; query += " OR tag_name LIKE '%" + keywork + "%'"; int total = connect.getCount(query); float b = (float)total / (float)recordPerPage; if (b != (float)(int)b) { return((int)b + 1); } return((int)b); }
public int totalPage(string category) { string query = ""; if (category == null) { query = "SELECT COUNT(*) FROM dbo.Product"; } else { query = "SELECT COUNT(*) FROM dbo.Product WHERE tag_name='" + category + "'"; } int total = connect.getCount(query); float b = (float)total / (float)recordPerPage; if (b != (float)(int)b) { return((int)b + 1); } return((int)b); }