[Solved] Populate TreeView with nodes

[Jugoslav]

I was wondering if there is a better approach than this one?
http://www.telerik.com/help/aspnet-ajax/treeview-data-binding-loading-related-tables.html

I have two tables (Countries and TvChannels) there and the following query:

SELECT
Ct.CountryName, Tv.ChannelID, Tv.ChannelName
FROM TvChannels AS Tv
INNER JOIN
Countries AS Ct
ON Tv.CountryID = Ct.CountryID
WHERE Tv.IsActive = 1

Is there a better way to utilize this query instead so i can get the expected result e.g.
- United States
---- Channel No. 1
---- Channel No. 2
- United Kingdom
---- Channel No. 1
---- Channel No. 2
- Denmark
---- Channel No. 1
---- Channel No. 2
etc.

[Jugoslav]

Is this forum working at all? Please don't reply if you want me to be buy your controls first !!!
If it's the case please make the forum accessible ONLY FOR THE RadControls owners!!!

I was your customer and i strongly recommended your stuff mostly because of the good support. Now i see that i was laying to my blog readers so most probably i am gonna revise that.

Yeah good idea i am gonna write a new review about your service and support.

I guess you gonna DELETE this post but it's ok i already took a screenshot

P.S. you dont even bother to answer MOST of the people's questions. Yeah i went there checking the threads and i saw 100's UnAnswered posts. Shame on you!

[Kate]

Hi Jugoslav,

In general the question for the query that you are currently using is not directly related to the RadTreeView control although you are referring to the Loading Related SQL Tables help article. However, here are few suggestions that you can try out. On the first place, in order to establish the child-parent relationship of the control, you will need to use the DataFieldParentID and the DataFieldID properties of the RadTreeView (as explained here). Please refer to the following forum post where you can find more information and an example demonstrating how you can get the desired data from related tables - Telerik ASP.NET AJAX RadTreeView Display Hierarchical Data from two Joined Tables.

Regarding your question about Telerik Forum - please note that the response time of Telerik team members in the forums is not guaranteed and it is not with high priority. This is due to the fact that the tickets that we receive are being answered according to their priority. Forums, as the current case, have the lowest priority for answering and the tickets from our current customers have the highest priority.
More details about usage of Telerik Forum you can find here.

Additionally please find more details about response time of support tickets at the “Support options” article.

I hope that this is enough explanatory. I will be happy to assist you should you have any other questions. 

Regards,
Kate
Telerik