ADO.NET Datasets

[Rob]

Is it possible to do a INNER JOIN query on two tables that each have a different
connection object?
I'm trying to group data from an Excel spreadsheet with and SQL Server Table.
This data needs to be grouped using ADO.NET in a Dataset so I can add it
to a grid.
Thanks

Rob

[Mike Straw]

"Rob" <Robert_Levy@countrywide.com> wrote:
>
>Is it possible to do a INNER JOIN query on two tables that each have a different
>connection object?
>I'm trying to group data from an Excel spreadsheet with and SQL Server Table.
>This data needs to be grouped using ADO.NET in a Dataset so I can add it
>to a grid.
>Thanks
>
>Rob

I thought that was the idea of the datasets. You can fill them with data
from any source using different data adapters, which can access data from
different source types, to create tables in the data set. You then add a
data relation to the data set and set it appropriately for your data. All
this assumes that in your case you have data in each source that is the same
type and will result in records when related.

See the .Net code walkthrough for master/child forms.

mls