DataList嵌套DataList

DataList嵌套DataList

1.html代码

< HTML >
     < HEAD >
         < title > NestedDataLists </ title >
         < meta  name ="GENERATOR"  Content ="Microsoft Visual Studio .NET 7.1" >
         < meta  name ="CODE_LANGUAGE"  Content ="C#" >
         < meta  name ="vs_defaultClientScript"  content ="JavaScript" >
         < meta  name ="vs_targetSchema"  content ="http://singlepine.cnblogs.com/" >
     </ HEAD >
     < body  MS_POSITIONING ="GridLayout" >
         < form  id ="Form1"  method ="post"  runat ="server" >
             < asp:DataList  runat ="server"  Id ="dlCategories"  GridLines ="Both"  Bordercolor ="black"  cellpadding ="3"
                cellspacing ="0"  Headerstyle-BackColor ="#DDDDDD"  Headerstyle-Forecolor ="#777777"  Headerstyle-Font-Name ="Arial"
                Headerstyle-Font-Size ="14"  Headerstyle-Font-Bold ="true"  Font-Name ="Arial"  Font-Bold ="true"
                Font-Italic ="true"  Font-Size ="11"  ForeColor ="Red"  RepeatColumns ="1" >
                 < HeaderTemplate >
                    省市 & 市区
                 </ HeaderTemplate >
                 < ItemTemplate >
                     <% # DataBinder.Eval(Container, "DataItem.province")  %>
                     < br >
                     < asp:DataList  runat ="server"  Id ="ChildDataList"  GridLines ="None"  Bordercolor ="black"  cellpadding ="3"  cellspacing ="0"  Headerstyle-BackColor ="#8080C0"  Headerstyle-Font-Name ="Arial"  Headerstyle-Font-Size ="8"  Font-Name ="Arial"  Font-Size ="8"  datasource ='<%#  DataBinder.Eval(Container, "DataItem.myrelation") % > ' RepeatColumns="5">
                         < ItemTemplate >
                             &nbsp;   &nbsp;
                             <% # DataBinder.Eval(Container, "DataItem.city")  %>
                         </ ItemTemplate >
                     </ asp:DataList >
                 </ ItemTemplate >
             </ asp:DataList >
         </ form >
     </ body >
</ HTML >

2.cs代码

public   class  NestedDataLists : System.Web.UI.Page
     {
        protected System.Web.UI.WebControls.DataList dlCategories;
    
        private void Page_Load(object sender, System.EventArgs e)
        {
            string constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
            
            DataSet ds=new DataSet();
            string sql1="select * from province";
            SqlDataAdapter    sda1 =new SqlDataAdapter(sql1,constring);
            sda1.Fill(ds,"province");

            string sql2="select * from city";
            SqlDataAdapter    sda2 =new SqlDataAdapter(sql2,constring);
            sda2.Fill(ds,"city");
            
            ds.Relations.Add("myrelation", ds.Tables["province"].Columns["provinceID"], ds.Tables["city"].Columns["father"]);
            dlCategories.DataSource=ds.Tables["province"].DefaultView;
            dlCategories.DataBind();
        }
        
        Web Form Designer generated code#region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /**//// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion
    }