This is a migrated thread and some comments may be shown as answers.

Treelist DataBind

1 Answer 71 Views
TreeList
This is a migrated thread and some comments may be shown as answers.
Brinda
Top achievements
Rank 1
Brinda asked on 08 Dec 2010, 09:19 AM
Hi,

I am having a result set with the structure of
Level1                         Level2           Level3               CalcField
---------------------------------------------------------------------------
Akron                Cleveland OH         2007-QTR 1     206172.0000
Akron                Cleveland OH         2007-QTR 2     225291.0000
Akron                Cleveland OH         2007-QTR 3     210866.0000
Allen                  Dallas-Fort Worth  TX 2009-QTR 1 27241.0000
Allen                  Dallas-Fort Worth  TX 2009-QTR 2 62850.0000
Allen                  Dallas-Fort Worth  TX 2009-QTR 3 100539.0000

And the output of the treelist should be,
Akron
        Cleveland OH               642329.0000
               2007-QTR 1         206172.0000
               2007-QTR 2         225291.0000
               2007-QTR 3         210866.0000
Allen  
       Dallas-Fort Worth         90091.0000
               TX 2009-QTR 1   27241.0000
               TX 2009-QTR 2   62850.0000

I have gone through the samples with ParentKeyname and DataKeyNames Concept.But i dont have the parentid concept in my query.
Can anyone help me..its urgent..
Any best way to achieve this?

1 Answer, 1 is accepted

Sort by
0
Tsvetoslav
Telerik team
answered on 10 Dec 2010, 10:42 AM
Hi Brinda,

In your case, you should employe the RadGrid control with two group-by expressions - one for the Level 1 field and one for the Level 2 field. Here is an online example with more information on that:
http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/outlookstyle/defaultcs.aspx
http://www.telerik.com/help/aspnet-ajax/grdbasicgrouping.html

Hope it helps.

Regards,
Tsvetoslav
the Telerik team
Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
Tags
TreeList
Asked by
Brinda
Top achievements
Rank 1
Answers by
Tsvetoslav
Telerik team
Share this question
or