Asp.net gridview custom paging example like Numeric, first, previous, next and last

By: Suresh Dasari Mar 26, 2011

Introduction:

Here I will explain how to show the gridview with custom paging like numeric first, previous, next, last in asp.net

Description:

In previous post I explained gridview with different types of paging with available paging options in gridview but now if we want to display the gridview with custom paging like Numeric, first, previous, next and last for that we need to write some code to show the gridview paging like what we except and here I used gridview with pagertemplate to create the paging in gridview effectively for that create new website and design the aspx page like this

<title>Show Gridview To</title>

.Gridview

{

font-family:Verdana;

font-size:11pt;

font-weight:normal;

color:black;

width:350px;

}

.Linkbutton

{

color:White;

}

</style>

</head>

<body>

<div>

<asp:GridView ID="gvEmpDetails" runat="server" CssClass="Gridview" PageSize="5" AllowPaging="true" DataSourceID="dsEmpdetails" OnRowCreated= "gvEmpDetails_RowCreated" OnDataBound="gvEmpDetails_DataBound" >

<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Page" CommandArgument="First" CssClass="Linkbutton">First</asp:LinkButton>

<asp:Label ID="pmore" runat="server" Text="..."></asp:Label>

<asp:LinkButton ID="LinkButton2" runat="server" CommandName="Page" CommandArgument="Prev" CssClass="Linkbutton">Pre</asp:LinkButton>

<asp:LinkButton ID="p0" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>

<asp:LinkButton ID="p1" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>

<asp:LinkButton ID="p2" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>

<asp:Label ID="CurrentPage" runat="server" Text="Label"></asp:Label>

<asp:LinkButton ID="p4" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>

<asp:LinkButton ID="p5" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>

<asp:LinkButton ID="p6" runat="server" CssClass="Linkbutton">LinkButton</asp:LinkButton>

<asp:LinkButton ID="LinkButton3" runat="server" CommandName="Page" CommandArgument="Next" CssClass="Linkbutton">Next</asp:LinkButton>

<asp:Label ID="nmore" runat="server" Text="..."></asp:Label>

<asp:LinkButton ID="LinkButton4" runat="server" CommandName="Page" CommandArgument="Last" CssClass="Linkbutton">Last</asp:LinkButton>

</PagerTemplate>

</asp:GridView>

<asp:SqlDataSource ID="dsEmpdetails" runat="server" ConnectionString="<%$ConnectionStrings:dbconnection %>"

SelectCommand="select * from Country" >

</asp:SqlDataSource>

</div>

</form>

</body>

</html>

After that write the following code in code behind for gridview custom paging

protected void gvEmpDetails_DataBound(object sender, EventArgs e)

{

GridViewRow gvrow = gvEmpDetails.BottomPagerRow;

Label lblcurrentpage = (Label)gvrow.Cells[0].FindControl("CurrentPage");

lblcurrentpage.Text = Convert.ToString(gvEmpDetails.PageIndex + 1);

int[] page = new int[7];

page[0] = gvEmpDetails.PageIndex - 2;

page[1] = gvEmpDetails.PageIndex - 1;

page[2] = gvEmpDetails.PageIndex;

page[3] = gvEmpDetails.PageIndex + 1;

page[4] = gvEmpDetails.PageIndex + 2;

page[5] = gvEmpDetails.PageIndex + 3;

page[6] = gvEmpDetails.PageIndex + 4;

for (int i = 0; i < 7; i++)

{

if (i != 3)

{

if (page[i] < 1 || page[i] > gvEmpDetails.PageCount)

{

LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("p" + Convert.ToString(i));

lnkbtn.Visible = false;

}

else

{

LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("p" + Convert.ToString(i));

lnkbtn.Text = Convert.ToString(page[i]);

lnkbtn.CommandName = "PageNo";

lnkbtn.CommandArgument = lnkbtn.Text;

}

if (gvEmpDetails.PageIndex == 0)

{

LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton1");

lnkbtn.Visible = false;

lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton2");

lnkbtn.Visible = false;

}

if (gvEmpDetails.PageIndex == gvEmpDetails.PageCount - 1)

{

LinkButton lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton3");

lnkbtn.Visible = false;

lnkbtn = (LinkButton)gvrow.Cells[0].FindControl("LinkButton4");

lnkbtn.Visible = false;

}

if (gvEmpDetails.PageIndex > gvEmpDetails.PageCount - 5)

{

Label lbmore = (Label)gvrow.Cells[0].FindControl("nmore");

lbmore.Visible = false;

}

if (gvEmpDetails.PageIndex < 4)

{

Label lbmore = (Label)gvrow.Cells[0].FindControl("pmore");

lbmore.Visible = false;

}

void lb_Command(object sender, CommandEventArgs e)

{

gvEmpDetails.PageIndex = Convert.ToInt32(e.CommandArgument) - 1;

}

protected void gvEmpDetails_RowCreated(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.Pager)

{

GridViewRow gvr = e.Row;

LinkButton lb = (LinkButton)gvr.Cells[0].FindControl("p0");