c# send paramether for sql in

Question

How can I send parameter for IN function. When I add "aa3,b4,gf2". Its always coming null. But my table has aa3 and b4.

  commandx.StoredProcedure = "GET_TEST";
  commandx.AddParameter("@names", "aa3,b4,gf2"); 



 ALTER PROCEDURE [dbo].[GET_TEST]
 @names varchar(15)
 AS

SELECT id,name FROM TBL_TEST where atm_kodu IN (@names)

RETURN @@ROWCOUNT

score 1 · Answer 1 · answered Jun 23 '14 at 13:03

You need to put the quotes on parameters for the IN clause, see example:

commandx.StoredProcedure = "GET_TEST";
  commandx.AddParameter("@names", "'aa3','b4','gf2'"); 



 ALTER PROCEDURE [dbo].[GET_TEST]
 @names varchar(15)
 AS

SELECT id,name FROM TBL_TEST where atm_kodu IN (@names)

RETURN @@ROWCOUNT

score 0 · Answer 2 · answered Jun 23 '14 at 13:08

It is because you need to have a quotes around names string. Like

commandx.AddParameter("@names", "'aa3','b4','gf2'");

If you have a string composed of your multiple values such as

commandx.AddParameter("@names", "aa3,b4,gf2");

Then You might need a function that will explode your string using a delimiter (split at comma or whatever character is splitting your string and put vales in single quotes)

c# send paramether for sql in

2 Answers2