Bind DropDownList with Hierarchy from MSSQL Table with ASP.NET C#
- by Gal V
Hello all,
I have the following sql table which contains menu (website menu) data.
Table Name: MenuItems
Columns: Id, MenuId, ParentMenuItemId, Text.
My goal is to bind a DDL according to the following hierarchy (example):
Id: 1, MenuId: 1, ParentMenuItemId: -1, Text: 'One'
Id: 2, MenuId: 1, ParentMenuItemId: 1, Text: 'Two'
Id: 3, MenuId: 1, ParentMenuItemId: 1, Text: 'Three'
Id: 4, MenuId: 1, ParentMenuItemId: 2, Text: 'Four'
Id: 5, MenuId: 1, ParentMenuItemId: 4, Text: 'Five'
Requested result in DDL:
One
-- Two
---- Four
------ Five
-- Three
I think it should contain 'WITH' SQL command.
Thanks all!