Searching a SQL Server Database using a full text search
Posted on 2005-04-22
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!