SQLCommand with Optional Parameters?

[Hanover]

In at typical SQL command if I want an optional parameter, I say

"Where ID=@ID or @ID=Null"

This way if I dont pass in a parameter, it will just pull all of the
IDs.

Is there a way to set this up in the text command of a SQLCommand
object in .NET?

I've tried, but it keeps throwing an error that tells me that it
expects the parameter. I have three possible optional parameters..and
I'd hate to do a select for every single combination.

Thanks,
Dan

[rviray]

could you use...

if(DoesItNeedToBeNull())
{
parms[x] = DBNull.Value; //DBNull is off the System Object
}

I am assuming that you are assigning your params....this way...

If not, your second alternative is building the entire SQL statement
string like

string qInfo = "Select * From Tbl where "
if(sometest)
{
qInfo = qInfo + "blah = 'blahh'";
}
etc...
--
rviray
------------------------------------------------------------------------
rviray's Profile: http://www.msusenet.com/member.php?userid=4211
View this thread: http://www.msusenet.com/t-1871086699