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