bob12345 Posted September 6, 2003 Posted September 6, 2003 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. Quote
sjn78 Posted September 7, 2003 Posted September 7, 2003 Is there a reason why there are 2 databases?? Wouldn't it be easier to have everything in the 1 database? Quote
bob12345 Posted September 7, 2003 Author Posted September 7, 2003 No, it's defined not by me. Anyway, I've solved the problem. 2 adapters fill single dataset. Quote
sjn78 Posted September 8, 2003 Posted September 8, 2003 Thats good you have solved it. I was thinking about this and I thought running your first query and storing the client id's in an array or single variable and then basing your second query on that variable to pull out the required records. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.