How to pass multiple value from code behind to sql server

Question

How to pass multiple value from code behind to sql server (IN Operator)

Ravi Shekhar · Answer

Hi Jagatpal string branchnames= Branch001 Branch002 Branch003 ; select * from table where branch in ('+branchnames+') It gives a proper result which u want. please mark it as answer . If you happy with above answer. Regards\ Ravi

Ravi Shekhar · Answer

Dear Jagatpal Please mark it as answer. If you r happy with the given code.

Jagatpal Singh · Answer

Thankx....it's working

Ravikumar G · Answer

select CompanyAddress from tablename where branch in ('+branchnames+') Where branchnames is a string variable containing branch names separated by commas.

Jagatpal Singh · Answer

Hi i want to pass multiple value to single patrameter i.e. I have 3 values in my .cs page. I want to fetch data against these values from SQL Table using IN Operator ------Code Behind (.cs)------ Branch001 Branch002 Branch003 -----SQL Server (Store Procedure)----- Declare @Branch nvarchar(max) Select Company Address Where Branch in (@Branch) ----How to pass 3 values to sql server using IN Operator

Pankaj Rawat · Answer

SELECT ProfileID FROM Profiles WHERE (StateID IN (SELECT StateID FROM State WHERE (Name = 'Uttarakhand') OR (Name = 'UttarPardesh')))

Ravikumar G · Answer

Can u plz give code if not then pass string consisting of values seperated by commas. Ex: select enamelastname from emp where deptname in (+stringvariablename+)