 |  |  |  |  |  |  |  |
Searching multiple MS SQL Tables
Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
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: 376
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: 376
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: 376
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 .net2005 .net2008 30minutes 2005 2008 access account arithmetic array basic browser button buttons center check code component connectionstring crystalreport cuesent data database databasesearch datagrid datagridview date datetimepicker design dissertation dissertations dissertationthesis dissertationtopic dropdownlist excel fade file-dialog filter folder ftp generatetags hardcopy image images input insert intel monitor navigate net networking opacity output panel passingparameters peertopeervideostreaming picturebox picturebox1 port printing problem problemwithinstallation project reports" savedialog searchvb.net select settings shutdown string survey tcp temperature text textbox timer timespan toolbox transparency trim updown user usercontrol vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web winforms wpf year