Kaveri,
The only thing I would seriously consider changing it the number of DataSet.
Why do you have more than 1?
I'm assuming each DataAdapter is unique to a distinct table. If the tables
are the same & just different machines, then I would probably have a single
DataAdapter also, and change the connection as Scott suggests.
David Sceppa's book "Microsoft ADO.NET - Core Reference" from MS press
provides a plethora of information on Data Adapters, Data Sets and every
thing else ADO.NET!
Hope this helps
Jay
"Kaveri" <di********@hotmail.com> wrote in message
news:08****************************@phx.gbl...
Currently we use a data adapter and a dataset for fetching
data from multiple data source.
Once we populate the data from each data source we
merge all datasets into a single dataset.
Hence if there are 50 data retrieved from 50 different
sources, we will have to have 50 adapters and datasets.
We need to know if there are any better approach to this
solution ?
Any suggestions will be highly Appreciated.