Strongly DataSet with multiple DataTables filled?

[Erik Funkenbusch]

..NET 2.0 VS 2005

I've got a remote database behind a firewall, I need to create a web
service that returns a dataset populated with multiple DataTables (so I
don't have to make several expensive soap calls).

I have no control over the database schema, so I have to work with it as
is.

I have several tables: one master table, and several detail tables that are
linked to the master, some with one-to-many relationships, some are
one-to-one. I also have a table unrelated to any of the rest of the data.

I created a stronly typed dataset that has all the tables defined in it,
along with Get and Fill functions that take parameters (the master and
unrlated table take date parameters to return all rows on a certain date,
while the detail tables take master id number and return all rows that have
id's that are in the master table).

I want to fill all the datatables with the appropriate data, then return
that dataset from the web method.

I'm kind of at a loss to figure out how to approach this.

How do I fill all the datables in the dataset with the appropriate data so
that I can return it all at once?

Any suggestions?

 

[Cor Ligthert [MVP]]

Erik,

Just "fill" the datatables one after each other at the server site using the
dataadapter or the tableadapter.

I hope this helps,

Cor

 

[Erik Funkenbusch]

Erik,

Just "fill" the datatables one after each other at the server site using the
dataadapter or the tableadapter.

Doh, I was missing something in the whole Strongly typed dataset mess....
This makes much more sense now that I understand it more.

Thanks.