I like the new TableAdapter in .net 2005 but is there a designer-based
mechanism that populates a DataSet's multiple DataTables from a stored
procedure that returns multiple result sets. i.e. to configure the equivilant
of a DataAdapter's TableMappings?

Hi Richard,

The TableAdapter is a table based DataAdapter, which can only populate 1
DataTable data. If you need to configure the column mapping in the
TableAdapter in the DataSet designer, you can simply change the column
name. The columnn mapping code will be generated automatically. HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Thanks for your replay but it doesn't quite address my problem.

My dataset's typically have multiple tables in them, Order and Order Item
for instance. Populating them in 2003 was relatively easy but required a bit
of code to setup the connection, the command, the data adapter, the table
mappings, etc. A single call is then made to the DB which returns multiple
rowsets which (via the table mappings) populate the dataset's multiple data
tables. But I'm sure you know all this.

I very much like the new features in 2005 and have already identified how we
could refactor parts of our existing applications with a significant
reduction in code in favour of declarative-based development. But this does
somewhat rely upon being able to populate multiple-table datasets via a
single call to the database. But I can't see how to do this. Any ideas?



"Kevin Yu [MSFT]" wrote:

Hi Richard,

Sorry, but I'm a little confused. Are you using a DataAdapter to fill data
or a TableAdapter to fill data? A TableAdapter cannot return multiple
result sets. Only the first one will be returned.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

I'm sorry to confuse.

My point is, I really like the new TableAdapter and its code-free
declarative method of configuration. But as far as I can see, it is only
useful when the DataSet contains just a single DataTable (or if you are happy
to populate the DataSet via multiple calls to the database - one for each
DataTable).

I can't believe Microsoft would go to the effort to provide the code-free
declarative TableAdapter and not provide a similar code-free declarative
mechanism to populate a DataSet that has multiple DataTables - especially as
the only additional facility would be a collection of TableMappings.

But I can't see how to do this.

"Kevin Yu [MSFT]" wrote:

Hi Richard,

As you know, the TableAdapter will only fill data to one DataTable. To fill
multi-table DataSet at once, you still have to use the DataAdapter. If you
drag and drop a DataAdapter to the designer, you can also use the designer
to set TableMappings. However, TableAdapter cannot achieve that since it's
single table based, which is by design.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

You say "drag and drop a DataAdapter to the designer". How do you do this. My
toolbox only has a TableAdapter (and a Query, a DataTable and a Relation).

"Kevin Yu [MSFT]" wrote:

When you use the Data Source Configuration wizard (DSCW) to create a
strongly typed DataTable (exposed as a "TableAdapter"), you can drag from
the Data Sources window to a Form design surface--not from the Toolbox.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Dick" <Richard.Giles (AT) nospam (DOT) nospam> wrote

Thanks for trying to help but that's not nearly what I'm trying to do.

My original post said something like "the new TableAdapter and the
declarative way to configure it using the designer is excelent, but what
about DataSets with more than one DataTable, i.e. why do these improvements
not include a way to configure the TableMappings that allow a single stored
procedure to return multiple rowsets which populate multiple DataTables"?

Kevin Yu's response said "you can drag and drop a DataAdapter to the
designer then use it to configure the TableMappings". But I can't work out
how to do this!

"William (Bill) Vaughn" wrote:

Hi Richard,

The DataAdapter is not available in the DataSet's designer. It's available
in the form designer. You can find it in the Data section. If it doesn't
appear there, you can choose from the Choose Items... popup menu.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."