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
 
Back
Top