[Solved] Creating a hierarchical data in Treeview from a SQL data source

[Simba]

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



[Shinu]

Hello Simba,

Here is the help document which explains how to create Hierarchy.
Tutorial: Use DataBindings to Create a Hiearchical TreeView.

Thanks,
Shinu.