Inner Join entre Datatables


Truco de Visual Basic.NET - Inner Join entre Datatables


Dim ds as new DataSet()
ds.Relations.Add("Customers_Orders",
ds.Tables("Customers").Columns("CustomerID"),
ds.Tables("Orders").Columns("CustomerID")
ds.Relations.Add("Orders_Products",
ds.Tables("Orders").Columns("ProductID"),
ds.Tables("Products").Columns("ProductID")
ds.Relations("Customer_Orders").Nested = true
ds.Relations("Orders_Products").Nested = true

Pon el truco en tus favoritos Pon el truco en tus favoritos