Paging in datalist using PagedDataSource class

Satyapriya Nayak
13y
6.2k
0
0
25
Blog

Paging with datalist using PagedDat

In this blog we will know how to do Paging in datalist using PagedDataSource class.
Drag and drop a DataList control, one label, and two buttons controls to the WebPages.

Table structure

Program

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
 <title>Untitled Page</title>
</head>
<body>
 <form id="form1" runat="server">
 <div>
 <table border="1">
 <asp:DataList ID="dl1" runat="server">
 <HeaderTemplate>
 Employee Details
 </HeaderTemplate>
 <itemtemplate>
 <tr>
 <td>ID</td>
 <td>NAME</td>
 <td>SALARY</td>
 <td>ADDRESS</td>
 <td>DESIGNATION</td>
 </tr>
 <tr>
 <td> <%#Eval("empid")%></td>
 <td> <%#Eval("empname")%></td>
 <td> <%#Eval("empsal")%></td>
 <td> <%#Eval("empadd")%></td>
 <td> <%#Eval("empdes")%></td>
 </tr>
 </itemtemplate>
 </asp:DataList>
 </table>
 <table width="100%" border="0">
 <tr>
 <td> <asp:label id="lbl1" runat="server" BackColor="Yellow" BorderColor="Yellow"
 Font-Bold="True" ForeColor="#FF3300"></asp:label></td>

</tr>
 <tr>
 <td> <asp:button id="btnPrevious" runat="server" text="Previous" Width="60px"
 onclick="btnPrevious_Click"></asp:button>
 <asp:button id="btnNext" runat="server" text="Next" Width="60px"
onclick="btnNext_Click"></asp:button></td>

</tr>
</table>
</div>
</form>
</body>
</html>

Default.aspx.vb code

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    string strConnString =
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    string str ;
    SqlCommand com;
    SqlDataAdapter sqlda;
    DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            binddatalist();
        }
    }
    private void binddatalist()
    {
        SqlConnection con = new SqlConnection(strConnString);
        con.Open();
        str = "select * from employee";
        com = new SqlCommand(str, con);
        sqlda = new SqlDataAdapter(com);
        ds = new DataSet();

        sqlda.Fill(ds, "employee");
        PagedDataSource Pds1 = new PagedDataSource();
        Pds1.DataSource = ds.Tables[0].DefaultView;
        Pds1.AllowPaging = true;
        Pds1.PageSize = 3;
        Pds1.CurrentPageIndex = CurrentPage;
        lbl1.Text = "Showing Page: " + (CurrentPage + 1).ToString() + " of " +
Pds1.PageCount.ToString();
        btnPrevious.Enabled = !Pds1.IsFirstPage;
        btnNext.Enabled = !Pds1.IsLastPage;
        dl1.DataSource = Pds1;
        dl1.DataBind();
        con.Close();
    }
    public int CurrentPage
    {
        get
        {
            object s1 = this.ViewState["CurrentPage"];
            if (s1 == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(s1);
            }
        }
        set { this.ViewState["CurrentPage"] = value; }
    }

    protected void btnPrevious_Click(object sender, EventArgs e)
    {
        CurrentPage -= 1;
        binddatalist();
    }
    protected void btnNext_Click(object sender, EventArgs e)
    {
        CurrentPage += 1;
binddatalist();
     }
}