How to add parameter for 'In' clause

[robert110]

My Sql statement looks like this:

SELECT * FROM TBL_MyTable WHERE ID in (1,5,9,10,5248)

I want to use parameterized SQL command, how can I add the parameter value to it? This is what I have so far:

cmd.CommandText = "SELECT * FROM TBL_MyTable WHERE ID in @ID"
cmd.Parameters.Add("@ID", SqlDbType.Int.Int).Vlaue = "(1,5,9,10,5248)";

but its not working, any suggestions? Thanks.

[ednrgc]

The problem is that "(1,5,9,10,5248)" is not of type SqlDbType.Int. You have a few options: 1. Build the CommandText string dynamically in the program. 2. Build the SQL statement in a Stored Proc, then run it via sp_executesql (NOT SAFE).