Treelist DataBind

2 posts, 0 answers
  1. Brinda
    Brinda avatar
    9 posts
    Member since:
    Dec 2010

    Posted 08 Dec 2010 Link to this post


    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,
            Cleveland OH               642329.0000
                   2007-QTR 1         206172.0000
                   2007-QTR 2         225291.0000
                   2007-QTR 3         210866.0000
           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?

  2. Tsvetoslav
    Tsvetoslav avatar
    1823 posts

    Posted 10 Dec 2010 Link to this post

    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:

    Hope it helps.

    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.
Back to Top