How to pass multiple value from code behind to sql server

Jagatpal Singh

13y2.6k.NET

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Shekhar13y ago
Accepted 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 Shekhar13y ago
Dear Jagatpal,

Please mark it as answer. If you r happy with the given code.
Jagatpal Singh13y ago
Thankx....it's working
Ravikumar G13y ago
"select Company,Address from tablename where branch in ('"+branchnames+"')" Where branchnames is a string variable containing branch names separated by commas.
Jagatpal Singh13y ago
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 Rawat13y ago
SELECT ProfileID
FROM Profiles
WHERE (StateID IN
(SELECT StateID
FROM State
WHERE (Name = 'Uttarakhand') OR
(Name = 'UttarPardesh')))
Ravikumar G13y ago
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+")