Repeater Paging with Next and Previous Button in ASP.Net

Here I have created sample that will help you out.

HTML

<div>
    <table class="Repeater" cellspacing="0" rules="all" border="1">
        <tr>
            <th scope="col" style="width: 80px">
                Customer Id
            </th>
            <th scope="col" style="width: 150px">
                Customer Name
            </th>
            <th scope="col" style="width: 150px">
                Company Name
            </th>
        </tr>
        <asp:Repeater ID="rptCustomers" runat="server">
            <ItemTemplate>
                <tr>
                    <td>
                        <asp:Label ID="lblCustomerId" runat="server" Text='<%# Eval("CustomerId") %>' />
                    </td>
                    <td>
                        <asp:Label ID="lblContactName" runat="server" Text='<%# Eval("ContactName") %>' />
                    </td>
                    <td>
                        <asp:Label ID="lblCompanyName" runat="server" Text='<%# Eval("CompanyName") %>' />
                    </td>
                </tr>
            </ItemTemplate>
        </asp:Repeater>
    </table>
    <br />
    <div>
        <asp:LinkButton ID="lbtnPrev" runat="server" CausesValidation="false" CommandArgument='<%# Eval("Text") %>'
            OnClick="Page_Changed" Visible="false" Text="Previous Page" ToolTip="Previous"
            Font-Bold="true">
        </asp:LinkButton>
        &nbsp;&nbsp;
        <asp:LinkButton ID="lbtnNext" runat="server" CausesValidation="false" OnClick="Page_Changed"
            ToolTip="Next" CommandArgument='<%# Eval("Text") %>' Text="Next Page" Font-Bold="true">
        </asp:LinkButton>
    </div>
</div>

C#

private int PageSize = 10;
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.GetCustomersPageWise(1);
    }
}

private void GetCustomersPageWise(int pageIndex)
{
    string constring = ConfigurationManager.ConnectionStrings["constring"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("Customers_GetCustomersPageWise", con))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
            cmd.Parameters.AddWithValue("@PageSize", PageSize);
            cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
            cmd.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
            con.Open();
            IDataReader idr = cmd.ExecuteReader();
            rptCustomers.DataSource = idr;
            rptCustomers.DataBind();
            idr.Close();
            con.Close();
            int recordCount = Convert.ToInt32(cmd.Parameters["@RecordCount"].Value);
            this.PopulatePager(recordCount, pageIndex);
        }
    }
}

private void PopulatePager(int recordCount, int currentPage)
{
    double dblPageCount = (double)((decimal)recordCount / (decimal)PageSize);
    int pageCount = (int)Math.Ceiling(dblPageCount);
    if (pageCount > 0)
    {
        if (currentPage == 1)
        {
            lbtnPrev.Visible = false;
        }
        else
        {
            lbtnPrev.CommandArgument = (currentPage - 1).ToString();
            lbtnPrev.Visible = true;
        }
        if (currentPage > dblPageCount)
        {
            lbtnNext.Visible = false;
        }
        else
        {
            lbtnNext.CommandArgument = (currentPage + 1).ToString();
            lbtnNext.Visible = true;
        }
    }
}

protected void Page_Changed(object sender, EventArgs e)
{
    int pageIndex = int.Parse((sender as LinkButton).CommandArgument);
    this.GetCustomersPageWise(pageIndex);
}

Screenshot

I have Tried and solved this problem ... this problem can be solved like below also.

I appreciate your answer ie also helpful thanks.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class datalist_pagination : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbcon"].ConnectionString);
    SqlDataAdapter dap;
    DataTable dtp = new DataTable();
    PagedDataSource pds;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            loadRecord(0);
        }
    }

    private void loadRecord(int getPageNo)
    {
        dap = new SqlDataAdapter("select CompanyName,ContactName,ContactTitle,City,Address from Customers", conn);
        dap.Fill(dtp);

        pds = new PagedDataSource();
        pds.DataSource = dtp.DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 12;

        Session["CPNo"] = getPageNo;

        if (getPageNo > (pds.PageCount - 1))
            getPageNo = pds.PageCount - 1;
        if (getPageNo < 0)
            getPageNo = 0;

        pds.CurrentPageIndex = getPageNo;

        if (dtp.Rows.Count > 0)
        {
            dtlistEmp.DataSource = pds;
            dtlistEmp.DataBind();
        }
        else
        { }


        //enable & disabled previous and Next button
        if (pds.IsLastPage)
            lnkbuttonNext.Enabled = false;
        else
            lnkbuttonNext.Enabled = true;

        if (pds.IsFirstPage)
            lnkbuttonPrev.Enabled = false;
        else
            lnkbuttonPrev.Enabled = true;
    }
    protected void lnkbuttonNext_Click(object sender, EventArgs e)
    {
        Session["CPNo"] = (int.Parse(Session["CPNo"].ToString()) + 1).ToString();
        loadRecord(int.Parse(Session["CPNo"].ToString()));
    }
    protected void lnkbuttonPrev_Click(object sender, EventArgs e)
    {
        Session["CPNo"] = (int.Parse(Session["CPNo"].ToString()) - 1).ToString();
        loadRecord(int.Parse(Session["CPNo"].ToString()));
    }
}