Searching a SQL Server Database using a full text search

Posted on 2005-04-22
Last Modified: 2010-04-23
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!

Question by:apoell
    LVL 16

    Expert Comment

    You can bind directly to a Dataview.
    LVL 16

    Accepted Solution

    listbox1.datasource = myDataview

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Article by: Kraeven
    Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
    I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now