What should be the select query for multiple values ?

Question

0.00/5 (No votes)

See more:

Hi,
I am designing a webpge using asp.net with sql server 2005
in back end there is table with followding columns
username,name,phone1,phone2,age and some others columns are there for storing user's details.

I would like to select in such a way so that i enter

more than one user name seperated with commas in textbox
in selection result i get all the phone numbers associated with that usernames.

For example

Usernames Name Phone1 Phone2
abc@yahoo.com Abhi 9334459287 9334459288
def@yahoo.com Sony 9935199351
efg@yahoo.com Tony 9835198351 9835198351

Select Phone1,Phone2 from tblregistration where usernames=abc@yahoo.com,def@yahoo.com,efg@yahoo.com

In result i like all the phone numbers
9334459287 9334459288
9935199351
9835198351 9835198351

Please help me.

Posted 25-Dec-14 16:25pm

Abhishek kumar121

Updated 25-Dec-14 18:05pm

v2

Add a Solution

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

Peter Leow · Answer 1 · 2014-12-25T18:02:00

Solution 1

Check this out: Parameterized IN clauses with ADO.NET and LINQ[^]

Posted 25-Dec-14 18:02pm

Peter Leow

DamithSL · Answer 2 · 2014-12-25T18:06:00

build sql statement with multiple usernames as where conditions.
for example if user input 3 usernames

SQL

select tp1, tp2 from table1 where username =@username1 or username =@username2 or username = @username3

you may need to split user input and get each user name like below when you set parameter values
string input ="abc@yahoo.com,def@yahoo.com,efg@yahoo.com";
string[] usernames =input.Split(',');