Link to home
Start Free TrialLog in
Avatar of NCSO
NCSO

asked on

Search all SQL tables from a vb application

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?
ASKER CERTIFIED SOLUTION
Avatar of dodge20
dodge20

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
Avatar of NCSO
NCSO

ASKER

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?
Avatar of NCSO

ASKER

Many Thanks!!!!