PageIndexChanging in GridView in ASP.NET

Question

I have a gridview which I am using to display a dataset result. The problem is I am using paging in it. But when I click on the page # it says that I haven't handled the event. Do I need to rebind the dataset???

Thanks

score 36 · Accepted Answer · edited Jan 12 '11 at 05:41

36

Try the following code:

protected void grdView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    FillGrid();
    grdView.PageIndex = e.NewPageIndex;
    grdView.DataBind();
}

edited Jan 12 '11 at 05:41

Cody Gray - on strike

239,200
50
490
574

answered Jan 12 '11 at 05:30

KGWR

396
3
6

Thanks.. This works... I didn't know this pageindex incrementing before. – JCTLK Jan 12 '11 at 05:32
1

`Viewstate` should be preferred to avoid excessive db calls on page Change events – Vikrant May 07 '15 at 12:46

score 4 · Answer 2 · edited Sep 01 '13 at 15:02

Try it

In the pageload

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        loadGrid();
    }
}

In the pageindexchanging

private void loadGrid()
{
    using (your_bankEntities context = new your_bankEntities()) //use your connection .edmx
    {
        var jmDados = (from jm in context.yourdbo  orderby jm.your fieldkey  
                         select new
                           {
                               jm.Field1,
                               jm.Field2,
                               jm.Field3,
                               jm.Field4,
                               ........ 
                               jm.n

                           }).ToList();
        GridView1.DataSource = jmDados;

        GridView1.DataBind();
    }
}

In the pageindexchanging

GridView1.PageIndex = e.NewPageIndex;

loadGrid();

score 3 · Answer 3 · answered Mar 04 '19 at 02:46

You should set the .PageIndex before binding data! Otherwise, you would need extra clicks which actually double the BindData method calls. The following is my tested vb code.

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

    GridViewL.PageIndex = e.NewPageIndex
    BindData()  ' your method to bind data to the grid
End Sub

score 1 · Answer 4 · edited Oct 26 '15 at 06:31

1

In VB.net, it does not have much difference with C#, you just remove the semicolons at the end of each line

Private Sub myGridview_PageIndexChanging(sender As Object, e As GridViewPageEventArgs) Handles myGridview.PageIndexChanging

   LoadGridView() //Call your method to load the data into the grid.
   myGridview.PageIndex = e.NewPageIndex
   myGridview.DataBind()

End Sub

edited Oct 26 '15 at 06:31

G K

2,481
4
29
45

answered Oct 07 '15 at 14:37

Peter Mankge

79
1
2

score 0 · Answer 5 · answered Mar 30 '23 at 21:51

In addition to other answers, keep in mind that changing the page also fires the OnRowCommand event, with CommandName "Page". Be careful not to put conflicting code in that method, that could be altering the result of your OnPageIndexChanging actions.

PageIndexChanging in GridView in ASP.NET

5 Answers5

Linked