DataGrid GrandParent/Parent/Child in 1 Datagrid

[LerkHern]

Is it possible to have a multi tier datagrid display the values from multiple tables in a collapsible view (like a treeview)

also, I don't want them to be collapsed ever, just organized like the example below

(and each grandparent/parent/child record should be able to have multiple columns too)

I know you can buy 3rd party grids that will do this, but I'd like that to be the last resort because of cost.
(open to any other non-grid suggestions also)

for example:

|_grandparent
|         |_____parent
|         |         |______child
|         |         |______child
|         |         |______child
|         |_____parent
|                   |______child
|                   |______child
|                   |______child
|_grandparent
|         |_____parent
|         |         |______child
|         |_____parent
|                   |______child
|                   |______child
|_grandparent
|         |_____parent
|         |         |______child
|         |         |______child
|         |_____parent
|                   |______child
|                   |______child
|                   |______child

 

[LerkHern]

I couldn't find a good way to do it so I folded and bought Janus GridEX which is easy to use and works great.