js代码: var pagesize=5,pageIndex=1;$(document).ready(loaddata); function loaddata() { $('#display').html("<b><i>车展很好看</i></b>"); $('#display').attr("href","http://www.sohu.com"); $('#display').attr("title","这是一个鼠标移动的提示");
//pagelist(); } debugger function pagelist(Index) { //debugger; $('#content').empty(); AjaxStu.GetAllUser(Index,pagesize,user_callback); }function user_callback(res) { var _dtdata=res.value.Tables[0]; var _dtcount=res.value.Tables[1];
<tbody id="content"> </tbody> </table><input type=button onclick="pagelist(2);" value="第2页" /> <input type=button onclick="pagelist(3);" value="第3页" /> <input type=button onclick="pagelist(4);" value="第4页" /><div id="pagelist"></div> <script type="text/javascript" src="scripts/jquery-1.2.6.js"></script> <script type="text/javascript" src="scripts/stu.js"></script> </form> </body> </html>---------------------------- .cs -------------------------------- using System; using System.Data; using System.Configuration; using System.Web; using AjaxPro; using System.Data.SqlClient; using System.Text;[AjaxNamespace("AjaxStu")] public partial class _DefaultCS : System.Web.UI.Page { /// <summary> /// This method will return the time on the web server. /// </summary> /// <returns>The time on the web server.</returns> [AjaxMethod] public string GetServerTime() { return DateTime.Now.ToString(); } /// <summary> /// This method will simulate a long running method. Please have /// a look on the client-side JavaScript code for AjaxPro.onLoading. /// </summary> /// <returns>Returns always true.</returns> [AjaxMethod] public bool LongOperation() { System.Threading.Thread.Sleep(3 * 1000); return true; } [AjaxMethod] public string DeleteUser(int id) { if (new BaseDB().ExecuteNonQuery("delete from users where id=" + id + "", null)) return "1"; else return "0";
} [AjaxMethod] public DataSet GetAllUser(int pageindex, int pagesize) { DataSet ds = new DataSet(); DataTable dt; int count=0;
DataRow drNew; SqlParameter[] par = new SqlParameter[3]; par[0] = new SqlParameter("@pageindex", pageindex); par[1] = new SqlParameter("@PageSize", pagesize); par[2] = new SqlParameter("@Count", count); par[2].Direction = ParameterDirection.Output; dt = new BaseDB().GetTable("usp_GetAllUserByPage", par); count = Convert.ToInt32(par[2].Value); ds.Tables.Add(dt.Copy()); //得到记录总数 dt = new DataTable(); dt.Columns.Add(new DataColumn("pagelist", typeof(string))); drNew = dt.NewRow(); drNew["pagelist"] = AjaxPageList(count, pageindex,pagesize, 10); dt.Rows.Add(drNew); ds.Tables.Add(dt.Copy()); return ds; } /// <summary> /// 功能名称:PageList /// 功能描述:用于分页,可公用 /// </summary> /// <param name="RecordCount">记录总条数</param> /// <param name="RcPerPage">每页数</param> /// <param name="page">显示第几页</param> /// <param name="pageLinkNum">导航栏上有几个页面</param> public string AjaxPageList(int RecordCount, int page, int RcPerPage, int pageLinkNum) { if (RecordCount <= RcPerPage) { return ""; } StringBuilder pageList = new StringBuilder(""); int p, i; int pagecount; int pageCount;//共分为几页 pageCount = System.Convert.ToInt32(RecordCount / RcPerPage); if (RecordCount % RcPerPage > 0) { pageCount++; } pagecount = pageCount;//总页数 if (page < 1) { page = 1; } if (pagecount < 1) { pagecount = 1; } p = page / pageLinkNum; p = System.Convert.ToInt32(p); if (page % pageLinkNum > 0) //页签个数 { p = p + 1; } p = (p - 1) * pageLinkNum + 1;//本页签开始数 i = p + (pageLinkNum - 1); //本页结束数 if (i > pagecount)//本页结束数 { i = pagecount; } if (p > pageLinkNum)//如果本页签开始数大于每个页签的页面个数 指向上一个页签的最后一页<< { pageList.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"right\"><tr><td><a href='javascript:void(0);' onclick='pagelist(" + (p - 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pbb.gif\" width=\"15\" height=\"15\" border=\"0\" /></a>"); } else //否则不指向上一个页签的最后一页<< { pageList.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"right\"><tr><td><img class=\"fl\" src=\"/Images/Apple/Comm/pbb.gif\" width=\"15\" height=\"15\" border=\"0\" />"); } if (page == 1)//如果当前页是第一页,则返回上一页的按钮<,则此按钮失效 { pageList.Append("<img class=\"fl\" src=\"/Images/Apple/Comm/pb.gif\" width=\"15\" height=\"15\" border=\"0\" /> </td><td>"); } else //如果当前页不是第一页,则返回上一页的按钮<,则此按钮链接有效 { pageList.Append(" <a href='javascript:void(0);' onclick='pagelist(" + (page - 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pb.gif\" width=\"15\" height=\"15\" border=\"0\" /></a> </td><td>"); } while (p < i)//自本页签的第一页到本页签最后一页前的所有页 { if (p == page) //如果是当前页,高亮显示当前页,链接失效 { pageList.Append("<font class='pagelistnow'>" + p + "</font> | "); } else //否则,不高亮显示,链接有效 { pageList.Append("<a href='javascript:void(0);' class=\"gray\" onclick='pagelist(" + p + ")'>" + p + "</a> | "); } p = p + 1; } //本页签的最后一页 if (p == page) { pageList.Append("<font class='pagelistnow'>" + p + "</font> "); } else { pageList.Append("<a href='javascript:void(0);' class=\"gray\" onclick='pagelist(" + p + ")'>" + p + "</a> "); } // p = p - 1; if ((pagecount - page) == 0) //如果总页数等于当前页数,向后翻页>按钮失效 { pageList.Append("</td><td><img class=\"fl\" src=\"/Images/Apple/Comm/pn.gif\" width=\"15\" height=\"15\" border=\"0\" />"); } else //如果总页数不等于当前页数,向后翻页按钮生效 { pageList.Append("</td><td><a href='javascript:void(0);' onclick='pagelist(" + (page + 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pn.gif\" width=\"15\" height=\"15\" border=\"0\" /></a>"); } if (p < pagecount) //如果本页签的最后一页小于总页数,>>进入下一个页签的第一页 { pageList.Append("<a href='javascript:void(0);' onclick='pagelist(" + (p + 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pnn.gif\" width=\"15\" height=\"15\" border=\"0\" /></a></td></tr></table>"); } else//如果本页签的最后一页等于总页数,《失效 { pageList.Append("<img class=\"fl\" src=\"/Images/Apple/Comm/pnn.gif\" width=\"15\" height=\"15\" border=\"0\" /></td></tr></table>"); } pageList.Append(""); return pageList.ToString(); } protected void Page_Load(object sender, EventArgs e) { Utility.RegisterTypeForAjax(typeof(_DefaultCS)); Utility.RegisterTypeForAjax(typeof(Stu)); //if (!base.Page.ClientScript.IsClientScriptBlockRegistered("bumpscontrol")) //{ // base.Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "bumpscontrol", "<script>var abc=123;</script>"); //} //GridView1.DataSource = new BaseDB().GetTable("select * from users",null); //GridView1.DataBind(); } }
var pagesize=5,pageIndex=1;$(document).ready(loaddata);
function loaddata()
{
$('#display').html("<b><i>车展很好看</i></b>");
$('#display').attr("href","http://www.sohu.com");
$('#display').attr("title","这是一个鼠标移动的提示");
//pagelist();
}
debugger
function pagelist(Index)
{
//debugger;
$('#content').empty();
AjaxStu.GetAllUser(Index,pagesize,user_callback);
}function user_callback(res)
{
var _dtdata=res.value.Tables[0];
var _dtcount=res.value.Tables[1];
$.each(_dtcount.Rows,function(){
$('#pagelist').html(this.pagelist);
});
$.each
(
_dtdata.Rows,
function()
{
var userrow='<tr><td>'+this.id+'</td><td>'+this.name+'</td><td>'+this.address+'</td><td>'+this.age+'</td>';
userrow = userrow+"<td><a href='#' onclick='deluser("+this.id+")'>删除</a></td></tr>";
$(userrow).appendTo($('#content'));
}
);
}function deluser(userid)
{
//alert(userid);
AjaxStu.DeleteUser(userid,
function(res)
{
if(res == '1')
{
pagelist();
}
else
{
alert('哈哈,你失败了');
}
}
)
}
----------------------------
.aspx
--------------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_DefaultCS" %><!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>Ajax.NET Professional - Example</title>
<style type="text/css">
BODY {font-family:Tahoma,Arial;font-size:10pt;}
PRE {font-family:Courier New,Courier;font-size:8pt;}
</style>
</head>
<body>
<form id="form1" runat="server">
<a id="display">
</a>
<input type=button onclick="pagelist(1);" value="sfdsdf" />
<table cellspacing="0" rules="all" border="1" id="GridView1" style="border-collapse:collapse;">
<tr>
<th scope="col">id</th><th scope="col">name</th><th scope="col">address</th><th scope="col">age</th>
<th>操作</th>
</tr>
<tbody id="content">
</tbody> </table><input type=button onclick="pagelist(2);" value="第2页" />
<input type=button onclick="pagelist(3);" value="第3页" />
<input type=button onclick="pagelist(4);" value="第4页" /><div id="pagelist"></div> <script type="text/javascript" src="scripts/jquery-1.2.6.js"></script>
<script type="text/javascript" src="scripts/stu.js"></script> </form>
</body>
</html>----------------------------
.cs
--------------------------------
using System;
using System.Data;
using System.Configuration;
using System.Web;
using AjaxPro;
using System.Data.SqlClient;
using System.Text;[AjaxNamespace("AjaxStu")]
public partial class _DefaultCS : System.Web.UI.Page
{
/// <summary>
/// This method will return the time on the web server.
/// </summary>
/// <returns>The time on the web server.</returns>
[AjaxMethod]
public string GetServerTime()
{
return DateTime.Now.ToString();
} /// <summary>
/// This method will simulate a long running method. Please have
/// a look on the client-side JavaScript code for AjaxPro.onLoading.
/// </summary>
/// <returns>Returns always true.</returns>
[AjaxMethod]
public bool LongOperation()
{
System.Threading.Thread.Sleep(3 * 1000); return true;
} [AjaxMethod]
public string DeleteUser(int id)
{
if (new BaseDB().ExecuteNonQuery("delete from users where id=" + id + "", null))
return "1";
else
return "0";
} [AjaxMethod]
public DataSet GetAllUser(int pageindex, int pagesize)
{
DataSet ds = new DataSet();
DataTable dt;
int count=0;
DataRow drNew; SqlParameter[] par = new SqlParameter[3];
par[0] = new SqlParameter("@pageindex", pageindex);
par[1] = new SqlParameter("@PageSize", pagesize);
par[2] = new SqlParameter("@Count", count);
par[2].Direction = ParameterDirection.Output;
dt = new BaseDB().GetTable("usp_GetAllUserByPage", par);
count = Convert.ToInt32(par[2].Value);
ds.Tables.Add(dt.Copy()); //得到记录总数
dt = new DataTable();
dt.Columns.Add(new DataColumn("pagelist", typeof(string))); drNew = dt.NewRow();
drNew["pagelist"] = AjaxPageList(count, pageindex,pagesize, 10);
dt.Rows.Add(drNew);
ds.Tables.Add(dt.Copy());
return ds;
}
/// <summary>
/// 功能名称:PageList
/// 功能描述:用于分页,可公用
/// </summary>
/// <param name="RecordCount">记录总条数</param>
/// <param name="RcPerPage">每页数</param>
/// <param name="page">显示第几页</param>
/// <param name="pageLinkNum">导航栏上有几个页面</param>
public string AjaxPageList(int RecordCount, int page, int RcPerPage, int pageLinkNum)
{
if (RecordCount <= RcPerPage)
{
return "";
}
StringBuilder pageList = new StringBuilder("");
int p, i;
int pagecount;
int pageCount;//共分为几页 pageCount = System.Convert.ToInt32(RecordCount / RcPerPage);
if (RecordCount % RcPerPage > 0)
{
pageCount++;
}
pagecount = pageCount;//总页数 if (page < 1)
{
page = 1;
}
if (pagecount < 1)
{
pagecount = 1;
} p = page / pageLinkNum;
p = System.Convert.ToInt32(p); if (page % pageLinkNum > 0) //页签个数
{
p = p + 1;
}
p = (p - 1) * pageLinkNum + 1;//本页签开始数
i = p + (pageLinkNum - 1); //本页结束数
if (i > pagecount)//本页结束数
{
i = pagecount;
} if (p > pageLinkNum)//如果本页签开始数大于每个页签的页面个数 指向上一个页签的最后一页<<
{
pageList.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"right\"><tr><td><a href='javascript:void(0);' onclick='pagelist(" + (p - 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pbb.gif\" width=\"15\" height=\"15\" border=\"0\" /></a>");
}
else //否则不指向上一个页签的最后一页<<
{
pageList.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"right\"><tr><td><img class=\"fl\" src=\"/Images/Apple/Comm/pbb.gif\" width=\"15\" height=\"15\" border=\"0\" />");
} if (page == 1)//如果当前页是第一页,则返回上一页的按钮<,则此按钮失效
{
pageList.Append("<img class=\"fl\" src=\"/Images/Apple/Comm/pb.gif\" width=\"15\" height=\"15\" border=\"0\" /> </td><td>");
}
else //如果当前页不是第一页,则返回上一页的按钮<,则此按钮链接有效
{
pageList.Append(" <a href='javascript:void(0);' onclick='pagelist(" + (page - 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pb.gif\" width=\"15\" height=\"15\" border=\"0\" /></a> </td><td>");
} while (p < i)//自本页签的第一页到本页签最后一页前的所有页
{
if (p == page) //如果是当前页,高亮显示当前页,链接失效
{
pageList.Append("<font class='pagelistnow'>" + p + "</font> | ");
}
else //否则,不高亮显示,链接有效
{
pageList.Append("<a href='javascript:void(0);' class=\"gray\" onclick='pagelist(" + p + ")'>" + p + "</a> | ");
} p = p + 1;
}
//本页签的最后一页
if (p == page)
{
pageList.Append("<font class='pagelistnow'>" + p + "</font> ");
}
else
{
pageList.Append("<a href='javascript:void(0);' class=\"gray\" onclick='pagelist(" + p + ")'>" + p + "</a> "); }
// p = p - 1;
if ((pagecount - page) == 0) //如果总页数等于当前页数,向后翻页>按钮失效
{
pageList.Append("</td><td><img class=\"fl\" src=\"/Images/Apple/Comm/pn.gif\" width=\"15\" height=\"15\" border=\"0\" />");
}
else //如果总页数不等于当前页数,向后翻页按钮生效
{
pageList.Append("</td><td><a href='javascript:void(0);' onclick='pagelist(" + (page + 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pn.gif\" width=\"15\" height=\"15\" border=\"0\" /></a>");
} if (p < pagecount) //如果本页签的最后一页小于总页数,>>进入下一个页签的第一页
{
pageList.Append("<a href='javascript:void(0);' onclick='pagelist(" + (p + 1) + ")'><img class=\"fl\" src=\"/Images/Apple/Comm/pnn.gif\" width=\"15\" height=\"15\" border=\"0\" /></a></td></tr></table>");
}
else//如果本页签的最后一页等于总页数,《失效
{
pageList.Append("<img class=\"fl\" src=\"/Images/Apple/Comm/pnn.gif\" width=\"15\" height=\"15\" border=\"0\" /></td></tr></table>");
} pageList.Append("");
return pageList.ToString();
} protected void Page_Load(object sender, EventArgs e)
{
Utility.RegisterTypeForAjax(typeof(_DefaultCS)); Utility.RegisterTypeForAjax(typeof(Stu)); //if (!base.Page.ClientScript.IsClientScriptBlockRegistered("bumpscontrol"))
//{
// base.Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "bumpscontrol", "<script>var abc=123;</script>");
//}
//GridView1.DataSource = new BaseDB().GetTable("select * from users",null);
//GridView1.DataBind();
}
}
找这个插件.