Utilize Full-text Indexing in VB.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a windows form where I would like the user to be able to search
through a few various columns in a database. I have a SQL 2000 database with
full-text indexing set up on the columns I would like searched. How do I
utilize full-text indexing in my windows form using VS.NET 2003? I have
searched for an article but none actually answer this question that I have
found. Any help would be greatly appreciated.
 
You don't need to do anything differently from your client code.
Create your SqlCommand or SqlDataAdapter objects using CONTAINS or
FREETEXT SQL syntax for the queries is all. If the db has been FT
enabled, it should just work.

--Mary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LIKE, CONTAINS and Full Text Indexing 5
How to create and schedule full-text catalogue programatically 2
Button & Labels text Anti-aliasing Problem using Windows Forms C# 0
Outlook Windows Search Service is turned off in Elevated mode 4
WDS and full-text index 1
Index with partial text 1
Windows 10 How to sort an index created in Word 2013 0
Index/match across multiple columns? 19

Back
Top