Gridview分页问题? [英] Gridview paging problem?

问题描述

我使用了gridview分页并从数据库填充

每页有10个数据

对于ex 1 2 3每页10个数据没有问题

1和2有10个数据3第三页3个数据
我点击了第三页的第三页和第二页的第二页，所以在
之前
这个错误给了我

I used gridview paging and fill from database

each page has 10 data

for ex 1 2 3 each page 10 data there is no problem

1 and 2 has 10 data 3 third page 3 data
I click 3 third page and 2 second page so before

this error gives me

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

因此，每页有10个数据没有问题，但是如果最后一页少于10个数据，请单击最后一页，然后单击前一页，此错误会提示我

我的代码如下:

so each page has 10 data there is no problem but if last page less then 10 data click last page and click before page this error gives me

my code this:

MySqlConnection conn = new MySqlConnection(connect.connStr);
                    conn.Open();
                    string sql = "select * from xxx where yyy='" + zz+ "'";
                    MySqlCommand cmd = new MySqlCommand(sql, conn);
                    MySqlDataAdapter Adapter = new MySqlDataAdapter(cmd);
                    DataTable daset = new DataTable();
                    Adapter.Fill(daset);
                    GridView1.DataSource = daset;
                    GridView1.DataBind();

                    Cache["xxx"]= daset;

                    conn.Close(); 

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
       {

           GridView1.PageIndex = e.NewPageIndex;
           gridbinding();
       }

       private void gridbinding()
       {
           GridView1.DataSource = (DataTable) Cache["xxx"];
           GridView1.DataBind();

       }

推荐答案

为GridView公开的两个分页事件之间存在差异:
MSDN:GridView.PageIndexChanged事件 [ ^ ]和 MSDN:GridView.PageIndexChanging事件 [ ^ ]

您可以阅读其中的区别，需要使用PageIndexChanged事件，并且一切正常.上面共享的链接中也提供了两个事件的示例代码.

There is difference between two events of pagination that is exposed for GridView:
MSDN: GridView.PageIndexChanged Event[^] and MSDN: GridView.PageIndexChanging Event[^]

You can read the difference, you need to use PageIndexChanged event and everything should work fine. Sample codes for both the events are also provided in the links shared above.

这篇关于Gridview分页问题?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！