nested data item in asp.net

2012-02-17T21:56:00.000-08:00

coding section

Private Sub dothis()
   Dim con As New OleDbConnection
   con.ConnectionString = ConfigurationManager.ConnectionStrings("ASHDC").ConnectionString.ToString
   Dim qry As String, qry1 As String, qry2 As String
   qry = "select * from placeses where ttid=" & iid & " and tpid=" & iid1 & " "
   Dim cmd1 As New OleDbDataAdapter(qry, con)
   Dim ds As New DataSet()
   cmd1.Fill(ds, "placesess")
   'qry1 = "SELECT p.* FROM Placeses AS p, TourPlace AS tp WHERE tp.TTID=p.TPID"

   qry1 = "select * from destination"
   Dim cmd2 As New OleDbDataAdapter(qry1, con)
   cmd2.Fill(ds, "destination")



   ds.EnforceConstraints = False
   ds.Relations.Add("myrelation", ds.Tables("placesess").Columns("id"), ds.Tables("destination").Columns("Pid"))
   parent1.DataSource = ds.Tables("placesess")
   Page.DataBind()
   con.Close()
   End Sub

in designing section

   <asp:DataList ID="parent1" runat="server" Width="959px">
   <ItemTemplate>

   <table>
   <tr>
   <td style="width: 200px;padding:20px 20px 20px 20px">
<b> <%# DataBinder.Eval(Container.DataItem,"name") %> </b><br />
<asp:Image ID="photo" runat ="server" Width="100px" Height="100px" ImageUrl= '<%# DataBinder.Eval(Container.DataItem,"img") %>' />
   </td>
   <td style="width: 500px; padding:20px 20px 20px 20px ">
   <asp:DataList ID="child" runat="server" DataSource='<%# CType(Container.Dataitem,System.Data.DataRowView).Row.GetChildRows("myrelation") %>'>
   <ItemTemplate>
   <a href="BeachHoneymoon.aspx?pid=<%#DataBinder.Eval(Container.DataItem, "[""id""]")%>&name=<%#DataBinder.Eval(Container.DataItem, "[""titl""]")%> " style="text-decoration:none; color:Black" > <%#DataBinder.Eval(Container.DataItem, "[""titl""]")%> </a>

   <br />
    
   </ItemTemplate>
   </asp:DataList></td>
   </tr>
   </table>
   <br>
   </ItemTemplate>
   </asp:DataList>

Query for nseted counting

SELECT Category.Category, count(member.category) AS ProductCount FROM Category LEFT JOIN member ON Category.id = member.Category GROUP BY ategory.Category

Nested Item Data In Asp.net

nested data item in asp.net