combobox with spaces in VS 2008

Question

0.00/5 (No votes)

See more:

I have a couple of questions in regards to designing a combobox in Visualstudio 2008(C#) 1)I have a combobox(Firstname+Lastname) datasource-SQL table. On the dropdown of the combobox, the formating looks fine, but when the name is selected,I see that the names with the trailing spaces in between them.Is there a way I can trim these and set it to work like a dropdown list. 2) I would like to have the first value in the combobox as spaces or someother text.I tried adding values in the ListItem Collection editor.but this seemed to work only in a dropbox and not in the combobox. Thanks in advance for your help.

Posted 28-Mar-12 10:31am

Sonycj

Add a Solution

1 solution

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)

milenalukic · Accepted Answer · 2012-03-29T02:53:00

Solution 1

Hi,

If you want to retrieve your data from SQL into a combo box you will need to format this in your query.

For example:

select Rtrim(ltrim(firstname))+' ' +Rtrim(ltrim(surname)) as name from customers

Then you will bind name to your combo box

Posted 29-Mar-12 2:53am

milenalukic

Comments

Sonycj 29-Mar-12 10:23am

Thankyou very much, for explaining so very well.As for the 2nd question, the ListItem Collection editor did work after all.