ADO.NET Datasets


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO.NET Datasets

  1. #1
    Rob Guest

    ADO.NET Datasets


    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

  2. #2
    Mike Straw Guest

    Re: ADO.NET Datasets


    "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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center