Multiple Data Adapters.

[Bob T]

Hi,

I have been using SQLDataAdapters and Datasets in my project.

I have a goal to simplify the project. Each data adapter has a
corresponding dataset it retrieves values into. Even though the data
structure of 3 datasets is identical, the 3 data adapters use 3 different
stored procedures depending on what I am trying to accomplish.

It would seem that since the returned data fields are the same that I would
only need 1 dataset. I haven't been able to configure more than one data
adapter to feed a single dataset (single table in a dataset). Perhaps I
don't understand the fundamentals of the data adapter/dataset relationship
but is there a way to have more than 1 data adapter based on different
stored procedures to fill a single table in a single dataset????

Any references to relevant explanations or articles is appreciated.

Bob

 

[Dino Chiesa [Microsoft]]

Do you want to use the DataAdapters all at the same time?
In other words,
da1.Fill(ds1);
da2.Fill(ds1);
da3.Fill(ds1);

or so you want to select the dataAdapter to use, and only Fill() once?

-Dino