how to pass multiple values in where clause (C#,sql)

Question

0.00/5 (No votes)

See more:

please help me friends...........

in window form i have 2 different-2 criteria to filter data for THERE i haveTWO cheakesdlistbox(1st for partyname and 2ND one for itemname) each contain number of items let if user select(by cheeking cheak box) 10 party name now he SELCT ithemname may he select all item or sum now as he press show button data should be fill in datagridview with the above selection ..CRITERIA.......now i want to pass these selected values in whare clause ..like..whrere partyanme="all value from partyname" and exchangetype="all selected exhange type"and itemname="selected itemname"....
please help me how to write selct query with multiple selected values....

IT IS ALSO possible ... USER NOT SELECT ANY ITEM BUT SELECT ALL PARTY

C#.sqlserver

thanks in advanced

Posted 2-Jan-12 2:07am

Lakhan Aanjana

Add a Solution

4 solutions

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)

Prasad_Kulkarni · Accepted Answer · 2012-01-02T02:12:00

See here's example of passing multiple values in a WHERE clause check it out..it surely useful as i have used in my project

SQL

CREATE PROCEDURE [dbo].[Get_Activity]
(

@i_Head_id varchar(10),
@i_Level_id varchar(10)
)as
SELECT     Unit_of_Material_Master.s_Unit_of_material, Activity_Master.s_Description, Activity_Master.i_Unit_of_material_id, Activity_Master.i_Head_id, 
                      Activity_Master.i_Level_id
FROM         Activity_Master LEFT OUTER JOIN
                      Unit_of_Material_Master ON Activity_Master.i_Unit_of_material_id = Unit_of_Material_Master.i_Unit_of_material_id
where  i_Head_id=@i_Head_id and i_Level_id=@i_Level_id

suhas tavadare · Accepted Answer · 2012-01-02T02:19:00

Solution 2

Separate the criteria with 'AND' or 'OR' after 'WHERE' clause.

Posted 2-Jan-12 2:19am

suhas tavadare

devbtl · Accepted Answer · 2012-01-02T02:20:00

Solution 3

you can code like

C#

string sql;
"select * from table where"+sql

if(item.checked==true)
{
sql=your condition;
}
else if(item1.cheked==true)
{
sql=your condition;
}

Posted 2-Jan-12 2:20am

devbtl

Updated 2-Jan-12 3:09am

v3

Wendelius · Accepted Answer · 2012-01-02T08:14:00

Also if you have several values for the same field creating OR chains is sometimes troublesome. In these kind of cases you can use IN operator to simplify the query. For example if you have field No and you want to select rows having No 1 or 3 or 7 then you can write:

SQL

WHERE tableAlias.No IN (1,3,7)

Also in real life situation always remember to use SqlParameter[^] to define the values for a query.

how to pass multiple values in where clause (C#,sql)

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0