t not bale to set the firts / next, prev, last
& record values properly
i have used session variables for this
i have
pagesize=100;
Session["TotalRows"] = GetTotalRows();
Session["LastPageIndex"] = Convert.ToInt32(Session["TotalRows"]) / pagesize;
int pageindex = Convert.ToInt32(Session["PageIndex"]);
public int GetTotalRows()
{
SqlCommand com = new SqlCommand("select count(*) from tbl", conn);
conn.Open();
SqlDataReader reader = com.ExecuteReader(CommandBehavior.SingleRow);
reader.Read();
int totalRows = Convert.ToInt32(reader[0]);
conn.Close();
return totalRows;
}