时间：2021-07-01 10:21:17 帮助过：13人阅读
- <br><%@ Page Language="C#" AutoEventWireup="true" CodeFile="SqlPage.aspx.cs" Inherits="SqlPage" %> <br><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <br><html xmlns="http://www.w3.org/1999/xhtml"> <br><head runat="server"> <br><title></title> <br><link href="css/pagination.css" rel="stylesheet" type="text/css" /> <br></head> <br><body> <br><form id="form1" runat="server" > <br><div> <br><table id="tblData" width="80%" cellpadding="1" cellspacing="1" bgcolor="gray" style="text-align:center"> <br><tr> <br><td> <br>NewsID <br></td> <br><td> <br>Title <br></td> <br><td> <br>SmallClassName <br></td> <br><td> <br>Author <br></td> <br><td> <br>UpdateTime <br></td> <br></tr> <br></table> <br><div id="Pagination"> <br></div> <br></div> <br></form> <br></body> <br></html> <br><script src="js/jquery-1.4.2.min.js" type="text/javascript"></script> <br><script src="js/jquery.pagination.js" type="text/javascript"></script> <br><script language="javascript" type="text/javascript"> <br>var pageIndex =0; //页索引 <br>var pageSize =20; //每页显示的条数 <br>$(function() { <br>Init(0); <br>$("#Pagination").pagination(<%=pageCount %>, { <br>callback: PageCallback, <br>prev_text: '上一页', <br>next_text: '下一页', <br>items_per_page: pageSize, <br>num_display_entries: 5, <br>current_page: pageIndex, <br>num_edge_entries: 1 <br>}); <br>function PageCallback(index, jq) { <br>Init(index); <br>} <br>}); <br>function Init(pageIndex) { <br>$.ajax({ <br>type: "POST", <br>dataType: "text", <br>url: 'SqlPage.aspx', <br>data: "pageIndex=" + (pageIndex + 1) + "&pageSize=" + pageSize, <br>success: function(data) { <br>if(data!=""){ <br>$("#tblData tr:gt(0)").remove();//移除所有的数据行 <br>data=$.parseJSON(data); <br>$.each(data.News,function(index,news){ <br>$("#tblData").append("<tr bgcolor='white'><td>"+news.NewsID+"</td><td algin='left'>"+news.Title+"</td><td>"+news.SmallClassName+"</td><td>"+news.Author+"</td><td>"+news.Updatetime+"</td></tr>"); //将返回的数据追加到表格 <br>}); <br>} <br>} <br>}); <br>} <br></script> <br> <br>cs代码： <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>using System; <br>using System.Collections.Generic; <br>using System.Linq; <br>using System.Web; <br>using System.Web.UI; <br>using System.Web.UI.WebControls; <br>using System.Data; <br>public partial class SqlPage : System.Web.UI.Page <br>{ <br>public int pageCount = 0; <br>public static string connString = "server=192.168.1.91;database=ReportDB;uid=sa;pwd=123456"; <br>protected void Page_Load(object sender, EventArgs e) <br>{ <br>if (!IsPostBack) <br>{ <br>pageCount = GetTotalPage(); <br>if (Request["pageIndex"] != null && Request["pageSize"] != null) <br>{ <br>int pageSize = Convert.ToInt32(Request["pageSize"]) == 0 ? 1 : Convert.ToInt32(Request["pageSize"]); <br>int pageIndex = Convert.ToInt32(Request["pageIndex"]) == 0 ? 1 : Convert.ToInt32(Request["pageIndex"]); <br>Response.Write(GetOnePage(pageSize, pageIndex)); <br>Response.End(); <br>} <br>} <br>} <br>public int GetTotalPage() <br>{ <br>DBHelper.connString = connString; <br>string sql = "select count(*) from News"; <br>int rs = Convert.ToInt32(DBHelper.ExecuteScalar(sql)); <br>return rs; <br>} <br>public string GetOnePage(int pageSize, int pageIndex) <br>{ <br>DBHelper.connString = connString; <br>string sql = string.Empty; <br>sql = "SELECT TOP " + pageSize + " NewsID,Title,SmallClassName,Author,Updatetime FROM News WHERE NewsID NOT IN (SELECT TOP " + pageSize * (pageIndex - 1) + " NewsID FROM News ORDER BY NewsID DESC) ORDER BY NewsID DESC"; <br>DataTable dt = DBHelper.QueryBySql(sql); <br>return ConvertJson.ToJson(dt, "News"); <br>} <br>} <br> <br></li><li> </li><li> </li></ol></pre>