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

Hi Ahmed,

Try this way,

SqlCommand cmd=new SqlCommand("select * from studentdetails where id in ('"+textBox1.Text+"')",con);

thank you for reply

my secnario is textbox have values like that

1005,2008,9001,12011

so that how to select these ids

thank you for reply

if i need it as avariable

it will be like that

"select * from studentdetails where id in (@userID)"

OR that is wrong

Hi Ahmed,

You can pass the array to where condtion..

Try the below sample code

"select * from studentdetails where id in (1,2,3,4)"