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 >
<% # DataBinder.Eval(Container, "DataItem.city") %>
</ ItemTemplate >
</ asp:DataList >
</ ItemTemplate >
</ asp:DataList >
</ form >
</ body >
</ HTML >
2.cs代码
< 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 >
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
}
3.演示数据库
/Files/singlepine/area1.rar
{
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
}