<asp:Repeater id="parentRepeater" runat="server">
				                                <itemtemplate>
					                                <br /><br /><b>
						                                <%#DataBinder.Eval(Container.DataItem, "category")%>
						                                <img src='images/divider/<%#DataBinder.Eval(Container.DataItem, "ID")%>_divider.jpg'  alt="<%#DataBinder.Eval(Container.DataItem, "category")%>"/>
					                                </b>
					                                <br>
					                                <asp:repeater id="childRepeater" runat="server" datasource='<%# Container.DataItem.Row.GetChildRows("myrelation") %>'>
                                                        <itemtemplate>
 
                                                           <a href='products.aspx?catID=<%#container.dataitem("CatID")%>&pID=<%#container.Dataitem("ID")%>' class="categoryLink">
							                               <img src='images/products/<%#Container.DataItem("PNumber")%>t.jpg'alt="<%#Container.DataItem("PName")%>" border="1"  \></a>
 
Private Sub Load_CategoryRepeater()
 
        Dim CatId As String
        CatId = Request.QueryString("catID")
        Dim cnn As SqlConnection = New SqlConnection("Server=localhost;Database=xxx;Integrated Security=SSPI")
        Dim cmd1 As New SqlDataAdapter("select * from category where parentID = '" _
        & CatId & "'", cnn)
 
 
        'Create and fill the DataSet.
        Dim ds As New DataSet()
        cmd1.Fill(ds, "category")
 
        Dim cmd2 As New SqlDataAdapter _
              ("SELECT Category.Category, Products.PNumber, Products.ID, Products.PName, Products.PPrice, Products.PDescription, Products.CatID, Category.ID AS CategoryID, Category.ParentID FROM Category INNER JOIN Products ON Category.ID = Products.CatID Where Category.ParentID ='" _
        & CatId & "'", cnn)
 
        cmd2.Fill(ds, "product")
 
        ds.Relations.Add("myrelation", ds.Tables("category").Columns("ID"), ds.Tables("product").Columns("CatID"))
 
 
        parentRepeater.DataSource = ds.Tables("category")
        parentRepeater.DataBind()
 
 
        cnn.Close()
    End Sub     
						                                </itemtemplate>
					                                </asp:repeater> 
				                                </itemtemplate>
			                                </asp:Repeater>