On Oct 18, 6:24 am, "PO" <h> wrote:
> Hi,
>
> I'm fairly new to ado.net and I'm not sure I'm doing this in the best way...
> I retrieve two tables from two different databases and place them in a
> dataset. Both tables have a column which relates them. The relation type is
> one to many.
>
> I use a custom procedure to "merge" the two tables into a third before I
> display the third table in a datagrid. The procedure creates a new table and
> iterates through the two tables using a relation object and GetChildRows.
>
> Is this how it should be done or is there a built in function that can do
> the work for me?
>
> Regards
> Pete

> On Oct 18, 6:24 am, "PO" <h> wrote:
>> Hi,
>>
>> I'm fairly new to ado.net and I'm not sure I'm doing this in the best
>> way...
>> I retrieve two tables from two different databases and place them in a
>> dataset. Both tables have a column which relates them. The relation type
>> is
>> one to many.
>>
>> I use a custom procedure to "merge" the two tables into a third before I
>> display the third table in a datagrid. The procedure creates a new table
>> and
>> iterates through the two tables using a relation object and GetChildRows.
>>
>> Is this how it should be done or is there a built in function that can do
>> the work for me?
>>
>> Regards
>> Pete
>
> If by "merge", you mean do a JOIN like INNER or LEFT JOIN, I believe
> you are right.
>
> Check this out: http://support.microsoft.com/kb/326080
>
>
>
>

"PO" <h> wrote in message news:%239MLHpYEIHA.4544@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> I'm fairly new to ado.net and I'm not sure I'm doing this in the best
> way...
> I retrieve two tables from two different databases and place them in a
> dataset. Both tables have a column which relates them. The relation type
> is one to many.
>
> I use a custom procedure to "merge" the two tables into a third before I
> display the third table in a datagrid. The procedure creates a new table
> and iterates through the two tables using a relation object and
> GetChildRows.
>
> Is this how it should be done or is there a built in function that can do
> the work for me?
>
> Regards
> Pete
>