Link button for previous and Next
<div>
<asp:LinkButton ID="lbtnPrev" Text="Previous" runat="server" OnClick="lbtnPrev_Click"></asp:LinkButton>
<asp:LinkButton ID="lbtnNext" Text="Next" runat="server" OnClick="lbtnNext_Click"></asp:LinkButton>
</div>
Use Skip() and Take()of LINQ to retrieve and skip items from product.
public partial class Product : System.Web.UI.Page
{
int pageSize=16;
int page = 1;
//page counting
protected void Bindproduct(int cid,int pid)
{
var res = (from i in dc.Product_MSTs
where i.ParentCatId == cid
orderby i.ProdId descending
select new
{
url = "ProductDetails.aspx?Cid=" + i.CatID + "&Pid=" + i.ProdId,
name = i.CateName,
ProdName=i.ProdName,
image = "UploadImages/" + i.Image1,
price = i.Price,
MrpPrice=i.MrpPrice,
}).ToList().Skip((page-1)*pageSize).Take(pageSize);
dlistProductDetails.DataSource = res;
dlistProductDetails.DataBind();
}
call click event of link button to retrieve data from database. and bind with page with method to
Bindproduct(cid, pid); extract exact data.
protected void lbtnPrev_Click(object sender, EventArgs e)
{
page--;
int cid = Convert.ToInt32(Request.QueryString["CatID"].ToString());
int pid = Convert.ToInt32(Request.QueryString["PId"].ToString());
Bindproduct(cid, pid);
}
protected void lbtnNext_Click(object sender, EventArgs e)
{
page++;
int cid = Convert.ToInt32(Request.QueryString["CatID"].ToString());
int pid = Convert.ToInt32(Request.QueryString["PId"].ToString());
Bindproduct(cid, pid);
}