DataSet

[itsme]

Hi,

How can I combine the rows from two tables as a result of
an outer join, wherein I have a primary key and foreign
key constraints.

Right now, I am using two different adapters to fill the
dataset. Is there any way I can use a single data adapter
to fill the data in the dataset with constraints in tact?

Your suggestions are truly appreciated.

 

[Cowboy \(Gregory A. Beamer\)]

You can send multiple commands on a single adapter. If you are using stored
procedures, simply return multiple result sets via separate SELECT blocks.
You will have to map the tables (which will be Table, Table1, Table2 ...
TableN) to friendly names, if that is your goal (a good goal for
maintainability). The syntax is like so:

DataAdapterName.TableMappings.Add("Table", "Customers");

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************