Question

[Guest]

HI guys, I have a sql query

SELECT tableA.Description , tableA.MenuText, TableB.id FROM TableA INNER JOIN
TableB ON TableA.id = TableB.LCID ORDER BY TableA.id

and the result is as follows:
1 menu1
1 menu2
1 menu3
2 menu4
2 menu5
3 menu6
3 menu7

Is there any way this data can be displayed in heirarchy form using repeater
or any other control? it should be displayed as following:
1
menu1
menu2
menu3
2
menu4
menu5
3
menu6
menu7

Thanks

Manny

 

[Guest]

The only way I've been able to get this to work is by using nested datalists.

Hope this helps..... Rich