How To add String to Combobox Values

Question

0.00/5 (No votes)

See more:

VB

cmbPurNo.DataSource = dt;
cmbPurNo.ValueMember = "PSettingId";
cmbPurNo.DisplayMember = "value";

here values are

2
3
4

bt how to add value to like

GP2
DC3
TIN4

pls help me

Posted 17-Apr-13 20:15pm

Amarender1479

Updated 17-Apr-13 20:22pm

Maciej Los

v2

Add a Solution

Comments

OPees 18-Apr-13 2:18am

can you brief it more? what are in PSettingId?

Maciej Los 18-Apr-13 2:23am

Please, be more specific and provide more details.

Amarender1479 18-Apr-13 2:31am

i've combobox values as 2
3
4
bt how to add string to that values GP2
DC3
TIN4

Maciej Los 18-Apr-13 2:34am

See my answer, please...

Amarender1479 18-Apr-13 2:23am

here PsettingId is Table Id
where PsettingId is 1 Value is 2
3
4
bt how to add string to values in c#

3 solutions

Solution 1

Add the information to your collection dt

Posted 17-Apr-13 20:19pm

Mycroft Holmes

Solution 3

I would do this in the query. Concatenate the two columns you want to show together and then assign them as the datasource to the dropdown.

Posted 17-Apr-13 20:30pm

Abhinav S

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)

Maciej Los · Accepted Answer · 2013-04-17T20:26:00

Solution 2

Change your query:

SQL

SELECT PSettingId, [value] , [value] + CAST(PSettingId AS VARCHAR(30)) AS  DisplayName

Usage:

C#

cmbPurNo.DataSource = dt;
cmbPurNo.ValueMember = "PSettingId";
cmbPurNo.DisplayMember = "DisplayName";

Posted 17-Apr-13 20:26pm

Maciej Los

Comments

Amarender1479 18-Apr-13 2:54am

thanks

Maciej Los 18-Apr-13 2:57am

You're welcome ;)
Please, mark all useful answers as "solved" (green button). It would be nice to see how useful answer is (use voting system).