DataList in DataList

acko · November 10th, 2003, 01:29 PM

Hi
I have a problem something like this
I want to show in datalist customers but below to show orders for customer.

I created datalist control and inside it i have to label for CustomerID and CompanyName and bind these labels without problems to dataset. But I do not know what to do next. Can i put the other data list in the first or something else and how can i bind it.
Thanks a lot
Alex

cgoldrin · December 2nd, 2003, 05:04 AM

Nested datalists are no problem. At least two deep...

Try this .aspx out (if you have SQL Server), modify as necessary:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<html>
<head>
    <meta name="GENERATOR" Content="ASP Express 2.1">
    <title>Nested DataLists</title>
<script language="VB" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
    Dim strConn as string = "server=localhost;uid=USERID;pwd=PASSWORD;database =Northwind"
    Dim MySQL as string = "Select CategoryID, CategoryName from Categories"
    Dim MyConn as New SQLConnection(strConn)
    Dim ds as DataSet=New DataSet()

    Dim Cmd as New SQLDataAdapter(MySQL,MyConn)
    Cmd.Fill(ds,"Categories")

            Dim cmd2 As SqlDataAdapter = New SqlDataAdapter("select * from Products", MyConn)
            cmd2.Fill(ds, "Products")

            ds.Relations.Add("myrelation", ds.Tables("Categories").Columns("CategoryID"), ds.Tables("Products").Columns("CategoryID"))

    dlCategories.Datasource=ds.Tables("Categories").De faultView
    DataBind()
End Sub

Function doFormat(sItem as Decimal)
    Dim s as String
    s=String.Format("{0:c}", sItem)
    doFormat=s
End function

</script>
</head>
<body>
<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>
        Categories & Products
    </HeaderTemplate>
    <ItemTemplate><%# Container.DataItem("CategoryName")%>
         <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='<%# Container.DataItem.Row.GetChildRows("myrelation") %>'
                RepeatColumns="3">
                <ItemTemplate>
                        <%# Container.DataItem("ProductName") %>
                     - <%# doFormat(Container.DataItem("UnitPrice")) %>

                </ItemTemplate>
            </ASP:DataList>
    </ItemTemplate>
</ASP:DataList>
</body>
</html>

orcities · July 9th, 2004, 04:31 PM

Ok so what if one of the categories doesn't have anything under it. I get an error in that case. How do you suggest to get around it.

Daniel A. Miller

orcities · July 9th, 2004, 05:18 PM

This constraint cannot be enabled as not all values have corresponding parent values.

Daniel A. Miller