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