Repeater控件的嵌套使用、自定义分页及加链接，样式制定源代码。

来源：互联网发布：mysql 退出当前数据库编辑：程序博客网时间：2024/05/29 12:29

Repeater控件自定义分页及加链接，样式制定源代码。

效果：

.cs文件代码：

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

myRepeater.DataSource = pds();

//为Repeater1控件指定数据源

myRepeater.DataBind();

//这个当然是必须的,绑定上去

}

private PagedDataSource pds()

{

SqlConnection myconn = new SqlConnection("Data Source=192.168.201.108;Initial CataLog=陈乐斌;User ID=sa;Password=yttvmedia");

myconn.Open();

SqlDataAdapter da = new SqlDataAdapter("select id,username,password,email,tel,age from [user] order by id desc", myconn);

DataSet ds = new DataSet();

da.Fill(ds, "user");

SqlDataAdapter da2 = new SqlDataAdapter("select classid,classname,teachername,id,time,score,slevel from [class]", myconn);

da2.Fill(ds, "class");

ds.Relations.Add("myrela", ds.Tables["user"].Columns["id"], ds.Tables["class"].Columns["id"]);

//为上面建立的两个表创建一个关系,指明父列和子列的名称并为他们的关系命名

PagedDataSource pds = new PagedDataSource();

//初始化一个PagedDataSource，允许控件分页

pds.DataSource = ds.Tables["user"].DefaultView;

//将上面的ds转换成标准数据视图

pds.AllowPaging = true;

//允许分页

pds.PageSize = 5;

//每页大小为5

pds.CurrentPageIndex = Convert.ToInt32(Request.QueryString["page"]);

//设置当前页

return pds;

//将处理完毕的pds对象发出去

}

protected void myRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)

{

if (e.Item.ItemType == ListItemType.Footer)

{//判断当前项是页脚模板

int n = pds().PageCount;//将分页总数赋给变量n

int i = pds().CurrentPageIndex;//将当前分页码赋给i

Label lblpc = (Label)e.Item.FindControl("lblpc");

lblpc.Text = n.ToString();

//找到lblpc这个Label，将总页码赋给他

Label lblp = (Label)e.Item.FindControl("lblp");

lblp.Text = Convert.ToString(pds().CurrentPageIndex+1);

//找到lblp这个Label，将当前页码赋给他，但是注意，因为页码从0开始，这里要直观的话就得加1

HyperLink hlfir = (HyperLink)e.Item.FindControl("hlfir");

hlfir.NavigateUrl = "?page=0";

HyperLink hlla = (HyperLink)e.Item.FindControl("hlla");

hlla.NavigateUrl = "?page="+Convert.ToInt32(n-1);

//找到表示最前页和末页的Label，为他们的NavigateUrl属性赋为第0页和最大页码减1

HyperLink hlp = (HyperLink)e.Item.FindControl("hlp");

HyperLink hln = (HyperLink)e.Item.FindControl("hln");

//找到表示上页和下页这两个控件

if (i <= 0)

{//如果当前页已经是第0页

hlfir.Enabled = false;

hlp.Enabled = false;

hln.Enabled = true;

}

else

{

hlp.NavigateUrl = "?page=" + Convert.ToInt32(i-1);

}

if (i > n - 2)

{//如果当前项已经是最末页

hln.Enabled = false;

hlla.Enabled = false;

hlp.Enabled = true;

}

else

{

hln.NavigateUrl = "?page=" + Convert.ToInt32(i+1);

}

DropDownList ddlpage = (DropDownList)e.Item.FindControl("ddlpage");

for (int p = 0; p < n; p++)

{

ddlpage.Items.Add(Convert.ToString(p + 1));

if (p == i)

{

ddlpage.SelectedIndex = p;

}

protected void ddl_SelectedChanged(object sender, EventArgs e)

{

DropDownList ddl = (DropDownList)sender;

Page.Response.Redirect("?page=" +(Convert.ToInt32(ddl.SelectedItem.Value)-1));

}

aspx文件：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Import Namespace="System.Data" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:Repeater ID="myRepeater" runat="server" OnItemDataBound="myRepeater_ItemDataBound">

编号

</th>

<th>

姓名

</th>

<th>

密码

</th>

<th>

年龄

</th>

<th>

电话

</th>

<th>

邮箱

</th>

</tr>

</HeaderTemplate>

<tr>

<td>

<%# DataBinder.Eval(Container.DataItem,"id") %>

</td>

<td>

<%# DataBinder.Eval(Container.DataItem,"username") %>

</td>

<td>

<%# DataBinder.Eval(Container.DataItem,"password") %>

</td>

<td>

<%# DataBinder.Eval(Container.DataItem,"age") %>

</td>

<td>

<%# DataBinder.Eval(Container.DataItem,"tel") %>

</td>

<td>

</td>

</tr>

<asp:Repeater ID="myRepeater2" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrela") %>'>

</td>

<%# DataBinder.Eval(Container.DataItem,"["classname"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["teachername"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["time"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["score"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["slevel"]") %>

</td></tr>

</ItemTemplate>

</asp:Repeater>

</ItemTemplate>

<tr>

<%# Eval("id") %>

</td>

<%# Eval("username") %>

</td>

<%# Eval("password") %>

</td>

<%# Eval("age") %>

</td>

<%# Eval("tel") %>

</td>

</td>

</tr>

<asp:Repeater ID="myRepeater2" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("myrela") %>'>

</td>

<%# DataBinder.Eval(Container.DataItem,"["classname"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["teachername"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["time"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["score"]") %>

</td>

<%# DataBinder.Eval(Container.DataItem,"["slevel"]") %>

</td></tr>

</ItemTemplate>

</asp:Repeater>

</AlternatingItemTemplate>

<tr>

</td></tr>

</SeparatorTemplate>

<tr>

<td colspan="6" style="font-size: 9pt; color: #0099ff; background-color: #e6feda;">共 <asp:Label ID="lblpc" runat="server" Text="Label"></asp:Label> 页　当前为第 <asp:Label ID="lblp" runat="server" Text="Label"></asp:Label> 页

<asp:HyperLink ID="hlfir" runat="server" Text="首页"></asp:HyperLink>

<asp:HyperLink ID="hlp" runat="server" Text="上一页"></asp:HyperLink>

<asp:HyperLink ID="hln" runat="server" Text="下一页"></asp:HyperLink>

<asp:HyperLink ID="hlla" runat="server" Text="末页"></asp:HyperLink>

跳转到<asp:DropDownList ID="ddlpage" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddl_SelectedChanged">

</asp:DropDownList>

</td>

</tr>

</table>

</FooterTemplate>

</asp:Repeater>

</div>

</form>

</body>

</html>

有个小问题就是分页时地址栏中显示的页数比实际页数小1，例如：总共有12页，则地址栏中显示?page=0----11
正常应为：?page=1---12有人露过的话帮改下，谢谢过。