Link to home
Start Free TrialLog in
Avatar of apoell
apoell

asked on

Searching a SQL Server Database using a full text search

I am working on a group project that requires me to create a form that will do a text search in a movie database.  We are supposed to search my movie title, director, and actor.  The results will display the movie title that matches the search.  Currently I am trying to use a dataview and use the RowFilter property of that dataview object.  The problem is that I am no too sure how I can extract the movie titles of each row in the filtered dataview to display in the listbox.  Is there any way I can do this, or should I use a different method to perform the search?  My only reference is my textbook, and it only provides the RowFilter and Parameterized Query options.  I don't want to use the Parameterized Query, because I will only get one result in the listbox.  Please help.  This project is giving me a headache!

Adam
Avatar of RobertRFreeman
RobertRFreeman
Flag of United States of America image

You can bind directly to a Dataview.
ASKER CERTIFIED SOLUTION
Avatar of RobertRFreeman
RobertRFreeman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial