• λ我爱Aspx >> C#.Net >> 在ASP中,用JScript脚本实现分页的另类办法_ASP技巧
  • 在ASP中,用JScript脚本实现分页的另类办法_ASP技巧

  • :aspxer  Դ:internet  :2007-4-28 23:45:59  ؼ:asp
  • <javascript'>%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>

    <!--#include file="connect.asp"-->

    <!--#include file="news.asp"-->

    <%

    var DataSet,sql,DataList;

    var i=0;

    var j=0;

    DataList=new News();

    DataSet=Server.CreateObject("Adodb.recordset");

    sql="select * from News where ngroup='集团新闻' order by id desc";

    DataSet.Open(sql,DataConn,1,1);

    //是否有数据

    if ((DataSet.eof)&&(DataSet.bof))

    {

    Response.Write("<BR>" );

    Response.Write("=== 暂无 ===");

    Response.Write("<BR><BR>");

    Response.End();

    }

    //记录总数

    NumRecords=DataSet.RecordCount;

    //设定每页最大记录数

    PageSize=3;

    //总页数

    NumPages=Math.ceil(NumRecords/PageSize);

    //当前页

    i=Request.QueryString("CurrentPageID").Count;

    if (i==0)

    {

    CurrentPageID=1;

    }

    else

    {

    CurrentPageID=parseInt(Request.QueryString("CurrentPageID"));

    }

    //初始化

    PreviousPageID=CurrentPageID-1;

    NextPageID=CurrentPageID+1;

    HomePage=1;

    EndPage=NumPages;

    //内容列表

    DataSet.MoveFirst;

    DataSet.Move((CurrentPageID-1)*PageSize,1);

    while (!DataSet.eof && j<PageSize)

    {

    Response.Write("<a href=show.asp?id="+DataSet("id")+" target=\"_blank\">"+DataSet("subject")+"</a><br>");

    j=j+1;

    DataSet.MoveNext;

    Ҷƪл˵?
  • һƪ用PHP实现ODBC数据分页显示一例_PHP技巧
    һƪ原创的自定义分页UserControl 分享及探讨_ASP.NET技巧