第一种方式：
数据库连接代码：
01 |
using System; |
02 |
using System.Data; |
03 |
using System.Configuration; |
04 |
using System.Web; |
05 |
using System.Web.Security; |
06 |
using System.Web.UI; |
07 |
using System.Web.UI.WebControls; |
08 |
using System.Web.UI.WebControls.WebParts; |
09 |
using System.Web.UI.HtmlControls; |
10 |
using System.Data.SqlClient; |
11 |
using System.Data.Sql; |
12 |
13 |
14 |
15 |
public partial class _Default : System.Web.UI.Page |
16 |
{ |
17 |
private void con() |
18 |
{ |
19 |
string connstring = ConfigurationManager.ConnectionStrings["AdventureWorksDWConnectionString"].ConnectionString; |
20 |
SqlConnection con = new SqlConnection(connstring); |
21 |
SqlConnection conn = new SqlConnection(); |
22 |
DataSet ds = new DataSet(); |
23 |
SqlDataAdapter sda = new SqlDataAdapter("select * from FactSalesQuota", con); |
24 |
sda.Fill(ds, "name"); |
25 |
SqlDataAdapter sda2 = new SqlDataAdapter("select * from ProspectiveBuyer", con); |
26 |
sda2.Fill(ds, "title"); |
27 |
PagedDataSource pds = new PagedDataSource(); |
28 |
pds.DataSource = ds.Tables["name"].DefaultView; |
29 |
//PagedDataSource aa = new PagedDataSource(); |
30 |
pds.AllowPaging = true;//允许分页 |
31 |
pds.PageSize = 8;//单页显示项数 |
32 |
int CurPage; |
33 |
if (Request.QueryString["Page"] != null) |
34 |
CurPage = Convert.ToInt32(Request.QueryString["Page"]); |
35 |
else |
36 |
CurPage = 1; |
37 |
pds.CurrentPageIndex = CurPage - 1; |
38 |
int Count = pds.PageCount; |
39 |
40 |
lblCurrentPage.Text = "当前页：" + CurPage.ToString(); |
41 |
labPage.Text = Count.ToString(); |
42 |
43 |
if (!pds.IsFirstPage) |
44 |
{ |
45 |
this.first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1"; |
46 |
this.last.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(Count - 1); ; |
47 |
up.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1); |
48 |
} |
49 |
else |
50 |
{ |
51 |
this.first.Visible = false ; |
52 |
this.last.Visible = false ; |
53 |
54 |
} |
55 |
56 |
if (!pds.IsLastPage) |
57 |
{ |
58 |
59 |
60 |
next.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); |
61 |
} |
62 |
else |
63 |
{ |
64 |
this.first.Visible = false; |
65 |
this.last.Visible = false; |
66 |
67 |
} |
68 |
69 |
Repeater1.DataSource = pds ; |
70 |
Repeater1.DataBind(); |
71 |
72 |
} |
73 |
74 |
75 |
76 |
protected void Page_Load(object sender, EventArgs e) |
77 |
{ |
78 |
if (!IsPostBack) |
79 |
{ |
80 |
con(); |
81 |
this.first.Visible = true; |
82 |
this.last.Visible = true; |
83 |
//this.Repeater1.DataSource = pds(); |
84 |
//this.Repeater1.DataBind(); |
85 |
86 |
} |
87 |
88 |
} |
89 |
} |
aspx文件代码：
01 |
<table> |
02 |
<tr ><td class="style1" align ="left" >hehe</td></tr> |
03 |
04 |
<tr ><td class="style1"> |
05 |
<asp:Repeater ID="Repeater1" runat="server" > |
06 |
07 |
<HeaderTemplate ><table><tr><td>头模板</td></tr></HeaderTemplate> |
08 |
<ItemTemplate ><tr><td ><font color="red" > <%#Eval("timekey")%></font></td></tr></ItemTemplate> |
09 |
<AlternatingItemTemplate ><tr><td > <a href ='Default.aspx?id=<%#"databaselogid" %>'><%#Eval("SalesAmountQuota")%></a></td></tr></AlternatingItemTemplate> |
10 |
<FooterTemplate ><tr><td>尾模板</td></tr></table></FooterTemplate> |
11 |
</asp:Repeater> |
12 |
</td> </tr> |
13 |
14 |
15 |
<tr> <td class="style1"> |
16 |
<asp:HyperLink ID="first" runat="server">首页</asp:HyperLink> |
17 |
<asp:HyperLink ID="next" runat="server">下一页</asp:HyperLink> |
18 |
<asp:HyperLink ID="up" runat="server">上一页</asp:HyperLink> |
19 |
<asp:HyperLink ID="last" runat="server">末页</asp:HyperLink> |
20 |
</td></tr> |
21 |
22 |
<tr><td class="style1">当前页为：<asp:Label ID="lblCurrentPage" runat="server" |
23 |
Text="Label"></asp:Label> |
24 |
<br /> |
25 |
共<asp:Label ID="labPage" runat="server" Text="Label"></asp:Label> |
26 |
页</td></tr> |
27 |
28 |
</table> |
第二种方式：
01 |
using System; |
02 |
using System.Collections; |
03 |
using System.Configuration; |
04 |
using System.Data; |
05 |
using System.Linq; |
06 |
using System.Web; |
07 |
using System.Web.Security; |
08 |
using System.Web.UI; |
09 |
using System.Web.UI.HtmlControls; |
10 |
using System.Web.UI.WebControls; |
11 |
using System.Web.UI.WebControls.WebParts; |
12 |
using System.Xml.Linq; |
13 |
using System.Data.SqlClient; |
14 |
15 |
public partial class databind : System.Web.UI.Page |
16 |
{ |
17 |
18 |
protected void Page_Load(object sender, EventArgs e) |
19 |
{ |
20 |
if (!IsPostBack) |
21 |
{ |
22 |
num.Text = "1"; |
23 |
repdatabind(); |
24 |
} |
25 |
26 |
27 |
} |
28 |
public void repdatabind() |
29 |
{ |
30 |
string connstring = ConfigurationManager.ConnectionStrings["AdventureWorksDWConnectionString"].ConnectionString; |
31 |
SqlConnection con = new SqlConnection(connstring); |
32 |
SqlConnection conn = new SqlConnection(); |
33 |
DataSet ds = new DataSet(); |
34 |
SqlDataAdapter sda = new SqlDataAdapter("select * from DimProduct", con); |
35 |
sda.Fill(ds, "name"); |
36 |
PagedDataSource pds = new PagedDataSource(); |
37 |
pds.DataSource = ds.Tables["name"].DefaultView; |
38 |
pds.AllowPaging = true;//允许分页 |
39 |
pds.PageSize = 8;//单页显示项数 |
40 |
41 |
int curpage = Convert.ToInt32(num.Text); |
42 |
this.BtnDown.Enabled = true; |
43 |
this.BtnUp.Enabled = true; |
44 |
pds.CurrentPageIndex = curpage - 1; |
45 |
if (curpage == 1) |
46 |
{ |
47 |
this.BtnUp.Enabled = false; |
48 |
} |
49 |
if (curpage == pds.PageCount) |
50 |
{ |
51 |
this.BtnDown.Enabled = false; |
52 |
} |
53 |
this.Repeater1.DataSource = pds; |
54 |
this.Repeater1.DataBind(); |
55 |
} |
56 |
57 |
protected void BtnUp_Click(object sender, EventArgs e) |
58 |
{ |
59 |
this.num.Text =Convert.ToString ( Convert.ToInt32(num.Text)- 1) ; |
60 |
repdatabind(); |
61 |
} |
62 |
protected void BtnDown_Click(object sender, EventArgs e) |
63 |
{ |
64 |
this.num.Text = Convert.ToString(Convert.ToInt32(num.Text)+ 1) ; |
65 |
repdatabind(); |
66 |
} |
67 |
} |
aspx代码：
01 |
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="databind.aspx.cs" Inherits="databind" %> |
02 |
03 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
04 |
05 |
<html xmlns="http://www.w3.org/1999/xhtml"> |
06 |
<head runat="server"> |
07 |
<title>无标题页</title> |
08 |
</head> |
09 |
<body> |
10 |
<form id="form1" runat="server"> |
11 |
<div> |
12 |
13 |
<asp:Panel ID="Panel1" runat="server" Height="173px"> |
14 |
<asp:Repeater ID="Repeater1" runat="server"><HeaderTemplate ><table border onmousedown="1" ><tr><td >头模板</td></tr></HeaderTemplate><ItemTemplate ><tr><td>序号：<%# Eval("ProductKey") %></td></tr><tr><td>编码：<%# Eval("ProductAlternateKey") %></td></tr></ItemTemplate><FooterTemplate ><tr><td>脚模板</td></tr></table>< /FooterTemplate> |
15 |
</asp:Repeater> |
16 |
当前页：<asp:Label ID="num" runat="server"></asp:Label> |
17 |
<br /> |
18 |
<asp:Button ID="BtnUp" runat="server" onclick="BtnUp_Click" Text="上一页" /> |
19 |
<asp:Button ID="BtnDown" runat="server" onclick="BtnDown_Click" Text="下一页" /> |
20 |
</asp:Panel> |
21 |
<br /> |
22 |
<br /> |
23 |
24 |
</div> |
25 |
</form> |
26 |
</body> |
27 |
</html> |
