本文實例講述了html">asp.net利用后臺實現(xiàn)直接生成html分頁的方法，是一個比較實用的功能。分享給大家供大家參考之用。具體方法如下：
1.建立存儲過程：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
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 |
目前實驗的是每頁5條數(shù)據(jù)，傳入當前頁碼就可以了
2.前臺定義一個div ，用于顯示
|
1
2
|
<div id="divPage" runat="server" class="divpage"> </div> |
3.后臺根據(jù)傳入?yún)?shù)來拼html
目前是模仿博客園的模式，前后顯示5條，多余的加...后到最后一條。具體代碼如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
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.測試效果如下圖所示：
希望本文所述對大家的asp.net程序設計有所幫助。
