how to parameterized query from combo box?

Question

0.00/5 (No votes)

See more:

Hi I have 2 combo-box :

1st combobox will show the teacher's name and the 2nd combo box will show all the subject that this particular teacher teach ,my problem is I don't know how to program it using ado.net (VB.NET) please help me in coding this scenario :)

Its for windows and please give me some sample code about it
thanks

Posted 19-Nov-11 4:47am

lyn10

Updated 19-Nov-11 6:11am

Sander Rossel

v2

Add a Solution

Comments

Uday P.Singh 19-Nov-11 10:51am

what are you trying to program?

Sander Rossel 19-Nov-11 12:12pm

Please, next time you want to add something use the "Improve question" button.
Don't make an answer that is an update to your question.

3 solutions

Solution 4

double click on combox on which you want to query .... and there write querty with with connection and in query write like -- WHERE field=" & ComboBox1.text & "....

try this u wil get the thing....

Posted 20-Nov-11 1:49am

RAHUL77758

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)

Not Active · Accepted Answer · 2011-11-19T05:38:00

Solution 2

The functionality you are looking for is called cascading dropdown

Using CascadingDropDown with a Database[^]

You didn't specify if this were Web or Windows but the technique is the same, just applied differently in each.

Posted 19-Nov-11 5:38am

Not Active

Comments

lyn10 19-Nov-11 12:18pm

hi do you have vb.net sample? you give me ajax?

[no name] 19-Nov-11 13:24pm

Try searching. There are many, many examples but as I said the technique is the same

Sander Rossel · Accepted Answer · 2011-11-19T05:21:00

Actually MSDN has quite some articles on ADO.NET which can tell you more than anyone here could fit it an answer.
So I suggest you start reading there and come back here if you get stuck on a subject or piece of code.
ADO.NET Overview[^]

Command Object, for executing queries:
IDbCommand (the base Interface for all DbCommand Objects)[^]
DbCommand (basic Implementation of IDbCommand)[^]
OleDbCommand (an Implementation of IDbCommand, Inherits from DbCommand)[^]
SqlCommand (Command to use when working with SQL)[^]

For parameterized queries:
Derivatives of IDbDataParameter[^]

Other Objects you will need:
Derivatives of IDbConnection[^]
Derivatives of IDataAdapter[^]

How to's:
Complete code samples[^]
Walkthough: Displaying hierarchical data in a TreeView (for example teacher - classes)[^]

Give a man a fish and he will eat for a day, teach him how to fish and he will eat for a lifetime (or something).
Good luck! :)