1.html code
<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 = "# dddddddd" 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> province and city </HeaderTemplate> <ItemTemplate> <% # DataBinder. eval (Container, "DataItem. province ") %> <br> <asp: dataList runat = "server" Id = "ChildDataList" GridLines = "None" Bordercolor = "black" cellpadding = "3" cellspacing = "0" Headerstyle-BackColor = "#80c0" Headerstyle -Font-Name = "Arial" Headerstyle-Font-Size = "8" Font-Name = "Arial" Font-Size = "8" datasource = '<% # DataBinder. eval (Container, "DataItem. myrelation ") %> 'repeatcolumns =" 5 "> <ItemTemplate> & nbsp; <% # DataBinder. eval (Container, "DataItem. city ") %> </ItemTemplate> </asp: DataList> </form> </body> </HTML>
2. cs code
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 }
This article is from the "Code stupid" blog, please be sure to keep this source http://garynote.blog.51cto.com/6350207/1215619