Pagination in asp.net Listview control using Datapager - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

Pagination in asp.net Listview control using Datapager

Introduction: In this article I will explain how to implement the paging in asp.net listview control using datapager without using datasource control

Description:
To implement this functionality add a webform to project. Drag and drop the listview and datapager control from toolbox to webform.

HTML markup of webpage:
    <table>
    <tr><td>
        <asp:ListView ID="ListView1" runat="server"
            onpagepropertieschanging="ListView1_PagePropertiesChanging">
        <LayoutTemplate>        
        <table>
  <tr>
  <th>Student Name</th>
  <th>Student Address</th>
  <th>Student Class</th> 
     </tr>
    <tr id="itemPlaceholder" runat="server"></tr>
        </LayoutTemplate>
        <ItemTemplate>
         <tr align="center">
       <td> <asp:Label ID="lblstudentname" runat="server" Text='<%#Eval("Student_Name")%>'></asp:Label></td>
         <td><asp:Label ID="lbladdress" runat="server" Text='<%#Eval("Student_Address") %>'></asp:Label></td>
          <td><asp:Label ID="lblroll" runat="server" Text='<%#Eval("RollNo") %>'></asp:Label></td>
</tr>
        </ItemTemplate>     
        </asp:ListView>
        </td></tr>
        <tr><td></td></tr>
        <tr><td><asp:DataPager ID="DataPager1" runat="server" PagedControlID="ListView1" PageSize="3">
        <Fields><asp:NextPreviousPagerField ButtonType="Link" ShowFirstPageButton="false" ShowPreviousPageButton="true"
                            ShowNextPageButton="false" />
                        <asp:NumericPagerField ButtonType="Link" />
                        <asp:NextPreviousPagerField ButtonType="Link" ShowNextPageButton="true" ShowLastPageButton="false" ShowPreviousPageButton = "false" />
                    </Fields>
        </asp:DataPager></td></tr>
        </table> 

After that write the code to bind the listview.
Add the namespaces
C#:-
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

VB:-
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Create a connection.
C#:-
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ToString());

VB:-
Private con As New SqlConnection(ConfigurationManager.ConnectionStrings("connection").ToString())

Write the code to bind the listview
C#:-
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bindlist();
        }
    }
    public void Bindlist()
    {
        SqlDataAdapter adp = new SqlDataAdapter("Select * from Tb_Student", con);
        DataTable dt = new DataTable();
        adp.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            ListView1.DataSource = dt;
            ListView1.DataBind();
        }
    }  

VB:-
Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            Bindlist()
        End If
    End Sub
    Public Sub Bindlist()
        Dim adp As New SqlDataAdapter("Select * from Tb_Student", con)
        Dim dt As New DataTable()
        adp.Fill(dt)
        If dt.Rows.Count > 0 Then
            ListView1.DataSource = dt
            ListView1.DataBind()
        End If
    End Sub

When page is changed onpagepropertieschanging event is triggered. So we write the code on this event to implement the paging.
C#:-
protected void ListView1_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
    {
        DataPager1.SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
        Bindlist();
    }
 VB:-
Protected Sub ListView1_PagePropertiesChanging(sender As Object, e As System.Web.UI.WebControls.PagePropertiesChangingEventArgs) Handles ListView1.PagePropertiesChanging
        DataPager1.SetPageProperties(e.StartRowIndex, e.MaximumRows, False)
        Bindlist()
    End Sub

Build, run the project and see the result.
Result:-
Pagination in asp.net Listview control using Datapager

In this article we have learn how to implement the pagination in asp.net listview control using datapager without using datasource control (C#,VB). I hope you enjoyed this article. 

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon