i have a query for select many row of table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

i have a webform(this webform show search resault)
i have this query for show search resault about a text

SQL

SELECT [ProID], [ProName], [ProCompany], [ProPSale], [ProPic] FROM [Product] WHERE (([ProName] = @ProName) or([ProCompany] = @ProCompany))

this query return many field about product
about product that his name or company = text
i want return product that name or company is contain text(text for search)
a want a query with operator LIKE oR Contain value of @ProName And @ProCompany is in a QueryString

Posted 21-Jun-12 9:45am

sadegh_rusta

Updated 21-Jun-12 11:02am

Maciej Los

v2

Add a Solution

2 solutions

Solution 1

You would use:

SELECT [ProID], [ProName], [ProCompany], [ProPSale], [ProPic] FROM [Product] WHERE (([ProName] LIKE @ProName) or([ProCompany] LIKE @ProCompany))

And then you just have to make sure that when you set the parms @ProName and @ProCompany, that you put a % at the start and the end of the string that you set it to.

Posted 21-Jun-12 10:24am

Kschuler

Comments

Maciej Los 21-Jun-12 17:09pm

Bad example, good commment ;)
5!

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)

Sandeep Mewara · Accepted Answer · 2012-06-21T10:27:00

Solution 2

Use LIKE & wild card character '%'
Try:

SQL

SELECT 
  [ProID], 
  [ProName], 
  [ProCompany], 
  [ProPSale], 
  [ProPic] 
FROM 
  [Product] 
WHERE (([ProName] LIKE '%'+@ProName+'%') or([ProCompany] LIKE '%'+@ProCompany+'%'))

Refer:
MSDN: LIKE (Transact-SQL)[^]
MSDN: Percent character (Wildcard - Character(s) to Match) (Transact-SQL)[^]

Posted 21-Jun-12 10:27am

Sandeep Mewara

Comments

Maciej Los 21-Jun-12 17:07pm

Yes! +5!

Sandeep Mewara 21-Jun-12 23:16pm

Thanks Mac! :)