?
Solved

Searching a SQL Server Database using a full text search

Posted on 2005-04-22
2
Medium Priority
?
146 Views
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!

Adam
0
Comment
Question by:apoell
  • 2
2 Comments
 
LVL 16

Expert Comment

by:RobertRFreeman
ID: 13847175
You can bind directly to a Dataview.
0
 
LVL 16

Accepted Solution

by:
RobertRFreeman earned 200 total points
ID: 13847178
listbox1.datasource = myDataview
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

579 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