SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Aug 2005
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question treeview w/ drill down/into data

    What I'd like to do is use a tree view on some route to help allow users to drill down into their data.



    For instance, we have a table w/ 100 numbers, and they're nvarchar(100).



    For simplicity sake, 50 start with D1, and the other 50 start with E1.



    Under the 50 that start with D1, they are grouped by a dot and some more characters up to the next dot:

    1. D1.01

    2. D1.02

    3. D1.03

    4. D1.04

    5. D1.05



    When the page first loads, the 2 nodes would show:

    D1

    E1



    ..and if the user clicked D1, they'd see new nodes which took the next chars up to any next "dot" and listed the groupings/nodes like above.

    1. D1.01

    2. D1.02

    3. D1.03

    4. D1.04

    5. D1.05



    ..and if the user clicked on D1.02, and the data would show like:

    1. D1.02.01

    2. D1.02.02

    3. D1.02.03



    ...and if the user clicked on D1.02.03, they would see new nodes of:

    1. D1.02.03.001

    2. D1.02.03.02

    3. D1.02.03.03B


    ..or something like that. Basically, each time the user clicks the node, we show a "dot" and two more characters...or up to the next "dot".

    I have the tree view working now, but it's pretty much a one-for-one, and that's not very helpful for this scenario.



    Thanks!

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,625
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    If you have Sql 2005, you could probably best handle this with Sql Server Reporting Services.

  3. #3
    SitePoint Enthusiast
    Join Date
    Aug 2005
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi wwb_99,

    We're needing this for Sharepoint Web parts and integration with other applications via their APIs.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •