AspNetPager的使用,分页显示
1、工具箱-选择项-浏览,找到AspNetPager.dll,选择确认,则工具箱就增加了AspNetPager控件;
2、把AspNetPager控件拉入页面,在页面中会自动注册:
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
3、注意控件名称,这里就用其默认名:AspNetPager1;
4、在页面中加入一个GridView,命名用其默认GridView1;
5、把GridView1和AspNetPager1调整到合适的位置;
6、在页面上,点中AspNetPager1的区域,会在属性栏那里可以选择页码的式样。
7、在页码的AspNetPager1的区域,加入OnPageChanged="AspNetPager1_PageChanged",这个东西开始写错了,花了好长时间,错成了:
OnPageChanging="AspNetPager1_PageChanged" 和 OnPageIndexChanged="AspNetPager1_PageChanged"
8、代码:
页码代码:
<asp:GridView ID="GridView1" runat="server">
<HeaderStyle Wrap="False" />
<RowStyle Wrap="False" />
</asp:GridView>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText="首页" LastPageText="尾页"
NextPageText="下一页" PrevPageText="上一页"
OnPageChanged="AspNetPager1_PageChanged" >
</webdiyer:AspNetPager>
后台代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class Reportxyq_showxAspNetPager : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//调用绑定分页和GridView
BindGridView();
}
}
绑定分页和GridView方法
private void BindGridView()
{
//获取数据表格
String sqlconn = "Server=.; DataBase=zongdiao; Integrated Security=SSPI ";
string sql = "select top 500 * from table";
SqlConnection myConnection = new SqlConnection(sqlconn);// 创建数据库连接实例
myConnection.Open(); //打开数据库
SqlDataAdapter myda = new SqlDataAdapter(sql, sqlconn);//创建一个sql数据适配器
DataSet myDs = new DataSet(); //创建数据集实例
myda.Fill(myDs);
//初始化分页数据源实例
PagedDataSource pds = new PagedDataSource();
//设置总行数
AspNetPager1.RecordCount = myDs.Tables[0].Rows.Count;
//设置分页的数据源
pds.DataSource = myDs.Tables[0].DefaultView;
//设置当前页
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
//设置每页显示页数
pds.PageSize = AspNetPager1.PageSize;
//启用分页
pds.AllowPaging = true;
//设置GridView的数据源为分页数据源
GridView1.DataSource = pds;
//绑定GridView
GridView1.DataBind();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
//调用绑定分页和GridView
BindGridView();
}
}