Hello:
I am trying to create a hierarchical view using a tree view such that
the parent nodes are the region names and the child nodes are the country names
I have the below set up and SQL query.
I am not getting the desired behavour, what is wrong with the below set up?
<
asp:Panel
runat
=
"server"
ID
=
"Panel1"
Style
=
"float: left; width: 373px; border-right: 1px solid #B1D8EB;"
>
<
telerik:RadTreeView
ID
=
"RadTreeView1"
runat
=
"server"
CheckBoxes
=
"True"
TriStateCheckBoxes
=
"true"
CheckChildNodes
=
"true"
DataFieldID
=
"CountryID"
DataSourceID
=
"SqlDataSource1"
DataTextField
=
"Country"
DataValueField
=
"Country"
DataFieldParentID
=
"RegionID"
>
</
telerik:RadTreeView
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:xxxxxx %>" SelectCommand="SELECT CC.cty_name_formal as Country,CR.CountryID AS CountryID,Region as Region,RR.RegionID as RegionID
FROM COUNTRYDB.countrydb.dbo.vw_iso_cty AS CC
INNER JOIN dbo.OMBC_CountryRegion AS CR
ON CC.ISO_code = CR.ISOCODE
INNER JOIN dbo.OMBC_Region RR
ON CR.RegionID=RR.RegionID
ORDER BY RR.RegionID">
</
asp:SqlDataSource
>
</
asp:Panel
>
Thanks