Dropdownlist selected value is getting changed automatically

Question

0.00/5 (No votes)

See more:

I have a drop-down list, if I am selecting one value it is getting changed to another (only in some cases), what I have observed is DataValueField value is same for both but DataTextField value is different.
dtCurrency has two columns - shortcode and Long Name.

ddlCurrency.DataSource = dtCurrency;
        ddlCurrency.DataTextField = "shortcode";
        ddlCurrency.DataValueField = "Long Name";
        ddlCurrency.DataBind();
        ddlCurrency.Items.Insert(0, "Currency");

Example:
I m selecting TRY it is changing to TRL automatically,
same for BGN to BGL is changing.

dtCurrency:

shortcode	Long Name
BGL	Bulgarian Lev
BGN	Bulgarian Lev
TRL	Turkish Lira
TRY	Turkish Lira
INR     Indian Rupees
USD     US Dollors

What I have tried:

This is happening only when DataValueField is same. how to resolve this.

Posted 8-Apr-19 21:33pm

Virendra S from Bangalore, Karnataka

Updated 9-Apr-19 10:01am

Add a Solution

Comments

CHill60 9-Apr-19 3:44am

Try putting "(Old)" at the end of the Long Name for BGL and TRL?

F-ES Sitecore 9-Apr-19 7:26am

You're using "Long Name" as the value so when you select BGL the value (ID) used is Bulgarian Lev, so if that is the ID how does it know you mean BGL and not BGN? IDs need to be unique, yours are not. You need to do something to make your ID (Long Name) unique. Are you sure you don't actually want shortcode as the value and Long Name as the text?

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)

Rohan Dhamecha · Answer 1 · 2019-04-09T00:10:00

Solution 1

For Dropdownlist, there should be distinct values for the data value field. Still, the option can be used for the current situation is:

Give shortCode for both field, text and value and based on selected index data can be fetched out from the data table.

Posted 9-Apr-19 0:10am

Rohan Dhamecha

Vincent Maverick Durano · Answer 2 · 2019-04-09T10:01:00

Quote:
This is happening only when DataValueField is same. how to resolve this.

That's a normal behavior of the DropDownList.

As others have mentioned, the DataValueField for your DropDownList must be unique so that the selection won't messed up. To fix that, use the shortcode field as the DataValueField. For example:

C#

ddlCurrency.DataSource = dtCurrency;
ddlCurrency.DataTextField = "shortcode";
ddlCurrency.DataValueField = "shortcode";
ddlCurrency.DataBind();
ddlCurrency.Items.Insert(0, "Currency");

Now if you really want to display the Long Name field in the page then you can combine both fields and display it as one. That really depends on you. Again, the basic idea here is to make that your DataValueField values must be unique and doesn't have duplicate values.