新建一个 网站
将控件添加到工具箱中，在工具箱中点击鼠标右键，点选 选择项 菜单，然后在弹出的对话框中点击浏览按钮，找到编译后的 sqlpaging.dll 最后点击确定按钮即可。
新建一个 default2.aspx 页面 然后在页面中添加控件 gridview datalist 各一个 添加两个 sqlpaging 控件 添加一个按钮控件如下图
然后设置 sqlpaging 控件的两个重要的属性如下图
下面是控件的测试页面 default2.aspx 文件的html源码
<%@ page language="vb" autoeventwireup="false" codefile="default2.aspx.vb" inherits="default2" %>
<%@ register assembly="sqlpaging" namespace="drmsystem.datalayer" tagprefix="drmsp" %><!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>无标题页</title></head><body> <form id="form1" runat="server"> <div> </div> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td style="height: 125px"> gridview sample<br /> <br /> <asp:gridview id="gridview1" runat="server" width="100%"> </asp:gridview> <br /> <drmsp:sqlpaging id="sqlpaging1" runat="server" storedprocedurename="sys_quicksortpaging" controltopaginate="gridview1" /> </td> </tr> <tr> <td style="height: 29px"> </td> </tr> <tr> <td style="height: 361px"> datalist sample<br /> <br /> <asp:datalist id="datalist1" runat="server" backcolor="white" bordercolor="#e7e7ff" borderstyle="none" borderwidth="1px" cellpadding="3" gridlines="horizontal" horizontalalign="justify" repeatlayout="flow" width="100%"> <footerstyle backcolor="#b5c7de" forecolor="#4a3c8c" /> <selecteditemstyle backcolor="#738a9c" font-bold="true" forecolor="#f7f7f7" /> <alternatingitemstyle backcolor="#f7f7f7" /> <itemstyle backcolor="#e7e7ff" forecolor="#4a3c8c" /> <headerstyle backcolor="#4a3c8c" font-bold="true" forecolor="#f7f7f7" /> <itemtemplate> <%#databinder.eval(container.dataitem, "employeesid")%> <%#databinder.eval(container.dataitem, "lastname")%> <%#databinder.eval(container.dataitem, "firstname")%> <%#databinder.eval(container.dataitem, "birthdate")%> <%#databinder.eval(container.dataitem, "address")%> <%#databinder.eval(container.dataitem, "city")%> <%#databinder.eval(container.dataitem, "homephone")%> <%#databinder.eval(container.dataitem, "extension")%> </itemtemplate> </asp:datalist><br /> <drmsp:sqlpaging id="sqlpaging2" runat="server" controltopaginate="datalist1" storedprocedurename="sys_quicksortpaging" /> <asp:button id="button1" runat="server" text="生成1百万条测试数据" /> 更具硬件大约需要 5-20 分钟</td> </tr> </table> </form></body></html>测试页 default2.aspx.vb 源码
imports system.dataimports system.data.sqlclientpartial class default2
inherits system.web.ui.page 请更改sql 数据库连接字符串的 database 部分 private const strsqlconn as string = "server=(local);trusted_connection=true;database=pubs;uid=sa"
protected sub page_load(byval sender as object, byval e as system.eventargs) handles me.load
if not ispostback then sqlpaging1.sqlconnection = strsqlconn sqlpaging1.pageinfotext_01 = "每页" sqlpaging1.pageinfotext_02 = "条记录" sqlpaging1.pageinfotext_03 = "转到" sqlpaging1.pageinfotext_04 = "页" sqlpaging1.tablename = "employees" sqlpaging1.primarykeyfield = "employeesid" sqlpaging1.field = "*" sqlpaging1.databind() sqlpaging2.sqlconnection = strsqlconn sqlpaging2.pageinfotext_01 = "每页" sqlpaging2.pageinfotext_02 = "条记录" sqlpaging2.pageinfotext_03 = "转到" sqlpaging2.pageinfotext_04 = "页" sqlpaging2.tablename = "employees" sqlpaging2.primarykeyfield = "employeesid" sqlpaging2.field = "*" sqlpaging2.where = "employeesid<2000 and employeesid>1000" sqlpaging2.databind() end if
end sub protected sub button1_click(byval sender as object, byval e as system.eventargs) handles button1.click dim conn as new sqlconnection(strsqlconn) conn.open() using conn dim command as new sqlcommand command.connection = conn command.commandtext = "inserttabledata" command.commandtimeout = "600" command.commandtype = commandtype.storedprocedure command.executenonquery() end using end sub
end class文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
