Repeater HFG
数据库脚本:
use master
go
if exists(select name from sys.databases where name='Test_Page')
drop database Test_Page
go
create database Test_Page
go
use Test_Page
go
--表:T_Person
if exists(select name from sys.objects where name='T_Person')
drop table T_Person
go
create table T_Person
(
C_ID int identity(1,1),
C_Name nvarchar(50),
C_Address nvarchar(200),
C_Call varchar(11),
constraint PK_T_Person_C_ID primary key(C_ID)
)
go
--insert into T_Person(C_Name,C_Address,C_Call) values('curitsyang','广东深圳','12510441277')
--go
--存储过程;InsertIntoT_Person
if exists(select name from sys.objects where name='InsertIntoT_Person')
drop procedure InsertIntoT_Person
go
create procedure InsertIntoT_Person
as
begin
declare @i int
set @i=0
while(@i<10)
begin
insert into T_Person(C_Name,C_Address,C_Call) values('curitsyang','广东深圳','13510441277')
set @i=@i+1
end
end
go
execute InsertIntoT_Person
go
select * from T_Person
go
aspx:
<asp:Repeater ID="Repeater_1" runat="server">
<HeaderTemplate>
<div>
</div>
<table cellpadding="0" cellspacing="0" id="main">
<caption style="width: 450px; height: 40px; line-height: 45px; text-align: center;">
<strong>Person</strong></caption>
<tr>
<td>
编号
</td>
<td>
姓名
</td>
<td>
地址
</td>
<td>
电话
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%# Eval("C_ID") %>
</td>
<td>
<%# Eval("C_Name") %>
</td>
<td>
<%# Eval("C_Address") %>
</td>
<td>
<%# Eval("C_Call") %>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
<div style="margin-top: 5px;">
</div>
<webdiyer:AspNetPager ID="AnpFy" runat="server" AlwaysShow="true" FirstPageText="第一页"
PrevPageTex="上一页" NextPageText="下一页" LastPageText="最后一页" PageSize="3" OnPageChanged="AspNetPage_Changed">
</webdiyer:AspNetPager>
aspx.cs:
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
this.Bind();
}
}
protected void Bind()
{
string sql = "select * from T_Person";
Repeater_1.DataSource = PageFenYe(new SQLHelper().ExecuteDataTable(sql));
Repeater_1.DataBind();
}
private PagedDataSource PageFenYe(System.Data.DataTable table)
{
this.AnpFy.RecordCount = table.Rows.Count;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.DataSource = table.DefaultView;
pds.CurrentPageIndex = this.AnpFy.CurrentPageIndex - 1;
pds.PageSize = this.AnpFy.PageSize;
return pds;
}
protected void AspNetPage_Changed(object sender, EventArgs e)
{
this.Bind();
}