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 Company,Address 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 ename,lastname from emp where deptname in ("+stringvariablename+")