Asp.net Drop Down List DataValuefield and datatextfields

Question

4.00/5 (2 votes)

See more:

I have a DropDownList Control in my page,

i am binding both DataValueField and DataTextFiled to it.

For example: Employee details,

Data value Field =1
Data Text Field ="ABCD"

i want the text in dropdownlist will show like this

"1-ABCD"

and also i want to select the Data Value Field from this dropdownlist

thats 1 in above example

How can i do this

Please help

Posted 15-Feb-11 19:57pm

kishore Rajendran

Updated 15-Feb-11 20:23pm

v2

Add a Solution

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)

Monjurul Habib · Answer 1 · 2011-02-15T20:01:00

Solution 1

Hope you will find the answer
Concatenate Two Fields to Display in Dropdown List

Posted 15-Feb-11 20:01pm

Monjurul Habib

Sandeep Mewara · Answer 2 · 2011-02-15T20:04:00

Solution 2

Either create a custom object or get the textfield value as '1 - ABCD' from query itself.

For now, it looks like you are a beginner, try the Query way. When fetching the data, concatenate the ID and Text field and then use this field as the datatextfield while binding.

Sample:

SQL

SELECT 
  ID, TextF, (ID + '-' + TextF) AS IDTEXTF
FROM
  MyTable

C#

mydropdown.Datasource = myFetchedDataTable;
mydropdown.DataValueField = "ID";
mydropdown.DataTextField = "IDTEXTF";
mydropdown.Databind();

Posted 15-Feb-11 20:04pm

Sandeep Mewara

Updated 15-Feb-11 20:07pm

v2

Comments

kapilonkar 4-Mar-13 1:53am

Can anyone Tell me if I do not want to pass DataTextField and DataValueField how can I bind DropDownList with datasource ?
At present I am getting bound Value as System.Data.DataRowView for all the Items.

Please Tell me If anyone knows the Solution.

Thanks in Advance.

Sandeep Mewara 4-Mar-13 2:03am

You have to define the datatextfield and datavaluefield to map the field/value.

Further, next time, please post your questions as a new question instead of a comment to any question previously asked by someone else.

kapilonkar 4-Mar-13 3:33am

Yes Sure,

Thanks for Information Sandeep.