Running query on web datset

[John]

Hi

Is it possible to do run a select query on a dataset from a web method using
a dataadapter? A code example would be great. If not, how can we grab hold
of the remote dataset data in a local table?

Thanks

Regards

 

[M. Zeeshan Mustafa]

John,

Check this article:
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconperformingxpathqueryondataset.asp

It tells how to run XPath query on DataSet object.

here is an example of running sql against dataset by Kamal
http://www.kamalpatel.net/Downloads/Querying ADO.NET DataSets.zip