Multilevel Hierarchial Datagrids

[Rythm Music]

I am trying to get some help on creating a Multilevel Hierarchial
Datagrid. What I mean is that the Hierarchial level is unknown. There
could be many related records or none. Also there could be multiple
categories. Hopefully the data below will give some idea.

Here is some data:

Category Amount
1 10
1.1 5
1 5
1.1.1 5
2 20
2.1 10
3 50
I would like to display this into a datagrid. I think I can display the
data into the datagrid, but I would like it to be a collapsale datgrid,
so that the user can read summarized information easily. I have not
figured the select statment yet because I first want to know how that
data will be displayed.

Datgrid View (Collapsable):
Category Amount(Sub Categories Total)
1 15(10)
->1.1 5(5)
-->1.1.1 5
2 20(10)
->2.1 10
3 50(0)

Any help will be great.
Thanks,
rythm

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Nicholas Paldino [.NET/C# MVP]]

Rythm,

The problem with this is that the result sets from SQL queries are
tabular, and not heiarchical. What you need to do is create the child
tables which have a field indicating the parent record. Then, you have to
cycle through the table and place the records in the child tables, linking
them up.

Then, when you attach the whole data set to the data grid, you should be
able to drill down (but you won't be able to see everything on the screen at
once, since the grid is tabular, and not a tree control).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Rythm Music" <ry******@yahoo.com> wrote in message
news:OH**************@TK2MSFTNGP11.phx.gbl...

I am trying to get some help on creating a Multilevel Hierarchial
Datagrid. What I mean is that the Hierarchial level is unknown. There
could be many related records or none. Also there could be multiple
categories. Hopefully the data below will give some idea.

Here is some data:

Category Amount
1 10
1.1 5
1 5
1.1.1 5
2 20
2.1 10
3 50
I would like to display this into a datagrid. I think I can display the
data into the datagrid, but I would like it to be a collapsale datgrid,
so that the user can read summarized information easily. I have not
figured the select statment yet because I first want to know how that
data will be displayed.

Datgrid View (Collapsable):
Category Amount(Sub Categories Total)
1 15(10)
->1.1 5(5)
-->1.1.1 5
2 20(10)
->2.1 10
3 50(0)

Any help will be great.
Thanks,
rythm

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Rythm Music]

I had considered a Parent Child relationship, but the problem is that
there could be a multlevel relationship.

Parent->Child->GrandChild->GreatGrandChild...
1->1.1->1.1.1->1.1.1.1....

That is where the problem is with that approach.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!