I want to add select value in combobox at runtime

Question

1.00/5 (1 vote)

See more:

hi

i want to add when we run application then value is reterieve from database and show in combobox ok , but i want to add combo box index 0 = select by default at run time

i think it depend upon query like :

select 'select', state from demotable

so above query is not working so give me any solution

Posted 26-Aug-13 23:55pm

pravin from aurangabad

Add a Solution

Comments

Mohan Gopi 27-Aug-13 6:03am

After finish your adding the combobox values finally give the below line

Combobox1.Items.Insert(0, "----Select----");

I hope this will help you, let me know.

pravin from aurangabad 27-Aug-13 7:27am

thanx

but i want to place "select" in query not in combobox item collection

Mohan Gopi 27-Aug-13 8:08am

you can try this

Select State from demoTable
Union
Select 'Select' AS 'State'

pravin from aurangabad 27-Aug-13 8:15am

yes i try this but the select text appears at bottom combobox list .not in top

Mohan Gopi 27-Aug-13 8:16am

try this
Select 'Select' AS 'State'
Union
Select State from demoTable

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)

Mohan Gopi · Answer 1 · 2013-08-27T02:15:00

Solution 1

Hi Pravin, try this

SQL

Select 'Select' AS 'State'
Union
Select State from demoTable

I hope this will help you.

Posted 27-Aug-13 2:15am

Mohan Gopi

Updated 27-Aug-13 2:17am

v2