[RESOLVED] GridView - Paging

I have a GRIDVIEW set up to show the records of my table, along with a scroll bar, but as the table is growing very quickly lately, the page takes a lot of time to load, because of the size of records within the table. 

Now I want to change the GRIDVIEW to allow PAGING, so each page should have about
15 records per page, how do I achieve this.

See below the GRIDVIEW script.

                    DataSourceID="NCRSDB" GridLines="None" CssClass="mGrid" PagerStyle-CssClass="pgr"
            AlternatingRowStyle-CssClass="alt" PageSize="20" AllowSorting="True">
            
            

 

HI ,

Please find below the articles explaining implementation of pagination in gridview:

http://www.c-sharpcorner.com/UploadFile/rohatash/gridview-paging-sample-in-Asp-Net/

http://www.codeproject.com/Articles/125541/Effective-Paging-with-GridView-Control-in-ASP-NET

http://www.youtube.com/watch?v=DxKchPWeALw

Hello

Set allow paging and  OnPageIndexChanging property of gridview

            DataSourceID="NCRSDB" GridLines="None" CssClass="mGrid" PagerStyle-CssClass="pgr"
            AlternatingRowStyle-CssClass="alt" PageSize="20" AllowSorting="True" Allowpaging="True"
OnPageIndexChanging="grdjob_pageindexChanged">

Then add in codebehind foloowinf OnPageIndexChanging event

  protected void grdjob_pageindexChanged(object sender, GridViewPageEventArgs e)
    {
        
        grdJob.PageIndex = e.NewPageIndex;
         ==== Bind Grid Here ====
    }

Thanks

Add ur source code in Gridview pageIndexChanging Event.

private void BindGridView()

{

 // ur code

}

In PageIndexChanging Event

u need to write,

{

ur Gridview_Name.pageIndex=e.newPageIndx...

BindGridView();

}

}

Not to sure what I am doing wrong, the script is not compiling correctly.

Private Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging

    grdjob_pageindexChanged(ByVal sender As Object, ByVal e As GridViewPageEventArgs)

    grdJob.PageIndex = e.NewPageIndexEnd Sub

    End Sub

HI,

use like this:

Sub GridView1_PageIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
   GridView1.pageIndex=e.newPageIndx...

    BindGridView();

end sub