GridView自带的分页功能实现:
要实现GrdView分页的功能
操作如下: 1、更改GrdView控件的AllowPaging属性为true。 2、更改GrdView控件的PageSize属性为 任意数值(默认为10) 3、更改GrdView控件的PageSetting->Mode为Numeric等(默认为Numeric)该属性为分页样式。 GridView属性设置好了,从页面上也能看到分页样式。现在开始实现分页的功能:
1、在<<asp:GridView ID=......>后添加,OnPageIndexChanging="GridView1_PageIndexChanging"
2、在对应的aspx.cs中添加: protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = e.NewPageIndex; InitPage(); //重新绑定GridView数据的函数 }参考代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gridview_zidaifenye.aspx.cs" Inherits="gridview_zidaifenye" %>
后台代码:
using System;using System.Collections.Generic;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class gridview_zidaifenye : System.Web.UI.Page{ DBAccess db = new DBAccess(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // gvProduct.DataSource = getData(); // gvProduct.DataBind(); BindGrid(); } } public void BindGrid() { SqlCommand comm = db.CreateCommand("select * from product p,Uuser u where p.userid=u.id"); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = comm; DataSet ds = new DataSet(); sda.Fill(ds,"Datatable"); DataView dv = ds.Tables[0].DefaultView; GridView1.DataSource = dv; GridView1.DataBind(); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { GridView1.PageSize = int.Parse(DropDownList1.SelectedValue); GridView1.PageIndex = 0; BindGrid(); //GridView1.DataBind(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { lblMsg.Text = "当前页为第" + (GridView1.PageIndex + 1).ToString() + "页,共" + (GridView1.PageCount).ToString() + "页"; } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridView1.PageIndex = ((GridViewPageEventArgs)e).NewPageIndex; BindGrid(); //重新绑定GridView数据的函数 }}
总结下,方便以后用到。