Populate TreeView with nodes

3 posts, 0 answers
  1. Jugoslav
    Jugoslav avatar
    64 posts
    Member since:
    Mar 2011

    Posted 26 Jul 2013 Link to this post

    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.
  2. Jugoslav
    Jugoslav avatar
    64 posts
    Member since:
    Mar 2011

    Posted 26 Jul 2013 Link to this post

    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!
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Kate
    Admin
    Kate avatar
    1898 posts

    Posted 31 Jul 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Back to Top