1、本版分页只针对Sql Server数据库,采用top n分页方式,节约资源。
2、支持GridView、DataGrid、DataList等数据控件。
3、本分页已应用于数据量百万级的项目中。
4.本人用的是GridView,ID为GV1;
(1.)再控制面板下 工具箱-选择项 找到jwork.dll并添加;
(2.)添加一个jpage和gridview空间;
源代码:
<asp:GridView ID="GV1" runat="server" AutoGenerateColumns="False"
Width="436px" >
<Columns>
<asp:BoundField DataField="BookID" HeaderText="书本ID" />
<asp:BoundField DataField="booktitle" HeaderText="书名字" />
<asp:BoundField DataField="bookprice" HeaderText="价格" />
<asp:BoundField DataField="bookpublishing" HeaderText="出版社" />
</Columns>
</asp:GridView>
<cc1:Jpage ID="Jpage1" runat="server" JControl="Dlist" Width="434px"
Font-Names="verdana" Font-Size="9pt" Jpagesize="5" />
后台代码:
protected void Page_Load(object sender, EventArgs e)
{
string selesql = "select * from DB_book";
if (!IsPostBack)
{
//Jpage1.Jconnstr = "Data Source=ZTB-SEVEN;Initial Catalog=book;Integrated Security=True";
Jpage1.Jselect = selesql; //查询语句
//Jpage1.Jsortfield = "bookprice desc";
Jpage1.Jsortfield = "BookID desc"; //降序select
Jpage1.JControl = "GV1"; //绑定空间的ID,默认是Dlist
Jpage1.DataBind(); //数据绑定
}
}
web.config代码:
<connectionStrings>
<add name="data" connectionString="Data Source=ZTB-SEVEN;Initial Catalog=book;Integrated Security=True"/>
</connectionStrings>
运行的效果:
相关dll不知道怎么上传,csdn有下载:百度输入 csdn jpage 即可;