请教SqlParameter参数问题

如一条sql语句
string x = "1,2,3";
select * from table where id in(@ids)

SqlParameter sqlParam = new SqlParameter("@ids", SqlDbType.NVarChar);  

始终出错,有解决方案吗？？

以上是伪代码，不要纠结语法问题

要不你用字符串拼接成sql，要不只能这样

C# code

int p1 = 1
int p2 = 2
int p3 = 3

select * from table where id in (@p1,@p2,@p3)
SqlParameter sqlParam1 = new SqlParameter("@p1", SqlDbType.Int);   
SqlParameter sqlParam2 = new SqlParameter("@p2", SqlDbType.Int); 
SqlParameter sqlParam3 = new SqlParameter("@p3", SqlDbType.Int); 
sqlParam1.Value = p1
sqlParam2.Value = p2
sqlParam3.Value = p3