Join tables in DataSet

16 Feb 2006 8:13 PM

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.

17 Feb 2006 11:25 AM

Val Mazur (MVP)

Hi,

Here is an example

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaddingrelationshipbetweentwotables.asp

--
Val Mazur
Microsoft MVP
http://xport.mvps.org

<rh.kr***@gmail.com> wrote in message

Show quote

news:1140120821.316225.212130@f14g2000cwb.googlegroups.com...
> 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.
>