Can I more select specific number from SQL query in C#

Question

1.00/5 (3 votes)

See more:

.NET4.6

I work in windows form application c# vs2015 integrated to sql server 2012
I face problem
i need to select more specific number in same time but i dont know
what query i write or what i do in c#
current i using select * from table where userID=@UserID
this is select only number
but if i need to select more specific number
suppose i have numbers from 1001 to 1020
i need to select 1005,1009,1012,1017
How to get result for more records from SQL query or c# in same time
any way i can accept

What I have tried:

can i more select specific number from sql query in c#

Posted 29-Mar-17 23:39pm

ahmed_sa

Updated 30-Mar-17 5:38am

Add a Solution

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)

Garth J Lancaster · Answer 1 · 2017-03-30T00:00:00

Solution 1

Have you tried the 'IN' SQL operator ?

SQL

select * from table
where userID=@UserID
and number in (1005, 1009, 1012, 1017)

Posted 30-Mar-17 0:00am

Garth J Lancaster

F-ES Sitecore · Answer 2 · 2017-03-30T00:02:00

Solution 2

In addition to IN, if it is a range you want to select then

WHERE userID >= 1001 AND userID <=1020

Posted 30-Mar-17 0:02am

F-ES Sitecore

Comments

ahmed_sa 30-Mar-17 6:55am

THANK YOU FOR REPLY
if i need it dynamically in textbox
my secnario as following
textbox have values 1002,1991,2007,3006
so that how to select these values

Richard Deeming · Answer 3 · 2017-03-30T05:38:00

Quote:
textbox have values 1002,1991,2007,3006
so that how to select these values

You'll need to split the text, convert each value to an integer, and build up a parameterized SQL command using the IN operator:

C#

string text = YourTextBox.Text;
string[] parts = text.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

string[] parameterNames = new string[parts.Length];
SqlParameter[] parameters = new SqlParameter[parts.Length];

for (int index = 0; index < parts.Length; index++)
{
    int value;
    if (!int.TryParse(parts[index], out value))
    {
        // TODO: Display an error to the user
        return;
    }
    
    string name = "@p" + index;
    parametersNames[index] = name;
    parameters[index] = new SqlParameter(name, SqlDbType.Int) { Value = value };
}

string sql = string.Format("SELECT * FROM table WHERE userID IN ({0})", string.Join(", ", parameterNames));

using (var connection = new SqlConnection("..."))
using (var command = new SqlCommand(sql, connection))
{
    command.Parameters.AddRange(parameters);
    ...
}