標籤：style blog http io ar color os sp java
留資料，以後學慣用
1.後台
public ActionResult textPage() { return View(); } [HttpPost] public ActionResult textPage(FormCollection collection) { //執行個體化對象 BLL.pc_dialog bll_pcdialog = new BLL.pc_dialog(); Model.pc_dialog model_pcdialog = new Model.pc_dialog(); //a=當前頁碼 b=頁碼顯示量 int a = int.Parse(Request["currentpage"]) - 1; string b = Request["pagesize"]; //SQL語句 string sqlString = "select * from pc_dialog order by Dia_Id limit " + a + "," + b; //查出來需要的頁碼然後將DATASET轉化為LIST，具體轉化方式百度 List<Model.pc_dialog> list = ConvertHelper<Model.pc_dialog>.ConvertToList(DbHelperMySQL.Query(sqlString).Tables[0]); //Json不能接受DATSET 只能接收list return Json(list); }MVC簡單的AJax非同步分頁
2.前台
<html><head> <title>FindArchiveTable</title> <script src="../../Scripts/jquery-1.7.2.min.js" type="text/javascript"></script> <script type="text/javascript"> //頁面載入時候調用局部重新整理 $(function () { page(1, 10); }) function page(currentpage, pagesize) { $(‘#tb‘).html(‘‘); $.post("/PC/textPage"/*URL*/, { currentpage: currentpage, pagesize: pagesize}/*回傳值*/, function (obj) { var tr = "<tr><th> 編號</th><th>姓名 </th> </tr>"; /*抬頭*/ console.info(obj.length); /*列表長度*/ for (var i = 0; i < obj.length; i++) { /*迴圈調取值給予tr*/ tr += "<tr><td>" + obj[i].Dia_Id + "</td><td> " + obj[i].Pro_Id + "</td></tr>"; } /*將Table更新，這裡要和ID對應*/ console.info(tr); $(tr).appendTo($(‘#tb‘)); }) } </script></head><body> <table id="tb"> </table> <ul> <li><a href="javascript:" onclick="page(1,10)">1</a></li> <li><a href="javascript:" onclick="page(2,10)">2</a></li> <li><a href="javascript:" onclick="page(3,10)">3</a></li> </ul></body></html>MVC簡單的AJAX非同步分頁前端
MVC 簡單的AJAX非同步分頁+MYSQL
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
