how to bind dropdownlist

Question

4.00/5 (1 vote)

See more:

, +

Hi friends,

I have a doubt how to bind drop down list. i have a table.

Id	Category Name	Main Category Id	Weight
1	Curriculum	0	0
2	Science	1	1
3	Non-Curriculum	0	0
4	Physics	2	2
5	Acting	3	1
6	Concave Lense	4	3

In this table the main category is denotes the subcategory which will come under that category the weight denotes that sub category level.

for the above table i want to bind drop down like this format

Curriculum

-Science

--Physics

---Concave Lense

Non-Curriculum

-Acting

Can any one know the solutions please help me. u often see this is in article posting sites. if any one have the idea tell me,

Thanks,

Posted 13-May-11 22:35pm

sathya.spidy

Add a Solution

Comments

yesotaso 14-May-11 5:34am

Take a look at "http://en.wikipedia.org/wiki/Closed_world_assumption". If combobox does not know what you give is a tree, that tree does not exist for it. You would need to teach (simply code it in the way you want to see) it or it will interpret data the way it knows - a simple list of unordered strings.

Wonde Tadesse 14-May-11 13:58pm

Can you elaborate your main category,sub category and sub-sub category( if any) ? It's not clear how you normalize your table.Curriculum and Non-Curriculum have the same main category id. How ?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*ZeeroC00l* · Answer 1 · 2011-05-13T23:11:00

Solution 2

Follow the below steps :

* Extract the Information you want to bind the DropDowlList with, by making use of SqlConnection SqlDataAdapter and DataSet.

* Use the following steps to bing the Data to the DropDownList

C#

DropDownList1.DataSource = dataSetName
DropDownList1.DataTextField = "FieldName";
DropDownList1.DataValueField = "FieldName";
DropDownList1.DataBind();

If you want to set a default value to the DropDownList from the Bind values you can use the DropDownList1.SelectedValue property.

BR//
Harsha

Posted 13-May-11 23:11pm

ZeeroC00l

Updated 13-May-11 23:12pm

v2

Comments

Mahendra.p25 14-May-11 5:12am

he needs Data in this

Curriculum
-Science
--Physics
---Concave Lense
Non-Curriculum
-Acting
Format

ZeeroC00l 14-May-11 5:17am

Yes. I have seen that.. That is why I havent mentioned any code as to how you can get the detail in that format. I just mentioned how to link the obtained data to DropDownList. I am trying to get the details in the format.

sathya.spidy 14-May-11 5:30am

i know the binding code. but i need in that format.

sathya.spidy 14-May-11 5:30am

ya you are correct. i need the output in that format.

ZeeroC00l 14-May-11 5:44am

I don't Have sql installed, so I can give you an idea as to how you can do this.
Looking at the Table you mentioned, you want as many - as the number of weight of the course.
Use RIGHT / LEFT operator to get the number of - 's as in the weight column and then concatenate it with the category name field.

anvas kuttan · Answer 2 · 2011-05-13T23:48:00

Solution 3

hi,

put an extra field in database as arrangeOrder and when you fetch data write to get orderBy arrangeOrder

Posted 13-May-11 23:48pm

anvas kuttan

Comments

sathya.spidy 14-May-11 5:50am

can you please explain in detail format. because my subcategory will extend to 'n' numbers.