.net - Is it possible to use the sql IN clause in a SqlDataSource ?

Question

For a selectcommand in a sqldatasource is there any way to have the following:

select col1, col2
from mytable
where col1 IN (@inClause)

@inClause would be an array of integer, for example.

I don't think this is even possible in T-SQL, so my assumption is that it is not possible, but just wondering if there's a way to do it?

Answer 1

Duplicate of: http://stackoverflow.com/questions/337704/parameterizing-a-sql-in-clause

It's basically not possible to do that directly. There are workarounds, though.