asp.net利用后臺(tái)實(shí)現(xiàn)直接生成html分頁(yè)的方法

2020-03-24 15:59:37

字體：大中小

供稿：網(wǎng)友

本文實(shí)例講述了asp.net利用后臺(tái)實(shí)現(xiàn)直接生成html分頁(yè)的方法，是一個(gè)比較實(shí)用的功能。分享給大家供大家參考之用。具體方法如下：1.建立存儲(chǔ)過(guò)程：ALTER procedure [dbo].[p_news_query]@Page intbeginselect 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 where A.RowNumber (@Page-1)*5目前實(shí)驗(yàn)的是每頁(yè)5條數(shù)據(jù)，傳入當(dāng)前頁(yè)碼就可以了2.前臺(tái)定義一個(gè)div ，用于顯示 div id="divPage" runat="server" /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() + "/" 上一頁(yè) /a if (ITotalPage = 10) for (int i = 1; i = ITotalPage; i++) if (i == IPage) sbr.Append(" a href=/"news.aspx p=" + i.ToString() + "/" "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() + "/" "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() + "/" "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() + "/" "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() + "/" 下一頁(yè) /a divPage.InnerHtml = sbr.ToString(); rptNews.DataSource = pageLogic.QueryNews(IPage); rptNews.DataBind();4.測(cè)試效果如下圖所示：希望本文所述對(duì)大家的asp.net程序設(shè)計(jì)有所幫助。更多編程語(yǔ)言

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

上一篇：H5與傳統(tǒng)html的區(qū)別

下一篇：html5播放視頻的標(biāo)簽是什么？如何在web頁(yè)面播放視頻呢？（內(nèi)附實(shí)例）