SQL QUERY IN MULTIPLE LINE

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

i have a query such as

commandtext = "SELECT * FROM TABLENAME WHERE 1=1 and 1=1 and 1=1

i have two combobox and i want to filter data according to the value available in the combobox.

what i want is
if i choose combobox 1 then i want to the code to be

commandtext = SELECT * FROM TABLENAME WHERE 1=1 and columnvalue = combobox value and 1=1

i want to replace the conditions (and 1=1) during execution of program

please help me

Regards
Bunzitop

Posted 14-Mar-13 3:49am

bunzitop

Add a Solution

Comments

[no name] 14-Mar-13 9:55am

Based on the very vague description of your problem, I would suggest a redesign of your code to avoid this situation.

1 solution

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)

Richard C Bishop · Answer 1 · 2013-03-14T03:55:00

Solution 1

So do this:

commandtext = "Select * From TableName Where columnvalue = '" + combobox.value + "'";

Posted 14-Mar-13 3:55am

Richard C Bishop

Comments

bunzitop 14-Mar-13 10:02am

i am currently using the code you suggested as
commandtext = "Select * From TableName Where columnvalue = '" + combobox.value + "'";

but my requirement is to filter the database according to the value of combobox.
if i have 4 combobox then it will have 16 possibilites to filter the database

but if i wrote the original code as
commandstring = "SELECT * FROM TABLENAME WHERE 1=1 and 1="

replaced the value "and 1=1 " with "and value = '"+combobox.value+"' "
then i will be more dynamic
sp i dont have to check each combobox if it is blank or not..

Richard C Bishop 14-Mar-13 10:05am

You will have to check each combobox or else you won't know how many filters to use. You might want to use case statements if you have a lot of potential combinations.

bunzitop 14-Mar-13 10:10am

i want to check as


if(combobox1.text!="")
{
     here i want to replace and 1=1
}
if(combobox2.text!="")
{
   here also i want to replace second 1=1 with "and value= '"+combobox.value+"'
}

simiilarly for others
finally '
my command will be
SE:ECT * FROM TABLENAME WHERE 1=1 +(and followed by ONLY the selected values of select combobox )

bunzitop 14-Mar-13 10:12am

can u tell me how to append condition in existing sqlcommand