Referencing outer repeater value from inner repeater

[VBRookie]

Hi,

I have nested repeaters which are working fine. The problem that I'm having is trying to display the value of the first (outer) repeater inside of the second (inner) repeater. Here is my code:

<!-- FIRST REPEATER -->
<asp:Repeater ID="rptSchools" runat="server">
      <ItemTemplate>
         <table cellspacing="0" cellpadding="0">
            <tr>
               <td class="SitePageTitle"><%# Container.DataItem("Name").ToString.Trim %></td>
            </tr>
            <tr>
               <td> 
                  <br />

<!-- SECOND REPEATER -->
                  <asp:Repeater ID="rptPortals" runat="server">
                     <ItemTemplate>
                        <table cellspacing="0" cellpadding="0">
                           <tr>
                              <td>
                                 <a href="<%# Container.DataItem("SchoolLogonURL").ToString.Trim %>">
                                    SOME TEXT HERE
                                 </a> 
                                 
<!-- VALUE FROM FIRST REPEATER -->
                                 <%# Container.DataItem("ValueFromOuterRepeaterHere").ToString.Trim %>

                              </td>
                           </tr>
                        </table>
                     </ItemTemplate>
                  </asp:Repeater>
               </td>
            </tr>
         </table>
      </ItemTemplate>
   </asp:Repeater>

This is my codebehind:

Protected Sub rptSchools_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles rptSchools.ItemDataBound
      Dim item As RepeaterItem = e.Item
      Dim schoolId As Object
      Dim siteCode As Object
      Dim drv As System.Data.Common.DbDataRecord = CType(item.DataItem, System.Data.Common.DbDataRecord)
      Dim rpt As Repeater = CType(item.FindControl("rptPortals"), Repeater)

      schoolId = drv("SchoolID")
      siteCode = drv("SiteCode")

      SQLCmd = "Select ..."
      dtRdr = DB.GetReader("Resources", SQLCmd)
      rpt.DataSource = dtRdr
      rpt.DataBind()
   End Sub

I bind the first repeater in my page load with a different sql statement. Is there a way to do what I'm attempting?

Please advise.
Many Thanks,
- VB Rookie

 

[BoulderBum]

A quick-and-dirty solution would be to have a class-level CurrentValue field or property that you set when the parent repeater starts binding, then look to when the second repeater binds.