TreeView Control and DataRelations

[Phil Townsend]

I have a dataset that contains multiple tables, each with the same
structure, and each tied to the next through a datarelation object. The
number of tables in the dataset can fluctuate. I am stuck on figuring
out the best way to use this structure to populate a tree view control.
I've experimented with recursive calls to the same method without much
success, though I've not abandoned this idea. Any suggestions?

Data structure:
column["pageID"]
column["pageParentID"]
column["pageTitle"]

Data relation:
parent column["pageID"]
child column["pageParentID"]

child rows can also be parent rows...

*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?U2hhbmU=?=]

Hi Phil,

I beleive this may help you
http://www.vikramlakhotia.com/post.aspx?postid=127 but you will still need
to correctly setup your tables and data for recursive lookups. I personaly
have used three tables i.e. faq, faq_cat, faq_sub_cat and it works in a
treeview.

Hope this helps

"Phil Townsend" wrote:

I have a dataset that contains multiple tables, each with the same
structure, and each tied to the next through a datarelation object. The
number of tables in the dataset can fluctuate. I am stuck on figuring
out the best way to use this structure to populate a tree view control.
I've experimented with recursive calls to the same method without much
success, though I've not abandoned this idea. Any suggestions?

Data structure:
column["pageID"]
column["pageParentID"]
column["pageTitle"]

Data relation:
parent column["pageID"]
child column["pageParentID"]

child rows can also be parent rows...

*** Sent via Developersdex http://www.developersdex.com ***