change selectedIndex of combobox by read from DB

Question

3.00/5 (1 vote)

See more:

Hi all
i have a comboBox with 4 value:A,B,C,D
and i have table in DB.One of table fields is for record for "typeofUser" example A.
Type of field in DB is "Text".
Now:

SQL

select * from table where ID=txtID.text

to read form DB and put record details to controls in a form.
so i want to see value of "typeofUser" example A from DB in the comboBox.(ComboBox1.selectedIndex=0)
how can i do that?
Best regards

Posted 14-Feb-12 21:34pm

FM7

Add a Solution

Comments

Herman<T>.Instance 15-Feb-12 4:32am

what is your exact problem? connecting to the database? retrieving the data using a sqlcommand?

FM7 15-Feb-12 5:13am

NO.Both are ok.but reading text from one field of table and binding it to the combobox.
can you help?

FM7 15-Feb-12 5:10am

No answers!!?

Herman<T>.Instance 15-Feb-12 6:02am

You want to add a New ListItem() ? to the combobox

Jαved 15-Feb-12 6:10am

you want to show records of type (selected from combobox) in second combobox right?

3 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)

Herman<T>.Instance · Answer 1 · 2012-02-15T00:06:00

Solution 1

look here[^]

Posted 15-Feb-12 0:06am

Herman<T>.Instance

Jαved · Answer 2 · 2012-02-15T00:13:00

Solution 2

Hi,
On the "typeofUser" comboBox_SelectedIndex_Changed() event write the code to retrieve records, in your case -

select * from table where ID=txtID.text

and the bind to the control with DataSet.

Thanks,
Javed

Posted 15-Feb-12 0:13am

Jαved

BobJanova · Answer 3 · 2012-02-15T01:22:00

Solution 3

If you bind the data set returned by that query to the combo, and set the DataMember property to be the column which is A, B, C or D, then it should already do what you want.

Posted 15-Feb-12 1:22am

BobJanova