Paging Next in DataGrid in Asp.net C# Not Working

Question

I am trying to do paging of data. Basically I am taking a data and want to show it on multi pages. But it is not working. I am using Asp.net and C# for coding. I am using mysql as database.

Code is as follows : ASP code

<asp:DataGrid runat="server" ID="RestData"
     AllowPaging="True" PageSize="2" 
     OnPageIndexChanged="RestData_PageIndexChanged" AllowCustomPaging="True" 
     PagerStyle-Wrap="False">
     <PagerStyle />
</asp:DataGrid>

C# code:

protected void Page_Load(object sender, EventArgs e)
 {
    BindData();
 }
public void BindData()
    {
     RestData.DataSource = call.GetReader(Convert.ToInt32(AreaData.SelectedValue));  
       //GetReader is function which returns the data reader of mysql 
     RestData.DataBind();
    }
protected void RestData_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
       RestData.CurrentPageIndex = e.NewPageIndex;
        BindData();
   }

Output : It is displaying two rows(as i have given pagesize 2). But I am not able to see next page. The query should returns more than 2 rows(it does happen when i use repeater but i am not able to do paging in it.

Please provide some solution ( I was not able to solve my question with any other solution in this forum so i have created new one)

THANKS in ADVANCE.

Did you try using `PageIndexChanging` event which is where you need to set the index and bind the grid. — V4Vendetta, May 23 '12 at 12:26
But in DataGrid, I am unable to find event like PageIndexChanging. — Rahul M, May 23 '12 at 12:31
No, what you have done is correct only. It has to be `PageIndexChanged` and not `PageIndexChanging`. — Rahul, May 23 '12 at 12:38
Are you really doing any custom paging ... means custom data show in your page? If not, then remove your `AllowCustomPaging="True"` from design. — Rahul, May 23 '12 at 12:40
I had the same problem, found a solution here, if you adopt this code, you can make it working http://stackoverflow.com/a/15685860/3966458 — Saahithyan Vigneswaran, Aug 18 '16 at 04:54

V4Vendetta · Answer 1 · 2012-05-23T12:46:57.753

1

Try adding

If(! IsPostBack)
{
   BindData();
}

There is an example similar to what you have over here DataGrid custom paging

The below part is more suited for Gridview rather than for DataGrid

~~You should be subscribing to PageIndexChanging rather than PageIndexChanged event.~~

PageIndexChanging happens when you click one of the paged buttons and before the grid handles the paging operation

while PageIndexChanged is post the operation.

Also i would put in a check in the page load for the Bind data

edited May 23 '12 at 12:46

answered May 23 '12 at 12:31

V4Vendetta

37,194
9
78
82

Are you sure there is event `PageIndexChanging` exist for DataGrid? Refer DataGrid Class here and let me know if you find it. http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.datagrid.aspx – Rahul May 23 '12 at 12:45
@Rahul Can you read again i have mentioned the same and showed the region with a strike through. – V4Vendetta May 23 '12 at 12:48
yeah Vendetta there is PageIndexChanged event for datagrid while there is PageIndexchanging as well as PageIndexChanged event for GridView – Rahul M May 23 '12 at 12:53

score 1 · Answer 2 · edited May 23 '17 at 12:00

The DataGrid must know what to do when you try to change pages.

In your grid (example comes from my project which is in VB, sorry):

 <asp:DataGrid ID="MainGrid"
    OnEditCommand="MainGrid_Edit"
    OnCancelCommand="MainGrid_Cancel"
    OnUpdateCommand="MainGrid_Update"
    runat="server"
    AutoGenerateColumns="False"
    AllowSorting="True"
    CssClass="DistPortalDataGrid"
    AllowPaging="True"
    CellPadding="3"
    PageSize="25" 
    onpageindexchanging="MainGrid_PageIndexChanged"
    ....

Notice the last line...

Now go to the code view and create the following sub:

Protected Sub MainGrid_PageIndexChanged(source As Object, e As DataGridPageChangedEventArgs) Handles MainGrid.PageIndexChanged
    MainGrid.CurrentPageIndex = e.NewPageIndex
    BindMainGrid() 'rebinds the grid
End Sub

As indicated to Rajuu Parmar, there is no .PageIndex property for the DataGrid. This is correct. The equivalent property for DataGrid is the .CurrentPageIndex. Why Microsoft made them different, I have no idea. While you solved the problem (years ago from the date), I'm hoping that you or someone else finds this useful.

score 0 · Answer 3 · answered May 23 '12 at 12:32

0

You also need to tell the grid how many items in total there are, by doing something like:

public void BindData() {
    RestData.VirtualItemCount = CountTotalItemsInDb();
    // ... the rest ....
}

answered May 23 '12 at 12:32

Martin Ernst

5,629
2
17
14

score 0 · Answer 4 · edited Sep 22 '15 at 20:17

0

The reason why paging on your datagrid not working was because you had created 'protected' method and it wasn't able to access it. If the code is change to below, it would have worked. Hope it helps others in need.

public void RestData_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
       RestData.CurrentPageIndex = e.NewPageIndex;
        BindData();
   }

edited Sep 22 '15 at 20:17

Bacteria

8,406
10
50
67

answered Sep 22 '15 at 20:13

user3784381

1
1

score -1 · Answer 5 · edited Jul 14 '12 at 07:20

-1

try this.

protected void G_BgtPersonnel_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    //Next page in the GridView
    G_BgtPersonnel.PageIndex = e.NewPageIndex;
    BindgrdPersonnal();
}

edited Jul 14 '12 at 07:20

akjoshi

15,374
13
103
121

answered May 23 '12 at 12:31

Rajuu Parmar

59
10

There is no `PageIndexChanging` in DataGrid. Refer MSDN. – Rahul May 23 '12 at 12:47

score -1 · Answer 6 · answered May 24 '12 at 06:06

Thanks for your help. I got the solution. Just posting the solution if some one need in future. Finally I got the solution by GridView. It does do paging.

ASP Code

<asp:GridView ID="RestGridData" runat="server"
     AllowPaging="True"  AutoGenerateColumns="False"
     PageSize="2" onpageindexchanging="RestGridData_PageIndexChanging">
  </asp:GridView>

CS Code

protected void Page_Load(object sender, EventArgs e)
    {
       GridBindData(); // on page load 
    }
public void GridBindData()
    {
        MySqlConnection Conn; // I am using MySql 
        myConn = new MySqlConnection("server=localhost;user=root;database=DBName;");
        conn.Open();
        MySqlCommand cmd = new MySqlCommand("Select Name, address, mobileNo, emailID from  user", conn);
         MySqlDataReader reader = cmd.ExecuteReader();
        // As DataReader can move only in forward it is not useful to use it GridView.
       // So convert it to DataTable(or?). It can move in both direction

        DataTable dTable = new DataTable();
        dTable.Load(reader); // ASP function to convert reader to DataTable

        RestGridData.DataSource = dTable; 
        RestGridData.DataBind();

    }
protected void RestGridData_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        RestGridData.PageIndex = e.NewPageIndex;
        GridBindData();
    }

Paging Next in DataGrid in Asp.net C# Not Working

6 Answers6