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控件指定數(shù)據(jù)源            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"        /為上面建立的兩個表創(chuàng)建一個關(guān)系,指明父列和子列的名稱并為他們的關(guān)系命名&

8、#160;       PagedDataSource pds = new PagedDataSource(;        /初始化一個PagedDataSource，允許控件分頁        pds.DataSource = ds.Tables"user".DefaultView;        /將上

9、面的ds轉(zhuǎn)換成標準數(shù)據(jù)視圖        pds.AllowPaging = true;        /允許分頁        pds.PageSize = 5;        /每頁大小為5        pds.CurrentPageIndex

10、 = Convert.ToInt32(Request.QueryString"page"        /設(shè)置當前頁        return pds;        /將處理完畢的pds對象發(fā)出去        protected void myRepeater_ItemDataBound(object

11、sender, RepeaterItemEventArgs e    .        if (e.Item.ItemType = ListItemType.Footer        ./判斷當前項是頁腳模板            int n = pds(.PageCount;/將分頁總數(shù)賦給變量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;        ./如果當前頁已經(jīng)是第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            ./如果當前項已經(jīng)是最末頁                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" %>                 &#