RadTreeList Self-Referencing Hierarchy Binding

[Raka]

Hello

I can create this RadTreeList with a parent and child key from a table.

However I have the following structure --

Table 1

-----------

ParentId_1    SomeData

1                       <abc>

2                       <abc>

 

Table 2

-----------------

ParentId_2     ParentId_1       Child_Id

Null                  1                      2147

2147                 1                      2176

2176                  1                     2179

2176                   1                    2180

Null                      2                    5283

5283                     2                    20131 etc.

 

I need a result that looks like --

> 1

         > 2147   

                        > 2176

                                          >2179

                                           >2180

>2

                > 5283

                            >20131

 

What I am getting is this--

> 1
         > 2147   
                        > 2176
                                          >2179
                                           >2180
                > 5283
                            >20131

> 2
         > 2147   
                        > 2176
                                          >2179
                                           >2180
                > 5283
                            >20131

 

Is it possible to get the result that I want with data separated in two tables?

If not, can you suggest an alternative?

 

Thanks
Raka

[Stef]

Hello Raka,

Telerik Reporting does not contain a RadTreeList.
If you are referring to RadTreeList control of Telerik UI for ASP.NET AJAX, please check the following help articles:

• Structure
• Load on Demand
• Hierarchical Self-Reference Binding of RadTreeView

My recommendation is to post your question through the support ticketing system or in the forum of the corresponding product. Thus your inquiry can be addressed by the team having the knowledge of the used control that can help you best.

Regards,
Stef
Telerik

[Raka]

Hello -- I am not talking about Reporting.  I am talking about the UI control RadTreeList.  By display I mean the filtered results from some DB query that I get back in my code.  I was using RadGrid and nestedGrids but for some reason they create a lot of blank lines below each row that gets displayed and it is not very clean.
I read somewhere that RadTreeList was a newer way to show self-referencing hierarchial data. 
My question is how do I declare parentDataKeyNames and DataKeyNames when I have more than one parent key, like in my example above.
If I only have one parent and one child, it works.  But in the above case, even though it creates the right structure, it displays it as many times as there are grandParentKeys.

Thanks
Sandhia

[Viktor Tachev]

Hi Raka,

I suggest we use the other thread you have submitted to continue the conversation.

Regards,
Viktor Tachev
Telerik