retieving hierarchy from database and binding to radMenu

1 posts, 0 answers
  1. Will
    Will avatar
    6 posts
    Member since:
    Aug 2013

    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!

    thanks

    Will
Back to Top