小小ajax分頁

最後更新：2018-12-07 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

default.aspx.cs:
public partial class _Default : System.Web.UI.Page
{
string connectString = "";
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(_Default));
}
[AjaxPro.AjaxMethod]
public DataTable GetDataTable()
{
SqlDataAdapter ad = new SqlDataAdapter("select * from tableName",

connectString);
DataSet ds = new DataSet();
ad.Fill(ds);
int num = ds.Tables[0].Rows.Count;
return ds.Tables[0];
}
}

default.aspx:
<%@ Page Language="C#" AutoEventWireup="true"

CodeFile="Default.aspx.cs" Inherits="_Default" %>
<html>
<head runat="server">
<title></title>
<script language="javascript">
var dtObj=new Object();
function stringToInteger(inputString)
{
if(inputString == null || inputString == "")
{
return 0;
}
else
{
try
{
return parseInt(inputString);
}
catch(e)
{
return 0;
}
}
}
function numberToString(inputNumber)
{
return inputNumber.toString();
}
function getUrlParam(param)
{
var url=window.location.search.substring(1);
var paramArray=url.split("&");

for(var i=0;i<paramArray.length;i++)
{
var pramArraySub=paramArray[i].split("=");
if(pramArraySub[0]==param && pramArraySub[1] != "undefined")
return pramArraySub[1];
}
return "";
}
//
var pageSize=5;
//var pageNo=stringToInteger(getUrlParam("pageno"));
</script>
</head>
<body>
<form id="form1" runat="server">
<div align=center><span id="sp_ShowContent"></span></div>
</form>
</body>
</html>
<script language=javascript>
var pageNo =0;
var dtObj = new Object();
dtObj=_Default.GetDataTable().value;
var totalPage=0;
var totalRecord = dtObj.Rows.length;
if((dtObj.Rows.length%pageSize)==0)
totalPage = dtObj.Rows.length/pageSize;
else
totalPage = Math.ceil(dtObj.Rows.length/pageSize);
function showContent(op)
{
if(op == "first")
{
pageNo = 0;
}
else if(op == "previous")
{
if(pageNo>0)
pageNo-=1;
else
pageNo=0;
}
else if(op == "next")
{
if(pageNo<totalPage-1)
pageNo+=1;
else
pageNo = totalPage-1;
}
else if(op == "last")
{
pageNo=totalPage-1;
}
else
{
pageNo=0;
}
var content = "";
var startRecord = pageNo*pageSize;
var endRecord = 0;
if(pageNo>=totalPage-1)
endRecord = totalRecord;
else
endRecord = (pageNo+1)*pageSize;
content = '<table width="75%" border="1" cellspacing="0"

bordercolordark="#FFFFFF" bordercolorlight="#339900">';
content += '<tr>';
content += '<td width="45%">編號</td>';
content += '<td width="55%">使用者名稱</td>';
content += '</tr>';
for(var i=startRecord;i<endRecord;i++)
{
content += '<tr>';
content += '<td width="45%">'+dtObj.Rows[i]["ID"]

+'</td>';//ID,UserName is Column Name
content += '<td width="55%">'+dtObj.Rows[i]["UserName"]+'</td>';
content += '</tr>';
}
content += '<tr align="center">';
content += '<td colspan="2"><a href="#" _fcksavedurl=""#""

_fcksavedurl=""#"" _fcksavedurl=""#"" _fcksavedurl=""#""

_fcksavedurl=""#"" onClick="showContent("'first"')">第一頁

</a> <a href="#" onClick="showContent("'previous"')">上一頁

</a> <a href="#" onClick="showContent("'next"')">下一頁

</a> <a href="#" onClick="showContent("'last"')">最後頁

</a></td>';
content += '</tr>';
content += '</table>';
window.document.getElementById("sp_ShowContent").innerHTML=content;
}
showContent("first");
</script>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More