• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Treeview design question

Hi-
I'm developing a web site in c# (VS 2005) and need to use a treeview to build a navigation bar. However, I'd like to build it in such a way to use it in the site on other pages as there are other pages on this site that use treeviews for site functionality.

I'd like the treeview to be flexible in such a way that there are unlimted nodes/branches from root to leaves. Also, I'd like to return the treeview data be means of a stored proc.. I'm also curious as to what the table structure would/should look like as I would like the treeview to be controlled from sql table(s). Ultimately, I'd like to be able to do this in a reusable class, but this is not a requirement

Thoughts/Ideas?
0
KBSLPDev
Asked:
KBSLPDev
  • 4
  • 2
1 Solution
 
JimBrandleyCommented:
Which DataBase provider will you use?
0
 
KBSLPDevAuthor Commented:
I'm attaching to a ms sql 2k server.
0
 
JimBrandleyCommented:
OK - That will take a different DB design than if you had said Oracle.  When you say "unlimted nodes/branches ", what do you expect to be a practical upper bound on the number you might have? That can alter the best structure to use in the DB; i.e. some have a bit longer path, but load very fast. Others have a more compact linkage structure, but load more slowly. The choice is based on the max number of entries that need to be handled.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
KBSLPDevAuthor Commented:
The menu treeview that I have will only be 3 or so branches. However, in the project, it could be as deep as 10 (give or take a few)
0
 
JimBrandleyCommented:
I'll put something together you can experiment with...
0
 
JimBrandleyCommented:
Actually, there's a good discussion of that here:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Star_OpenOffice/Star_OpenOffice_Database/Q_22674542.html

along with several different options.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now