DataList嵌套DataList(使用DataSet.Relations属性)

来源：互联网发布：波士顿矩阵分析法ppt 编辑：程序博客网时间：2024/05/14 02:56

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>
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
    }