Repeater控件的嵌套使用、自定义分页及加链接,样式制定

1、Repeater控件的嵌套使用、自定义分页及加链接，样式制定源代码 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.HtmlControl

2、s;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page .    protected void Page_Load(object sender, EventArgs e    .        if (!IsPostBack        .   

3、60;        myRepeater.DataSource = pds(;            /为Repeater1控件指定数据源            myRepeater.DataBind(;        

4、0;   /这个当然是必须的,绑定上去                private PagedDataSource pds(    .        SqlConnection myconn = new SqlConnection("Data Source=08;Initial CataLog=陈乐斌;User

5、 ID=sa;Password=yttvmedia"        myconn.Open(;        SqlDataAdapter da = new SqlDataAdapter("select id,username,password,email,tel,age from user order by id desc", myconn;       

6、 DataSet ds = new DataSet(;        da.Fill(ds, "user"        SqlDataAdapter da2 = new SqlDataAdapter("select classid,classname,teachername,id,time,score,slevel from class", myconn;     

7、   da2.Fill(ds, "class"        ds.Relations.Add("myrela", ds.Tables"user".Columns"id", ds.Tables"class".Columns"id"        /为上面建立的两个表创建一个关系,指明父列和子列的名称并为他们的关系命名&

8、#160;       PagedDataSource pds = new PagedDataSource(;        /初始化一个PagedDataSource，允许控件分页        pds.DataSource = ds.Tables"user".DefaultView;        /将上

9、面的ds转换成标准数据视图        pds.AllowPaging = true;        /允许分页        pds.PageSize = 5;        /每页大小为5        pds.CurrentPageIndex

10、 = Convert.ToInt32(Request.QueryString"page"        /设置当前页        return pds;        /将处理完毕的pds对象发出去        protected void myRepeater_ItemDataBound(object

11、sender, RepeaterItemEventArgs e    .        if (e.Item.ItemType = ListItemType.Footer        ./判断当前项是页脚模板            int n = pds(.PageCount;/将分页总数赋给变量n 

12、60;          int i = pds(.CurrentPageIndex;/将当前分页码赋给i            Label lblpc = (Labele.Item.FindControl("lblpc"            lblpc.Text =

13、 n.ToString(;            /找到lblpc这个Label，将总页码赋给他            Label lblp = (Labele.Item.FindControl("lblp"            lblp.Text

14、 = Convert.ToString(pds(.CurrentPageIndex+1;            /找到lblp这个Label，将当前页码赋给他，但是注意，因为页码从0开始，这里要直观的话就得加1            HyperLink hlfir = (HyperLinke.Item.FindControl("hlfir" 

15、60;          hlfir.NavigateUrl = "?page=0"            HyperLink hlla = (HyperLinke.Item.FindControl("hlla"            hlla.Na

16、vigateUrl = "?page="+Convert.ToInt32(n-1;            /找到表示最前页和末页的Label，为他们的NavigateUrl属性赋为第0页和最大页码减1            HyperLink hlp = (HyperLinke.Item.FindControl("hlp" &#

17、160;          HyperLink hln = (HyperLinke.Item.FindControl("hln"            /找到表示上页和下页这两个控件            if (i <= 0   &

18、#160;        ./如果当前页已经是第0页                hlfir.Enabled = false;                hlp.Enabled = false;  

19、60;             hln.Enabled = true;                        else           

20、.                hlp.NavigateUrl = "?page=" + Convert.ToInt32(i-1;                        if (i > n -

21、2            ./如果当前项已经是最末页                hln.Enabled = false;                hlla.Enabled = fa

22、lse;                hlp.Enabled = true;                        else        

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

24、60; DropDownList ddlpage = (DropDownListe.Item.FindControl("ddlpage"            for (int p = 0; p < n; p+            .          

25、;      ddlpage.Items.Add(Convert.ToString(p + 1;                if (p = i                .      

26、;              ddlpage.SelectedIndex = p;                                  

27、          protected void ddl_SelectedChanged(object sender, EventArgs e    .        DropDownList ddl = (DropDownListsender;        Page.Response.Redirect("?page=" +(Conve

28、rt.ToInt32(ddl.SelectedItem.Value-1;    aspx文件：<% Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %><% Import Namespace="System.Data" %>">/1999/xhtml&qu

29、ot; >                                                       &#

30、160;                                                       &

31、#160;                                                       

32、                                                        

33、;                                                       

34、0;                                                       

35、60;                                                       &#

36、160;                                                       &

37、#160;                                                       

38、                                        编号                姓名

39、                密码                年龄                电话      

40、          邮箱                <%# DataBinder.Eval(Container.DataItem,"id" %>                <%# DataBin

41、der.Eval(Container.DataItem,"username" %>                <%# DataBinder.Eval(Container.DataItem,"password" %>                <%#

42、 DataBinder.Eval(Container.DataItem,"age" %>                <%# DataBinder.Eval(Container.DataItem,"tel" %>                mailto:&

43、lt;%# Eval("email" %>"><%# DataBinder.Eval(Container.DataItem,"email" %>                        <%# DataBinder.Eval(Container.DataItem,""classnam

44、e"" %>                <%# DataBinder.Eval(Container.DataItem,""teachername"" %>                <%# DataBinder.Eval(Con

45、tainer.DataItem,""time"" %>                <%# DataBinder.Eval(Container.DataItem,""score"" %>                &

46、lt;%# DataBinder.Eval(Container.DataItem,""slevel"" %>                <%# Eval("id" %>                <%# Eval("u

47、sername" %>                <%# Eval("password" %>                <%# Eval("age" %>      &#

48、160;         <%# Eval("tel" %>                mailto:<%# Eval("email" %>"><%# Eval("email" %>                 &#