三層+存儲過程實(shí)現(xiàn)分頁示例代碼_

1、三層+存儲過程實(shí)現(xiàn)分頁示例代碼_ 前臺設(shè)計： 代碼如下: % Page Language=C# AutoEventWireup=true CodeBehind=paging.aspx.cs Inherits=五二一練習(xí).paging % !DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional/EN l1/DTD/xhtml1-transitional.dtd html xmlns=l head runat=server title/title script src=js/Jquery1.7.js type=text/javascript/sc

2、ript script type=text/javascript $(function () $(#txtPagination).focus(function () $(this).val(); ) ) /script /head body form id=form1 runat=server div asp:GridView ID=GridView1 runat=server AutoGenerateColumns=False Height=336px Width=685px Columns asp:BoundField DataField=Id HeaderText=編號 / asp:Bo

3、undField DataField=NewsTitle HeaderText=標(biāo)題 / asp:BoundField DataField=NewsContent HeaderText=內(nèi)容 / asp:BoundField DataField=CreateTime DataFormatString=0:yyyy-MM-dd hh:mm:ss HeaderText=發(fā)布時間 / /Columns /asp:GridView asp:LinkButton ID=btnFirst runat=server onclick=btnFirst_Click第一頁/asp:LinkButton asp:L

4、inkButton ID=btnPre runat=server onclick=btnPre_Click上一頁/asp:LinkButton asp:LinkButton ID=btnNext runat=server onclick=btnNext_Click下一頁/asp:LinkButton asp:LinkButton ID=btnLast runat=server onclick=btnLast_Click最終一頁/asp:LinkButtonasp:TextBox ID=txtPagination runat=server/asp:TextBox asp:LinkButton I

5、D=btnSkip runat=server onclick=btnSkip_ClickGO/asp:LinkButton /div /form /body /html 首先在數(shù)據(jù)庫創(chuàng)建存儲過程 代碼如下: create proc usp_role_GetDateByPageIndex pageSize int, pageIndex int as begin select * from ( select *,ROW_NUMBER() over(order by role_id) as rownumber from role) as tbl where tbl.rownumber between

6、 (pageSize*(pageIndex-1)+1) and pageIndex*pageSize end exec usp_role_GetDateByPageIndex 5,3 在項(xiàng)目中添加BLL,DAL,DataAccess,MODEL層 在DAL中寫一個方法： 代碼如下: /自己寫的方法，分頁獵取數(shù)據(jù)列表 public DataTable GetListDataTable(int PageSize, int PageIndex) SqlParameter parameters = new SqlParameter(PageSize, SqlDbType.Int), new SqlPa

7、rameter(PageIndex, SqlDbType.Int) ; parameters0.Value = PageSize; parameters1.Value = PageIndex; return DbHelperSQL.RunProcedureDataTable(usp_role_GetDateByPageIndex, parameters); 在BLL中調(diào)用GetListDataTable： public DataTable GetListDataTable(int pagesize, int pageindex) return dal.GetListDataTable(page

8、size, pageindex); 在DbHelper中添加RunProcedureDataTable方法： public static DataTable RunProcedureDataTable(string stroreProcName, IDataParameter parameters) using (SqlConnection connection = new SqlConnection(connectionString) DataTable dt = new DataTable(); connection.Open(); SqlDataAdapter sqlDA = new S

9、qlDataAdapter(); sqlDA.SelectCommand = BuildQueryCommand(connection, stroreProcName, parameters); sqlDA.Fill(dt); connection.Close(); return dt; 然后在后臺調(diào)用即可： 代碼如下: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls;

10、 using System.Data; namespace 練習(xí) public partial class paging : System.Web.UI.Page int pagesize = 10; int pageindex = 1; protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) ViewStatepageindex = 1; LadaData(); GetListPageindex(); private void GetListPageindex() BLL.T_News1 bnews = ne

11、w BLL.T_News1(); int totalcount = bnews.GetRecordCount(); if (totalcount % pagesize = 0) ViewStatelastpageindex = totalcount / pagesize; else ViewStatelastpageindex = totalcount / pagesize + 1; private void LadaData() BLL.T_News1 bnews = new BLL.T_News1(); DataTable dt = bnews.GetListDataTable(pages

12、ize, Convert.ToInt32(ViewStatepageindex); this.GridView1.DataSource = dt; this.GridView1.DataBind(); /第一頁 protected void btnFirst_Click(object sender, EventArgs e) ViewStatepageindex = 1; LadaData(); /上一頁 protected void btnPre_Click(object sender, EventArgs e) int pageindex = Convert.ToInt32(ViewSta

13、tepageindex); if (pagesize1) pageindex-; ViewStatepageindex = pageindex; LadaData(); /下一頁 protected void btnNext_Click(object sender, EventArgs e) int pageindex = Convert.ToInt32(ViewStatepageindex); if (pageindexConvert.ToInt32(ViewStatelastpageindex) pageindex+; ViewStatepageindex = pageindex; LadaData(); /最終一頁 protected void btnLast_Click(object sender, EventArgs e) ViewStatepageindex = ViewStatelastpageindex; LadaData(); /跳轉(zhuǎn)頁面 protected void btnSkip_C