
1.html代码
csharp 代码
- <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>
-
- <%# DataBinder.Eval(Container, "DataItem.city") %>
- </ItemTemplate>
- </asp:DataList>
- </ItemTemplate>
- </asp:DataList>
- </form>
- </body>
- </HTML>
2.cs代码
csharp 代码
- 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)
- {
-
-
-
- InitializeComponent();
- base.OnInit(e);
- }
-
- /// <summary>
-
-
-
- private void InitializeComponent()
- {
- this.Load += new System.EventHandler(this.Page_Load);
-
- }
- #endregion
- }
3.演示数据库下載:/Files/singlepine/area1.rar
转自:http://www.cnblogs.com/singlepine/archive/2006/04/03/365964.html
另附:关于“不能启用此约束,因为不是所有的值都具有相应的父值”的解决方法