SQL select statement with multiple conditions

Question

0.00/5 (No votes)

See more:

Hi,

i just need to write a select statement which satisfies 3 conditions.my table consist of 3 fields like userid,password and usertype.

i need to pass a select statement as command text in the front end which satisfies 3 conditions like

textbox1 value should be equal to userid field in the table.IIy
textbox2 value should be equal to password.
textbox3 value should be equal to usertype

i dont know how to pass multiple conditions in select statement like how to check userid=textbox1 value,password=textbox2 value and usertype =textbox3 value

~~can anyone plss help me..................~~

Posted 20-Mar-12 3:07am

amaljosep

Updated 20-Mar-12 3:09am

Rajesh Anuhya

v2

Add a Solution

Comments

Rajesh Anuhya 20-Mar-12 9:09am

Sounds like Homework..
--RA

2 solutions

Solution 2

Here[^] is a good example for you (select command with parameters) that should help you get started.

Posted 20-Mar-12 3:21am

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)

Wayne Gaylard · Accepted Answer · 2012-03-20T03:21:00

Solution 1

You can use the AND keyword in any sql statement with WHERE like this

C#

query = "SELECT userid, password, usertype FROM users WHERE userid = @userid AND password = @password AND usertype = @usertype";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@userid", textbox1.Text);
cmd.Parameters.AddWithValue("@password", textbox2.Text);
cmd.Parameters.AddWithValue("@usertype", textbox3.Text);

take note how I used a parameterised query instead of directly concatenating the text boxes values.

Posted 20-Mar-12 3:21am

Wayne Gaylard

Comments

Abhinav S 20-Mar-12 9:52am

My 5.

Wayne Gaylard 20-Mar-12 10:06am

Thanks Abhinav!

ProEnggSoft 20-Mar-12 11:56am

Succinct and to the point. +5

Wayne Gaylard 21-Mar-12 2:07am

Thanks!

matthewlink77 21-Mar-12 2:02am

good answer!

Wayne Gaylard 21-Mar-12 2:07am

Thanks!