Skip to main content

Paging in datalist databind control in asp.net

Always we need to implement DataList instead of GridView for custom design (unformated view) and there is a need of paging in DataList then what should do for paging there is lots of article in search engine for implementing paging in dataset but they are typically complicated to implement here is the simplest code for implemeting paging in DataList with PagedDataSource.

Paging in datalist in asp.net

The PagedDataSource class provided by asp.net is used to provide a paging facility to a DataBound control, such as DataList, Repeater, GridView, DetailsView, etc. Although there is an AllowPaging property to handle paging in these Gridview and DataGrid which internally use PagedDataSource class but not with Repeater and DataList we have to implement it manually through PagedDataSource.

Below is the code for that which have the functionality with Next, Previous, First and Last buttons.


PagedDataSource CS Part:
public int index {
    get {
        if (ViewState["index"] == null)
            return 0;
        else
            return Convert.ToInt32(ViewState["index"].ToString());
    }
    set{
        ViewState["index"] = value;
    }
}

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
        Bind();
}

private void Bind()
{
    DataTable dt = FillData();

    if (dt.Rows.Count > 0)
    {
        PagedDataSource _pageDataSource = new PagedDataSource();
        _pageDataSource.DataSource = dt.DefaultView;
        _pageDataSource.AllowPaging = true;
        _pageDataSource.PageSize = 5;
        _pageDataSource.CurrentPageIndex = index;
         ViewState["LastPage"] =  _pageDataSource .PageCount - 1;

        dlistSimilarAds.DataSource = _pageDataSource;
        dlistSimilarAds.DataBind();

        lnkPrev.Visible = !_pageDataSource.IsFirstPage;
        lnkNext.Visible = !_pageDataSource.IsLastPage;

        lnkFirst.Visible = !_ pageDataSource.IsFirstPage;
        lnkLast.Visible = !_ pageDataSource.IsLastPage;
    }
}
public DataTable FillData()
{
    DataSet ds = new DataSet();
    //Fetch data and fill your datatable
    return ds.Tables[0];
}




Next, Previous, First and Last button part:
protected void lnkNext_Click(object sender, EventArgs e)
{
    index += 1;
    Bind();
}
protected void lnkPrev_Click(object sender, EventArgs e)
{
    index -= 1;
    Bind();
}

protected void lnkFirst_Click(object sender, EventArgs e)
{
    index = 0;
    Bind();
}
protected void lnkLast_Click(object sender, EventArgs e)
{
    index = Convert.ToInt32(ViewState["LastPage"]);
    Bind();
}




Html Part:
<asp:DataList ID="dlistSimilarAds" RepeatColumns="3" RepeatDirection="Horizontal"
     runat="server">
 <ItemTemplate>
     <%--Your data here--%>
  </ItemTemplate>
</asp:DataList>

<asp:LinkButton runat="server" OnClientClick="onNext();" ID="lnkPrev" Text="" OnClick="lnkPrev_Click"> </asp:LinkButton>

<asp:LinkButton runat="server" OnClientClick="onNext();" ID="lnkNext" Text="" OnClick="lnkNext_Click"> </asp:LinkButton>

<asp:LinkButton runat="server" OnClientClick="onNext();" ID="lnkFirst" Text="" OnClick="lnkFirst_Click"> </asp:LinkButton>

<asp:LinkButton runat="server" OnClientClick="onNext();" ID="lnkLast" Text="" OnClick="lnkLast_Click"> </asp:LinkButton>

Popular posts from this blog

Uploading large file in chunks in Asp.net Mvc c# from Javascript ajax

Often we have a requirement to upload files in Asp.net, Mvc c# application but when it comes to uploading larger file, we always think how to do it as uploading large file in one go have many challenges like UI responsiveness, If network fluctuate for a moment in between then uploading task get breaks and user have to upload it again etc.

What is NameSpace in .Net

This a basic question which allways asked in the interview that what is the namespace ,do you know about namespace,can you tell me some words about namespace.

How to handle click event of linkbutton inside gridview

Recently I have posted how to sort only current page of gridview, Scrollble gridview with fixed header through javascript, File upload control inside gridview during postback and now i am going to explain how to handle click event of linkbutton or any button type control inside gridview.

We can handle click event of any button type control inside gridview by two way first is through event bubbling and second one is directly (in this type of event handling we need to access current girdviewrow container)

Scrollable Gridview with fixed headers in asp.net

horizontal and vertical scrollable Gridview with static header row.fixed header in gridview in asp.net.static header in gridview through java script.I was looking for a solution for this for a long time and found most of the answers are not working or not suitable for my situation i also find most of the java script code for that they worked but only with the vertical scroll not with the horizontal scroll and also combination of header and rows doesn't match.

how $document.ready() is different from window.onload()

we often use window.onload() in javascript and $document.ready() in jquery and assume that both are same just jquery library wrap up javascript window.onload() and introduce $document.ready() but no there is much difference between them below is the explanation -