本文實(shí)例講述了ASP.NET利用后臺(tái)實(shí)現(xiàn)直接生成html分頁(yè)的方法，是一個(gè)比較實(shí)用的功能。分享給大家供大家參考之用。具體方法如下：

1.建立存儲(chǔ)過(guò)程：

ALTER procedure [dbo].[p_news_query]@Page intasbeginselect top 5 new_id,new_title,new_url,new_content_text,create_time,user_name from  (select *,ROW_NUMBER() over(order by new_id desc ) as RowNumber  from    (select new_id,new_title,new_url,new_content_text,        dbo.f_ConvertDate(a.create_time) create_time, b.user_name from xs_new a        left join xs_users b on b.user_no=a.create_user)TI ) A  where A.RowNumber>(@Page-1)*5end

目前實(shí)驗(yàn)的是每頁(yè)5條數(shù)據(jù)，傳入當(dāng)前頁(yè)碼就可以了

2.前臺(tái)定義一個(gè)div ，用于顯示

 <div id="divPage" runat="server" class="divpage">  </div>

3.后臺(tái)根據(jù)傳入?yún)?shù)來(lái)拼html

目前是模仿博客園的模式，前后顯示5條，多余的加...后到最后一條。具體代碼如下：

  StringBuilder sbr = new StringBuilder();  int ITotalCount = pageLogic.QueryNewsCount();  int IPage = 1;  if (Request["p"] != null)  { IPage = Convert.ToInt32(Request["p"]);  }  int IPageCount = 5;  int ITotalPage = ITotalCount / IPageCount;  if (ITotalCount % IPageCount > 0)  { ITotalPage += 1;  }  if (IPage != 1)  { sbr.Append("<a href=/"news.ASPx?p=" + (IPage - 1).ToString() + "/"></a>");  }  if (ITotalPage <= 10)  { for (int i = 1; i <= ITotalPage; i++) {   if (i == IPage)   { sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/" class=/"pageSelect/">" + i.ToString() + "</a>");   }   else   { sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/">" + i.ToString() + "</a>");   } }  }  else  { if (IPage - 5 > 2 && IPage + 7 < ITotalPage)//前后都有的 {   sbr.Append("<a href=/"news.ASPx?p=1/">1</a>...");   for (int i = IPage - 5; i <= IPage + 5; i++)   { if (i == IPage) {   sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/" class=/"pageSelect/">" + i.ToString() + "</a>"); } else {   sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/">" + i.ToString() + "</a>"); }   }   sbr.Append("...<a href=/"news.ASPx?p=" + ITotalPage.ToString() + "/">" + ITotalPage.ToString() + "</a>"); } else if (IPage - 5 <= 2)//前面不夠，后面有多余 {   for (int i = 1; i <= 10; i++)   { if (i == IPage) {   sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/" class=/"pageSelect/">" + i.ToString() + "</a>"); } else {   sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/">" + i.ToString() + "</a>"); }   }   sbr.Append("...<a href=/"news.ASPx?p=" + ITotalPage.ToString() + "/">" + ITotalPage.ToString() + "</a>"); } else if (IPage + 7 >= ITotalPage)//前面多余，后面不足 {   sbr.Append("<a href=/"news.ASPx?p=1/">1</a>...");   for (int i = ITotalPage - 10; i <= ITotalPage; i++)   { if (i == IPage) {   sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/" class=/"pageSelect/">" + i.ToString() + "</a>"); } else {   sbr.Append("<a href=/"news.ASPx?p=" + i.ToString() + "/">" + i.ToString() + "</a>"); }   } }  }  if (IPage != ITotalPage)  { sbr.Append("<a href=/"news.ASPx?p=" + (IPage + 1).ToString() + "/"></a>");  }  divPage.InnerHtml = sbr.ToString();  rptNews.DataSource = pageLogic.QueryNews(IPage);  rptNews.DataBind();

4.測(cè)試效果如下圖所示：

希望本文所述對(duì)大家的ASP.NET程序設(shè)計(jì)有所幫助。

AspNet技術(shù)：asp.net利用后臺(tái)實(shí)現(xiàn)直接生成html分頁(yè)的方法，轉(zhuǎn)載需保留來(lái)源！

鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。