Join tables in DataSet

[rh.krish]

Hi,
I have to join two table in a DataSet. I cannot do the join in
stored procedure as the data for the tables come from different
database servers. Data for table 1 comes from Sql Server, while data
for table2 comes from Oracle. Both the tables will have common column
to link with. Here is the table structure:

Employee: (Oracle)
employee_id, first_name, last_name, .....

Member (Sql Server)
member_id, first_name, last_name,....

member_id is same as employee_id

How to do this in dataset? I think it can be done by using
DataRelation, but I'm not sure how exactly to do it?. Any help?...

Thanks,
Hari.

 

[Val Mazur \(MVP\)]

Hi,

Here is an example

http://msdn.microsoft.com/library/d...l/cpconaddingrelationshipbetweentwotables.asp