Bind DropDownList with Hierarchy from MSSQL Table with ASP.NET C#

Posted by Gal V on Stack Overflow See other posts from Stack Overflow or by Gal V
Published on 2010-04-27T13:11:58Z Indexed on 2010/04/27 13:13 UTC
Read the original article Hit count: 843

Filed under:

binding

|

dropdownlist

|

hierarchy

|

sql

|

ASP.NET

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!

© Stack Overflow or respective owner

Related posts about binding

WPF Binding Error reported when Binding appears to work fine

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to create a custom TabItem template/style in my WPF 4.0 application (using VS 2010 Pro RTM), but inspite of everything seeming to work correctly, I am noticing a binding error in the trace window. The resource dictionary XAML I use to style the TabItems of a TabControl is given in full… >>> More
wpf binding by selected value - swap out bound object without disturbing binding

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I've got combo box bound to a custom collection type - its basically an overridden ObservableCollection which I've added a facility to update the underlying collection (via Unity). I don't want to confuse the issue too much, but thats the background. My xaml looks like this <ComboBox ItemsSource="{Binding… >>> More
Custom Binding Part 2: creating a Basic REST service using CUSTOM Binding

as seen on C# Corner - Search for 'C# Corner'
In this article, I am going to show you how we could create a basic WCF REST service using custom binding. >>> More
OneWay binding throws "TwoWay binding is invalid on Read only property"

as seen on Stack Overflow - Search for 'Stack Overflow'
This binding <tk:DataGridTextColumn Binding="{Binding Path=Id, Mode=OneWay}" Header="Sale No." Width="1*" /> Gives this error A TwoWay or OneWayToSource binding cannot work on the read-only property 'Id' of type . . . The "Id" property is indeed readonly, I thought though that… >>> More
Flex Error: Repeater is not executing.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello Everyone, I have been trying to get a Repeater to work since yesterday. It works the first time it has been loaded with data but the second time, it is loaded, the following error results with the debugger higlighting a row with the statement isHandlingEvent = false; in the watcherFired method… >>> More

Related posts about dropdownlist

Difference between DropDownList.SelectedItem.Value And DropDownList.SelectedValue (ASP.NET)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I'm getting an error when SelctedIndexChanged, When the value change he gives me the previous selected value and not the new selected value. What's the problem here. And what's the difference between DropDownList.SelectedItem.Value DropDownList.SelectedValue >>> More
A multiple selection DropDownList (a CheckBoxList inside a DropDownList)

as seen on Code Project - Search for 'Code Project'
Check and mark more than one option in a DropDownList. >>> More
Using DropDownList in EditTemplates of a GridView

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a GridView in Asp.Net. When initially a the Page Loads, my gridview look like: When a user clicks, to edit a row, I am using edit templates to show 'Domain' in a DropDownList. But problem is , when the DropDownlist gets load with data, it lost the current value of the 'Domain'. i… >>> More
toggle dropdownlist visibility

as seen on Stack Overflow - Search for 'Stack Overflow'
i have a dropdownlist in aspx (vb.net) that i have 2 dropdownlists. i want to show the second dropdownlist based on the value of first one. they are data wise interconnected, so if after selecting a certain record in first, if the second one has more than one record, the dropdownlist should be visible… >>> More
How to eliminate one of my extra DropDownLists in C#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm developing a C#/SQL web app in VS 2008 but for some reason I have one extra DropDownList. The very first dropdownlist displaying is empty. Can you help me identify the cause of this behavior? I'm baffled! An excerpt of my code is below. private DropDownList[] newcol; // Add DropDownList… >>> More