Search all SQL tables from a vb application

NCSO
NCSO used Ask the Experts™
on
I am working on a project that requires a search of all tables within a database against a keyword search on a form; thenreturn those results to a datagridview.  What is the best way to accomplish this search?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
I looked over the blog.  I have never developed against a stored procedure but no big deal there; however, the procedure does not get the data, it simply returns the field in which the data is contained.

Quote: We only list the table name and the column name where the value is stored, we do not return that data!

If my thoughts are correct, I could run the procedure from the application to determine the table and fields that contain the data and then develop the query "on-the-fly" based on the return.  Am I correct?

Author

Commented:
Many Thanks!!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial