data access

[Guest]

Hi all,
I am trying to gather records from different databases into one dataset. I
can do the select statements and get the data into the datatables and then
into a dataset. The problem is then being able to get the data I need from
the dataset so that I can display it for a report. (I am trying to do a
select on the dataset tables) My question is, am I going about this in the
right manner or am I going down the wrong path. From everything I have seen
and read, a dataset query is not possible.
Can anyone steer me in the right direction? Any help or advice would be
appreciated.
Joe Hassan

 

[Alex Passos]

You can change the DataTable default view and perform some filtering on your
rows:

http://msdn.microsoft.com/library/d...fsystemdatadatatableclassdefaultviewtopic.asp

I don't believe this will work on the entire set but if you are merging data
from different sources onto the same table and same structure you can filter
it from a single point, or filter on as many tables as you have.

Alex