This is a migrated thread and some comments may be shown as answers.

retieving hierarchy from database and binding to radMenu

0 Answers 44 Views
Menu
This is a migrated thread and some comments may be shown as answers.
Will
Top achievements
Rank 1
Will asked on 20 Aug 2013, 11:50 PM
Hi there. I'm pretty new to both asp.net and sql so this might be a common question. I have a microsoft sql 2008 R2 server with a certain database which has many branching sub-directories. All of which end with different folders with data tables in them. I was wondering how I could bind this hierarchy to a data source (I'm using sqlDataAdapter) and attach it to the radMenu so that it would neatly re-produce this hierarchy. It looks like there are a few ways to go about it. Mostly I'm uncertain of how to query the database to get a folder with children (and sub-children) and how it's organized as a table, set, etc. I only really know the basic SELECT*. UPDATE, DELETE commands.

From what I've read, the radMenu binding uses a parentID, childID system. How does that work exactly? Does my hierarchy or it's tables have to be organized a certain way?


So I guess that's more than one question, but any help is appreciated!

thanks

Will

No answers yet. Maybe you can help?

Tags
Menu
Asked by
Will
Top achievements
Rank 1
Share this question
or