Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a relationship between 2 datasets
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
How to create a relationship between 2 datasets
Miscellaneous
Thread ID:
00706450
Message ID:
00706450
Views:
70
All,

I am trying to establish a relationship between 2 datasets. First I download the 2 datasets
DataSet1 = RetrieveComponets();
DataSet2 - RetreiveValidators();
The two tables are linked by the data in column[0] in each of the 2 datasets.

To set a relationship between 2 tables, they need to be in the same dataset. How Do I add DataSet2 to DataSet1 above so that the following will work:
DataSet1.Relations.Add("DS1relatestoDS2", DataSet1.Tables[0].Columns[0], DataSet2.Tables[1].Columns[0]);
This should be easy - I'm missing something.
TIA,
Doug
Douglas Osborne
Don't spend your life just wishing - http://www.AllGiftRegistry.com
Next
Reply
Map
View

Click here to load this message in the networking platform