Search query in sqlserver using csharp

Question

0.00/5 (No votes)

See more:

Hi all,

In a table there is a keyword column whose values is “school”. When I write “school” in textbox and search all columns related to this record are shown in gridview.But when I write “the school” it donot show any record

str = "select id from school  where keyword like '%" + TextBox1.Text + "%'";

What will be the query?

Thanks

Posted 10-Jan-12 7:56am

3796068

Updated 10-Jan-12 7:59am

Not Active

v2

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)

fjdiewornncalwe · Answer 1 · 2012-01-10T08:08:00

Solution 1

Is there a record with a keyword of "the school"? If not, then that is your answer as to why there is no result.

Posted 10-Jan-12 8:08am

fjdiewornncalwe

Comments

3796068 10-Jan-12 14:17pm

I have no record "the school" but i have "school" record.So my question is in "the school" school keyword is present so how to search it?

Tushar22Patel · Answer 2 · 2012-01-10T09:04:00

Solution 2

Hi,

Your query is right. there is no problem at all. result may not be come because of trimming of the textbox value.

please also check your commandstring in debug mode, what exactly your query look like.

It should be

SQL

select id from school  where keyword like '%school%'

Posted 10-Jan-12 9:04am

Tushar22Patel

Updated 10-Jan-12 20:13pm

v2

Wendelius · Answer 3 · 2012-01-10T09:16:00

If I understood your question correctly, you've misunderstood the like keyword. It searches a portion of a string from a larger string. For example for sentence:

The school is over

finding %school% would match, but if the text is

School

then searching for %The school% won't match since it doesn't appear in the text

Gordon Beeming · Answer 4 · 2012-01-10T09:45:00

just as a tip don't use the code below unless you want you database to be destroyed from SQL Injection.

SQL

str = "select id from school  where keyword like '%" + TextBox1.Text + "%'";

this code will look in the keywords where the keyword contains "the school". If you want a solution that will find "school" in the keywords look into Full Text Index which would find "school" when you type "the school"

Search query in sqlserver using csharp

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0