 |  |  |  |  |  |  |  |
Searching multiple MS SQL Tables
Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved |
I would be grateful if anyone could let me know of an easy way of searching multiple tables for information.
I would like to display any found results in a grid alowing the user to choose the correct one and have this disply in the main form.
If this easy to do? I know it will need joins etc., but these are new to me.
Thanking you in advance.
I would like to display any found results in a grid alowing the user to choose the correct one and have this disply in the main form.
If this easy to do? I know it will need joins etc., but these are new to me.
Thanking you in advance.
•
•
Join Date: Aug 2005
Posts: 5,264
Reputation: 
Solved Threads: 377
If you are looking to pull out just one value (field) then this is simple enough. But databases are not like that, they're linked to different tables. How they are linked will depend on how easy it is to get the correct data out.
*Voted best profile in the world*
The tables are one table linked to three or four others (each of these are not link to each other)
Does this help?
Does this help?
•
•
Join Date: Aug 2005
Posts: 5,264
Reputation:
Solved Threads: 377
Is it possible to show us a schematic of your tables, how they are linked and what are the primary keys etc.
*Voted best profile in the world*
•
•
Join Date: Aug 2005
Posts: 5,264
Reputation:
Solved Threads: 377
I can barely read that text can you post a picture where all the text is big and clear to read. Thanks.
*Voted best profile in the world*
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
what u actually want..? Search all the fields of all the tables for any one Specific condition...?
-Vee
what u actually want..? Search all the fields of all the tables for any one Specific condition...?
-Vee
 |
Similar Threads
- php drop down menu to search multiple sql tables (PHP)
- Problem searching multiple sheets in excel (Visual Basic 4 / 5 / 6)
- SQL Tables export (VB.NET)
Other Threads in the VB.NET Forum
- Previous Thread: simple paint similar to MS Paint.. I have qustions!
- Next Thread: Drill Down
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
.net .net2008 2008 access account advanced application array basic beginner browser button buttons center click code combo cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic excel exists fade filter forms generatetags gridview html images input insert intel internet listview map mobile module monitor msaccess net number objects open panel passingparameters pdf picturebox picturebox2 port position print printing problem regex right-to-left save search searchvb.net select serial settings shutdown socket sqldatbase sqlserver survey table temperature textbox timer timespan transparency txttoxmlconverter update user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year
