Join tables in DataSet

  • Thread starter Thread starter rh.krish
  • Start date Start date
R

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.
 
Back
Top