Search Query Problem in asp.net

Question

0.00/5 (No votes)

See more:

Hi All,

I am facing problem to write search query in sqlserver for search engine.
I have a textbox and button.
I want to search any word on button click through sqlserver query.But this query gives only matching word.
For Example when I enter tata it gives the result but when we enter tata123 it gives no output.

My Sqlserver query is:
"
SQL

select distinct top 20 s.title,s.Short_Description,s.primary_keyword,p.cat_id,s.art_id from tbl_summary s inner join tbl_publishinfo as p on p.art_id =s.art_id where s.art_id in(select pi.art_id from tbl_publishinfo pi group by pi.art_id having(count(pi.art_id)=1)) and s.title like'%" & txttext & "%' order by s.art_id desc"

Posted 27-Feb-12 17:19pm

Narendrakumar Arya

Updated 27-Feb-12 18:24pm

CRDave1988

Add a Solution

4 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ankit Kumar Gupta · Answer 1 · 2012-02-27T17:35:00

Solution 1

Hi,
What you are looking for can be done easily using full text catalog.
This searches for part or complete string on multiple fields.

Have a look on the following links.

Description of Full Text
http://msdn.microsoft.com/en-us/library/ms142571.aspx[^]

How to Use:
http://msdn.microsoft.com/en-us/library/ms142583.aspx[^]

Posted 27-Feb-12 17:35pm

Ankit Kumar Gupta

Comments

Tech Code Freak 28-Feb-12 5:33am

5up!

uspatel · Answer 2 · 2012-02-27T18:20:00

Solution 2

Use
SQL Wildcards

Posted 27-Feb-12 18:20pm

uspatel

Ravi chandran from thanjavur · Answer 3 · 2012-02-27T21:03:00

Solution 3

VB

for example

dim str as string
str= select * from tablename where column name='"&textboxName&"'

try it

Posted 27-Feb-12 21:03pm

Ravi chandran from thanjavur

Mantu Singh · Answer 4 · 2012-02-27T21:11:00

Solution 4

You need to enable full text search on the target Sql Server success depends on you table design too then create a full text catalog then you can search the way you want to.

Do some Google search or try links given by Mr Ankit

Best of luck

Posted 27-Feb-12 21:11pm

Mantu Singh

Search Query Problem in asp.net

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Search Query Problem in asp.net

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us