Databound Dropdown

Question

1.00/5 (2 votes)

See more:

Hi
I have databound dropdown list. I need to fill data in dropdown list from sql server table data. I have created databound dropdown control in gridview.

Posted 28-Dec-10 18:45pm

srinivasvempa

Updated 28-Dec-10 20:01pm

v3

Add a Solution

Comments

Venkatesh Mookkan 29-Dec-10 1:36am

You are doing a reverse of what your asking for!

thatraja 29-Dec-10 2:36am

Hi, May I know the reason for down-votes for answers for this question?

Andy_L_J 29-Dec-10 3:28am

You are downvoting everyone who tries to help you. This will get you a BAD rep on this site an NO-ONE will help you.

Hiren solanki 29-Dec-10 5:09am

You're changing your question once it's answered and thenafter downvoting everyone. This isn't good practice, are thinking of us as fool ? :mad:

3 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)

thatraja · Answer 1 · 2010-12-28T20:26:00

Solution 3

Just now answered for similar question, have this.

DropDownList Inside GridView[^]

Posted 28-Dec-10 20:26pm

thatraja

Andy_L_J · Answer 2 · 2010-12-28T19:42:00

Solution 1

I assume that this is in code-behind for a webpage?

Try something like...

box1.DataSource = dt;
box1.TextDataField = "Description"
box1.ValueDataField = "ItemCode"
box1.DataBind()

Posted 28-Dec-10 19:42pm

Andy_L_J

Hiren solanki · Answer 3 · 2010-12-28T19:43:00

So what is your problem over there ?

Looks just fine to me.

These is a tedious approach unless one wants custom solution.

Follow below for less coding

a) Fill DataTable using DataAdapter.
b) Assigin dropdownlist DataSource to that DataTable.
c) Set DataSource of Dropdown.
d) Set DataValue of <code>DropDown.

See THIS[^] for more.