SqlParameter

M

Ming Ma

Hi,
I want to use SqlParameter and SqlDataReader to get records somthing like
this:
Select * from Issues
where ProjectID in (3, 4, 17, 55)

It is very easy to program in single SqlParameter value situation.
I can use something like this:
Select * from Issues
where ProjectID = @ProjectID
Then I create SqlParameter object and just set ProjectID parameter value.

How do I program mutilple parameter values situation? say my ProjectId could
be 3 or 7 or ....


TIA

Ming
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

varchar(max) - SqlParameter 2
SqlParameter for IN-Clausel (int values)? 3
Update query not updating 2
how do i bind data to a label? 1
sqlParameter and NULL 3
Output SqlParameter Returns NULL Value When Procedure Assigns a Va 6
Year prefix on primary key autonumber, but restart with '1' yearly 13
Dynamically Populating a SqlParameter object 5

Top