<!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>
<title></title>
<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
</head>
<body>
<ul id="ulcomment"></ul>
<table>
<tr id="trPage"></tr>
</table>
<script type="text/javascript">
$.post("PagedService.ashx", { "action": "getpagecount" }, function (data, status) {
for (var i = 1; i <= data; i++) {
var td = $("<td> <a href=''>" + i + "</a></td>");
$("#trPage").append(td);
}
$("#trPage td").click(function (e) {
e.preventDefault(); //不要超链接起作用
$.post("PagedService.ashx", { "action": "getpagedata", "pagenum": $(this).text() },
function (data, status) {
var comments = $.parseJSON(data);
$("#ulcomment").empty();
for (var i = 0; i < comments.length; i++) {
var comment = comments[i];
var li = $("<li>提交时间:" + comment.PostDate + "评论" + comment.Msg + "</li>");
$("#ulcomment").append(li);
}
});
});
});
$.post("PagedService.ashx", { "action": "getpagedata", "pagenum": "1" },//初始化的默认第一页
function (data, status) {
var comments = $.parseJSON(data);
$("#ulcomment").empty();
for (var i = 0; i < comments.length; i++) {
var comment = comments[i];
var li = $("<li>提交时间:" + comment.PostDate + "评论" + comment.Msg + "</li>");
$("#ulcomment").append(li);
}
})
</script>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Ajax翻页.DAL.DataSetCommentTableAdapters;
using System.Web.Script.Serialization;
namespace Ajax翻页
{
/// <summary>
/// PagedService 的摘要说明
/// </summary>
public class PagedService : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string action = context.Request["action"];
if (action=="getpagecount")
{
var adapter = new T_CommentsTableAdapter();
int count = adapter.SelectCount().Value;
int pagecount = count / 10;
if (count%10!=0)
{
pagecount++;
}
context.Response.Write(pagecount);
}
else if (action == "getpagedata")
{
string getpagedata = context.Request["pagenum"];//获得传过来的页数
int IPageNUm = Convert.ToInt32(getpagedata);
var adapter = new T_CommentsTableAdapter();//获得adapter
var data = adapter.GetPagedData((IPageNUm - 1) * 10 + 1, (IPageNUm) * 10);//根据页数获得数据
List<Comment> list = new List<Comment>();//创建list
foreach (var item in data)//在list中循环输入Comment属性PostDate,Msg
{
list.Add(new Comment() { PostDate = item.PostDate.ToShortDateString(), Msg=item.Msg });
}
JavaScriptSerializer jss = new JavaScriptSerializer();//序列化list为json
context.Response.Write(jss.Serialize(list));
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
public class Comment
{
public string PostDate { get; set; }
public string Msg { get; set; }
}
}
select *from(
SELECT Id, PostDate, Msg,Row_Number()over(order by PostDate)rownum FROM dbo.T_Comments
)t
where t.rownum>=@startRowIndex and t.rownum<@endRowIndex