how to pass multiple selected value from dropdown in sql stored procedure

Question

1.22/5 (2 votes)

See more:

SQL-Server-2008R2

hii all

i am facing a problem with my project..

i want to selected multiple items from dropdown list and pass these multiple selected value in sql stored procedure in asp .net c#..

please give me idea to solve my problem..
yet i have no coding fro that.. i have no idea how to solve this problem

thanks to all..

Posted 14-Jul-14 20:43pm

bindash

Add a Solution

Comments

jo.him1988 15-Jul-14 2:48am

not sufficient for answer what you want,
if you want to pass all selected parameter in one time
take stringbulder and append selectd list item and pass it to sp
if you want to pass single item
than foreach loop to your selected list item and pass to sp

ArunRajendra 15-Jul-14 3:47am

Post code what you have done

Pheonyx 15-Jul-14 4:06am

What stored procedure? All you need to do is define your stored procedure to do what you want then pass the selected options back as parameters to the SQL command.

3 solutions

Solution 1

Concatenate all the values selected in the Dropdown using comma. Then pass this concatenated value to the parameter in the stored procedure. In the query assign this parameter as below

SQL

Select * from <table_name> Where <column_name> in (@parameter)</column_name></table_name>

Hope this helps

Posted 14-Jul-14 22:39pm

Dinesh.V.Kumar

Solution 3

Here is a great article to do what you are asking.

Multi-select-Dropdown-list-in-ASP-NET

Posted 15-Jul-14 10:16am

Yuriy Loginov

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bhanu Pratap Verma · Accepted Answer · 2014-07-15T01:58:00

Solution 2

SQL

declare @var varchar(200)=' ''rs001'',''am001'' '

Exec ('select * from Emp_Master where empcode IN (' + @var + ')')

Try This one , Hope it will help you!

Posted 15-Jul-14 1:58am

Bhanu Pratap Verma