Is it possible to do run a select query on a dataset from a web method
using a dataadapter?
Huh?
A code example would be great. If not, how can we grab hold
of the remote dataset data in a local table?
What?
Ok, can we just try to clarify? Let's start slowly. The basics. Bear with
me because I am not very bright. You say there's a remote dataset. I
presume this means there is a DataSet in memory, in some place that is not
local. Let's set our reference point to the local machine, call it A. The
DataSet in question is in an application on machine B. (It's remote).
Now, what is it that you want to do with this DataSet that resides on
machine B? Do you want to transmit it to machine A ?
You know you can do this with webservices. We talked about this scenario
in our last session. In this case, a copy of the DataSet is created on
machine A. Now there are two DataSets, containing identical data, one
resides in an app on machine B, one resides in an app on machine A.
What else do you want to do with this remote DataSet?