无刷新分页
1,前台:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>
<!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>
<asp:TextBox ID="show" runat="server" TextMode="MultiLine" style=" height:600px; width:600px;"></asp:TextBox>
</div>
</form>
</body>
</html>
2,后台:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text;
public partial class test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
show.Text = server_Side_Processing(20,1);
}
}
/// <summary>
///服务器端处理程序到数据库查询数据并生成xml档返回
/// </summary>
public string server_Side_Processing(int pageSize, int currentPage)
{
StringBuilder resultXML = new StringBuilder();
string str_xml;
DataSet ds;
DataAccess da;
int i;
resultXML.Append("<?xml version='1.0' encoding='gb2312'?>");
resultXML.Append("<ajax-response>\n");
resultXML.Append("<root>\n");
try
{
if (currentPage == 1)
{
str_xml = "select top " + pageSize + " * from tbMicroblog order by MicroblogID desc";
}
else
{
str_xml = "select top " + pageSize + " * from tbMicroblog MicroblogID not in (select top " + pageSize * (currentPage - 1) + " * from tbMicroblog order by MicroblogID desc) where order by MicroblogID desc";
}
da = new DataAccess();
ds = da.GetDataSetResult(str_xml, "xml_table");
if (ds != null)
{
for (i = 0; i <pageSize; i++)
{
if (ds.Tables[0].Rows[i]==null)
{
break;
}
resultXML.Append("<data>\n");
resultXML.Append("\t<MicroblogID>" + ds.Tables[0].Rows[i]["MicroblogID"].ToString() + "</MicroblogID>\n");
if (ds.Tables[0].Rows[i]["UserID"].ToString().Trim() != "")
{
resultXML.Append("\t<UserID>" + HttpUtility.UrlEncodeUnicode(ds.Tables[0].Rows[i]["UserID"].ToString().Trim()) + "</UserID>\n");
}
else
{
resultXML.Append("\t<UserID>#</UserID>\n");
}
if (ds.Tables[0].Rows[i]["Content"].ToString().Trim() != "")
{
resultXML.Append("\t<Content>" + HttpUtility.UrlEncodeUnicode(ds.Tables[0].Rows[i]["Content"].ToString().Trim()) + "</Content>\n");
}
else
{
resultXML.Append("\t<Content>#</Content>\n");
}
if (ds.Tables[0].Rows[i]["Pubdate"].ToString().Trim() != "")
{
resultXML.Append("\t<Pubdate>" + HttpUtility.UrlEncodeUnicode(ds.Tables[0].Rows[i]["Pubdate"].ToString().Trim()) + "</Pubdate>\n");
}
else
{
resultXML.Append("\t<Pubdate>#</Pubdate>\n");
}
resultXML.Append("</data>\n");
}
}
else
{
//resultXML.Append("<?xml version='1.0' encoding='gb2312'?>");
//resultXML.Append("<ajax-response>\n");
//resultXML.Append("<root>\n");
resultXML.Append("<data>\n");
resultXML.Append("\t<nodata>" + "No Data !" + "</nodata>\n");
resultXML.Append("</data>\n");
}
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
resultXML.Append("</root>\n");
resultXML.Append("</ajax-response>");
return resultXML.ToString();
}
}
思路分析:
if (ds.Tables[0].Rows[i]==null)
{
break;
}
这里是关键.
以pageSize个数据单元作为一页(数据段),当数据段的数据单元数目<pageSize时就是最后一页了。