locked
Need help to make tree view manually RRS feed

  • Question

  • Hi All,
    I have one table tbl_content with `content_id`, `title`, `content`, `menu_id`, `order`, `modified_date` columns and another table tbl_menu with `menu_id`, `menutype`, `name`, `parentid`, `sublevel`, `order`, `modified_date`. Here content_id and menu_id are primary key for both table.
    [NB. menu has three lebel like main menu, sub menu and child menu].
    Now i want to make the tree view like below:

    Main menu1
    --- Content [content may be here]
    -- Sub menu
    ----- Content [content may be here]
    --- Child menu
    ------Content [content may be here]

    Main menu2
    --- Content [content may be here]
    -- Sub menu
    ----- Content [content may be here]
    --- Child menu
    ------Content [content may be here]


    Please give me some idea to make the tree view.

    --
    Thanx
    • Moved by Vipul Patel - CLR Tuesday, March 24, 2009 12:10 AM moving to a generic forum (Moved from Building Development and Diagnostic Tools for .Net to Where is the Forum For…?)
    Monday, March 23, 2009 12:16 PM

Answers

  •  

    Hello Somel,

     

    Thank you for your post!  I would suggest posting your question in the 'MSDN > Forums Home > SQL Server > SQL Server Tools General' located here:  http://social.msdn.microsoft.com/Forums/en-US/sqltools/threads/


    Have a great day!

    Thanks!

    SachinW Tier 2 Application Support Server and Tools Online Engineering Live Services Team
    • Proposed as answer by SachinW Tuesday, March 24, 2009 12:17 AM
    • Marked as answer by SachinW Wednesday, May 20, 2009 8:57 AM
    Tuesday, March 24, 2009 12:17 AM