Posted 20 Aug 2013
Link to this post
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!