我使用的是sql分页 string sql = "select * from (select *,row_number() over (order by id) as r_num from Topic) as rum_table where r_num between (@page-1) * @pagesize+1 and @pagesize * @page"由一般处理程序输出数据 然后再页面写js给一般处理程序传值 分页 var currentPage = 1; var pagesize = 20; var pageCount; //下一页 function loadNext() {
然后再页面写js给一般处理程序传值 分页
var currentPage = 1;
var pagesize = 20;
var pageCount;
//下一页
function loadNext() {
currentPage = currentPage + 1;
loadData(currentPage, pagesize);
//alert(currentPage);
}
//上一页
function loadPrev() {
currentPage = currentPage - 1;
loadData(currentPage, pagesize);
//alert(currentPage);
}
//访问指定页
function GoToPage() {
var toPage = $("#ToPage").val();
if (toPage < 1 || toPage > pageCount) {
$.messager.alert("系统提示", "不存在的页码!!", "info");
$("#ToPage").val("");
return false;
}
loadData(toPage, pagesize);
currentPage = parseInt(toPage, 10);
}
//加载数据
function loadData(currentPage, pagesize) {
$.ajax({
url: "loadTable.ashx",
data: { "getType": "1", "currentPage": currentPage, "pagesize": pagesize, "t": Math.random() },
type: "post",
success: function (data) {
$("div#topicTable").html(data);
$("#addButton").show();
var count = $("#count").val();
if (count % pagesize == 0) {
pageCount = count / pagesize;
} else {
pageCount = parseInt((count / pagesize), 10) + 1;
}
$("#currentPage").html(currentPage);
$("#countPage").html(pageCount);
//alert(pageCount);
if (currentPage == 1) {
//上一页按钮
$("#prev").hide();
}
//下一页按钮
if (currentPage == pageCount) {
$("#next").hide();
}
}
});
}
this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "dd",
"<script>location.href='重新加载页面';</script>");
防止刷新重复提交 第一次点击后 禁用就行了