Nested Repeater

microsoft.public.dotnet.framework.aspnet.webcontrols

7 Sep 2006 6:53 PM

DE_Kabal

I relatively new to ASP.Net, coming from a ColdFusion background. I'm trying
to create a report that does the following in a table:

Organization1
url       pass   failed
url       pass   failed
url       pass   failed
Organization2
url       pass   failed
url       pass   failed
url       pass   failed

I tried using 2 SQLDataSources and could only get one organization then all
the other data not sorted. I then tried the MicroSoft example, with some
variation, and that didn't work. The result above comes from a single table.
Here is the code I am using from the MS example:

<asp:Repeater ID="parentRepeater" runat="server">
    <HeaderTemplate>
      <table border="1" cellpadding="3" cellspacing="0" summary="this table
for layout">
        <tr>
          <td scope="col">Agency</td>
        </tr>
    </HeaderTemplate>
    <ItemTemplate>
      <tr>
        <td>
          <strong><%# DataBinder.Eval(Container.DataItem, "agency")
%></strong>
        </td>
            <asp:Repeater ID="childRepeater" runat="server"
              DataSource='<%#
Container.DataItem.Row.GetChildRows("myrelation") %>'>
              <ItemTemplate>
                <tr>
                  <td><%# DataBinder.Eval(Container.DataItem, "url") %></td>
                  <td><%# DataBinder.Eval(Container.DataItem, "filespass")
%></td>
                  <td><%# DataBinder.Eval(Container.DataItem, "filesfailed")
%></td>
                </tr>
              </ItemTemplate>
            </asp:Repeater>
      </tr>
    </ItemTemplate>
</asp:Repeater>

Codebehind
Dim strConn1 As String =
ConfigurationManager.ConnectionStrings("accmon").ConnectionString
        Dim MySQL1 As String = "SELECT DISTINCT agency FROM websites WHERE
webDelete = 0 AND webNew = 0"
        Dim MyConn1 As New OleDbConnection(strConn1)
        Dim cmd1 As New OleDbDataAdapter(MySQL1, MyConn1)
        Dim ds As DataSet = New DataSet()
        cmd1.Fill(ds, "websites")

        'Create table for child repeater
        Dim MySQL2 As String = "SELECT webID, url, files508, pass508,
failed508, verify508 FROM websites " & _
            "WHERE webDelete = 0 AND webNew = 0"
        Dim cmd2 As New OleDbDataAdapter(MySQL2, MyConn1)
        cmd2.Fill(ds, "weburl")
        ds.Relations.Add("myrelation", _
        ds.Tables("websites").Columns("agency"), _
        ds.Tables("weburl").Columns("url"))
        parentRepeater.DataSource = ds.Tables("websites")
        Page.DataBind()
        MyConn1.Close()

--
cheers;
DE_Kabal