文件名称:SqlPageClass
- 所属分类:
- WEB源码
- 资源属性:
- [Windows] [Visual C] [Basic/ASP] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 2kb
- 下载次数:
- 0次
- 提 供 者:
- 蓝*
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
利用SQL语句进行分页,效果极佳。使用示例:
set mypage = new sqlpage
mypage.sql = 执行查询的Sql语句
mypage.orderby = "id desc,date desc"
mypage.pagesize = 20 每页20条
rs.open mypage.newsql,conn,1,1
do while not rs.eof
....
....
Loop
rs.close
mypage.showpage-use SQL for pagination and excellent results. Use examples : set mypage = new sqlpage mypage.sql = implementation Sql query language sentence mypage.orderby = "id desc. date desc "mypage.pagesize page = 20 m 20 rs.open ypage.newsql, conn, 1, while not a do rs.eof .... .... Loop rs.close Azamat age.showpage
set mypage = new sqlpage
mypage.sql = 执行查询的Sql语句
mypage.orderby = "id desc,date desc"
mypage.pagesize = 20 每页20条
rs.open mypage.newsql,conn,1,1
do while not rs.eof
....
....
Loop
rs.close
mypage.showpage-use SQL for pagination and excellent results. Use examples : set mypage = new sqlpage mypage.sql = implementation Sql query language sentence mypage.orderby = "id desc. date desc "mypage.pagesize page = 20 m 20 rs.open ypage.newsql, conn, 1, while not a do rs.eof .... .... Loop rs.close Azamat age.showpage
相关搜索: sqlpa
(系统自动生成,下载前可以参看下载内容)
下载文件列表
SqlPageClass.asp