join tables form two odbc datasources
Database
2
Posts
2
Posters
0
Views
1
Watching
-
is there a way to join two tables from two diffrent odbc data sources (or joining to dataset tables) ..any ideas?
Yeah it's easy :) To create a relationship between 2 datasets create a datarelation. Look in the Visual Studios help index for datasets, relationships Thier example is as follows. Dim CustomersOrders As New DataRelation("CustomersOrders", _ DsNorthwind1.Customers.Columns("CustomerID"), _ DsNorthwind1.Orders.Columns("CustomerID")) DsNorthwind1.Relations.Add(CustomersOrders) "People who never make mistakes, never do anything." My blog http://toddsnotsoamazinglife.blogspot.com/