如何在后台代码实现gridview分页功能
我要在后台代码实现分页显示,不是在前台的数据源配置分页,遇到了问题,请高手指点一下!
这是后台代码:
public void GridViewBind()
{
SqlConnection con = new SqlConnection("Server=localhost;Uid=sa;pwd=sa;DataBase=setter");
con.Open();
SqlDataAdapter ada = new SqlDataAdapter("select c_id,t_name as 类型,c_no as 内容,c_money as 金额,c_time as 操作时间 from orders order by c_time desc", con);
DataSet ds = new DataSet();
ada.Fill(ds);
GridView1.DataSource = ds;
//GridView1_PageIndexChanging();
GridView1.DataBind();
con.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridViewBind();
}
前台代码:
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None"
Height="93px" Style="left: 17px; vertical-align: middle; position: absolute;
top: 271px; text-align: center" Width="809px" AllowPaging="True" PageSize="5">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView><asp:Button ID="Button2" runat="server" Style="left: 838px; position: absolute; top: 217px"
Text="下单" Width="83px" OnClick="Button2_Click" />
经过测试发现,我点页码2的时候,GridView1_PageIndexChanging的内容根本没运行,提示出错GridView“GridView1”激发了未处理的事件“PageIndexChanging”。请高手指点一下!