parent-child 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.


child 1 of home

child 1 of child 1

child 2 of child 2

child 2 of home

Taidot: .NET, ASP

Näytä lisää: parent child mssql aspnet, parent child asp net, mssql parent child, aspnet database parent child, sql sort parent child, the vip, parent, child, page database, net order, sort table, page order, output table, title page, sort database sql, asp table, asp sql database, table database, parent child, sort sql, child parent sql, table page, sql order, sql child parent, output

Tietoa työnantajasta:
( 88 arvostelua ) Støvring, Denmark

Projektin tunnus: #121371

Myönnetty käyttäjälle:


Dear Sir/Madam, This job can be done quick and easilly with best quality and professionalism. I have all required knowledges and experience to achieve success of this project. Please see my profile. Pelase check Lisää

$30 USD 0 päivässä
(30 Arvostelua)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


hi, please give me some clarity in PMB.

$30 USD 0 päivässä
(54 arvostelua)

I understand you problem with this tree. I can help you. Please look at the PMB.

$30 USD 4 päivässä
(7 arvostelua)

Hi, please check pmb. Thanks

$30 USD 1 päivässä
(24 arvostelua)