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

Regular expression for alphanumeric with space in asp.net c#

How to validate that string contains only alphanumeric value with some spacial character and with whitespace and how to validate that user can only input alphanumeric with given special character or space in a textbox (like name fields or remarks fields). In remarks fields we don't want that user can enter anything, user can only able to enter alphanumeric with white space and some spacial character like -,. etc if you allow. Some of regular expression given below for validating alphanumeric value only, alphanumeric with whitspace only and alphanumeric with whitespace and some special characters.

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)

regex - check if a string contains only alphabets c#

How to validate that input string contains only alphabets, validating that textbox contains only alphabets (letter), so here is some of the ways for doing such task. char have a property named isLetter which is for checking if character is a letter or not, or you can check by the regular expression  or you can validate your textbox through regular expression validator in asp.net. Following code demonstrating the various ways of implementation.

How to validate dropdownlist in JavaScript

In this article you will see how to put validation in dropdownlist by javascript, suppose first item value of dropdownlist is 0 and text is "-Select-" just like given below and we have to validate that at least one item is selected excluding default i.e "-Select-".

Refreshing page in Javascript

In this article we will see that how to refresh or reload a page through Java Script there are a lot of ways to refresh or reload a document depending how we want (from server side