c# send paramether for sql in -

c# send paramether for sql in -

this question has reply here:

sql server - in clause declared variable [duplicate] 8 answers

how can send parameter in function. when add together "aa3,b4,gf2". coming null. table has aa3 , b4.

commandx.storedprocedure = "get_test"; commandx.addparameter("@names", "aa3,b4,gf2"); alter procedure [dbo].[get_test] @names varchar(15) select id,name tbl_test atm_kodu in (@names) homecoming @@rowcount

you need set quotes on parameters in clause, see example:

commandx.storedprocedure = "get_test"; commandx.addparameter("@names", "'aa3','b4','gf2'"); alter procedure [dbo].[get_test] @names varchar(15) select id,name tbl_test atm_kodu in (@names) homecoming @@rowcount

c# sql parameters