using LIKE operator within visual basic and sql query builder

Question

0.00/5 (No votes)

See more:

Hi there, I have a visual basic windows form with a datagrid and a picturebox.
The datagrid is hooked up to a database that contains three fields :

SQL

Id int
Description varchar(100)
AbsPath varchar(200)

when the form loads the picturebox is filled with a photo image from AbsPath.
Nothing special about that in its self.

I have configured a query to search description like this:

SQL

SELECT        id, Description, AbsPath
    FROM            TablePhoto
    WHERE        (Description LIKE @Description + N'%')

The problem is the search only matches from the left of 'description"

So if I enter "white" for the search I get

white rose
white flower
etc

If I enter "flower" I get nothing

According to what I have read I should be able to use the LIKE wildcard %% so the search will match "flower" within the description so I should get:

white flower<br />
Blue flower<br />
etc

But what is the correct syntax to use, I have tried various combinations but the query builder dosnt seem to like it.

Thanks in advance for any help

Posted 11-Oct-11 21:36pm

It is what it is

Updated 11-Oct-11 22:44pm

P.Salini

v2

Add a Solution

2 solutions

Solution 3

select id, Description, AbsPath from TablePhotowhere Description LIKE '%' + @Description+'%'

try this

Regards,

Anilkumar.D

Posted 12-Oct-11 1:30am

Anil Honey 206

v2

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)

kishorekke · Accepted Answer · 2011-10-11T21:39:00

Solution 1

SQL

SELECT            id, Description, AbsPath
     FROM                  TablePhoto
     WHERE            (Description LIKE '%'+@Description+'%')

Posted 11-Oct-11 21:39pm

kishorekke

Updated 11-Oct-11 22:45pm

v2

Comments

hamed2011 21-Feb-15 3:42am

tnx a lot guys work like charm!!