Handling data from 2 MDB files (VB.NET)

B

bob12345

New member
Joined
Sep 6, 2003
Messages
3
2 MDB files: 1st has Clients table ClientID and ClientName fields; 2nd has Orders table with OrderDate and ClientID fields and other.
According to entered Date I need to display in 1st DataGrid ClientName and in 2nd DataGrid order(s) detials of same Client.

So, I need 2 connections and 2 DataSets for each connection: I fill 1st DataSet with orders for specified date, having ClientID in it. Now, how do I select into 2nd DataSet names of appropriate clients from Clients table from another file (connection/adapter) basing on CleintID? How do I build "Select" statement based on data in anoher DataSet?

VB.NET please.
 
Is there a reason why there are 2 databases?? Wouldnt it be easier to have everything in the 1 database?
 
Thats good you have solved it. I was thinking about this and I thought running your first query and storing the client ids in an array or single variable and then basing your second query on that variable to pull out the required records.
 
Back
Top