1.代码
<
HTML
>
<
HEAD
>
<
title
>
NestedDataLists
</
title
>
<
name
="GENERATOR"
Content
="Microsoft Visual Studio .NET 7.1"
>
<
name
="CODE_LANGUAGE"
Content
="C#"
>
<
name
="vs_defaultClient"
content
="Java"
>
<
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代码
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
}























































































