Hi all,
I use vb.net, sql server 2005. My boss want to join many database to crystal report and print.
I have main database call A, want to make centural 3 tables. Database A has (funtionA, SystemA, CompanyA, UsermasterA, AccessRightA), 5 tables and relation.
Other database call B,C,D,E,F many database .....have same tables structure if B call (UsermasterB, AccessRightB), C call (UsermasterC, AccessRightC),etc ... only 2 tables(UsermasterB, AccessRightB) ,no 3 tables (funtionB, SystemB, CompanyB).....
The main database A table company has a field call dbname, my boss want to store the real database name, then
one database will one record. In this case will A,B,C,D,E,F 6 records will store.
My form has one combo box will load all of company records, user can select one company or not select will print all of
company data. If user select B, then i want to database B tables(UsermasterB, AccessRightB) join Main database A tables
(funtionA, SystemA, CompanyA) to print information. if not select database B tables(UsermasterB, AccessRightB) join Main database A tables
(funtionA, SystemA, CompanyA) , database C tables(UsermasterC, AccessRightC) join Main database A tables
(funtionA, SystemA, CompanyA) ...etc continue no database.

In vb.net how can i do, question 1. how to store many join database tables, i can use many dataset, datatable or tableadapter ?
question 2. how to store many join database tables in crystal report?

Anyone know how to do?