943,929 Members | Top Members by Rank

Software Development > VB.NET > Searching multiple MS SQL Tables
Ad:
  • VB.NET Discussion Thread
  • Marked Solved
  • Views: 4558
  • VB.NET RSS
You are currently viewing page 1 of this multi-page discussion thread
Permalink
Aug 5th, 2007
0

Searching multiple MS SQL Tables

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
TaoistTotty is offline Offline
46 posts
since Aug 2007
Permalink
Aug 5th, 2007
0

Re: Searching multiple MS SQL Tables

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.
Featured Poster
Reputation Points: 1536
Solved Threads: 431
Posting Expert
iamthwee is offline Offline
5,865 posts
since Aug 2005
Permalink
Aug 5th, 2007
0

Re: Searching multiple MS SQL Tables

The tables are one table linked to three or four others (each of these are not link to each other)

Does this help?
Reputation Points: 10
Solved Threads: 0
Light Poster
TaoistTotty is offline Offline
46 posts
since Aug 2007
Permalink
Aug 6th, 2007
0

Re: Searching multiple MS SQL Tables

Is it possible to show us a schematic of your tables, how they are linked and what are the primary keys etc.
Featured Poster
Reputation Points: 1536
Solved Threads: 431
Posting Expert
iamthwee is offline Offline
5,865 posts
since Aug 2005
Permalink
Aug 6th, 2007
0

Re: Searching multiple MS SQL Tables

Please find the information below, thanks for you help.
Attached Thumbnails
Click image for larger version Name: Diagram.jpg Views: 30 Size: 113.7 KB ID: 3868  
Reputation Points: 10
Solved Threads: 0
Light Poster
TaoistTotty is offline Offline
46 posts
since Aug 2007
Permalink
Aug 6th, 2007
0

Re: Searching multiple MS SQL Tables

I can barely read that text can you post a picture where all the text is big and clear to read. Thanks.
Featured Poster
Reputation Points: 1536
Solved Threads: 431
Posting Expert
iamthwee is offline Offline
5,865 posts
since Aug 2005
Permalink
Aug 7th, 2007
0

Re: Searching multiple MS SQL Tables

Is this better?
Attached Thumbnails
Click image for larger version Name: Diagram1.jpg Views: 18 Size: 233.9 KB ID: 3871  
Reputation Points: 10
Solved Threads: 0
Light Poster
TaoistTotty is offline Offline
46 posts
since Aug 2007
Permalink
Aug 7th, 2007
0

Re: Searching multiple MS SQL Tables

Hi,

what u actually want..? Search all the fields of all the tables for any one Specific condition...?

-Vee
Reputation Points: 84
Solved Threads: 140
Posting Shark
QVeen72 is offline Offline
923 posts
since Nov 2006
Permalink
Aug 7th, 2007
0

Re: Searching multiple MS SQL Tables

Vee, well put that is what I want.

I know this seems strange, but the old DB (propitiatory) can do this and they want to keep that functionality.
Reputation Points: 10
Solved Threads: 0
Light Poster
TaoistTotty is offline Offline
46 posts
since Aug 2007
Permalink
Aug 7th, 2007
0

Re: Searching multiple MS SQL Tables

Hi,

What is the Database u r using..? Access..?

-Vee
Reputation Points: 84
Solved Threads: 140
Posting Shark
QVeen72 is offline Offline
923 posts
since Nov 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: Plz resend the reply........
Next Thread in VB.NET Forum Timeline: Drill Down





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC