parent-child asp.net page output from a ms sql table

pageId title parentId nodeIndex 1 home 0 0 2 child 1 of home 1 0 3 child 2 of home 1 1 4 child 1 of child 1 2 0 5 child 2 of child 1 2 1 where nodeindex is the manual sort order. I need the output from the database to be shown in the correct parent-child order. the output cannot be a varchar since it will be larger than 8000chars. home child 1 of home child 1 of child 1 child 2 of child 2 child 2 of home