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
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