manipulating the dataset

[Chris Taylor]

Hi,

Unfortunately there is no SQL query engine provided for DataSets/DataTables.

Regards

Chris Taylor

 

[Chris Taylor]

Hi,

You could use an XPath query to query the DataSet, the following link should
get you started
http://msdn.microsoft.com/library/d...e/html/cpconperformingxpathqueryondataset.asp

Other options include using Select method on the DataTable and on a DataView
you can use RowFilter, Find and FindRows.

Which one you choose depends on your requirements, the XPath query is very
flexible, but requires you to learn the XPath language.
The other options are less flexible to varying degrees, but might be exactly
what you require making them perfect!

Hope this helps

Chris Taylor

 

[shahrukh]

hi
i have a dataset in my webservice which i pass to the windows app.
i want to be able to make querries to that dataset
and update it too ..then pass it back to the web service for updatng the
database..
that way i dont make calls to the database time and again.
any idea where i can read more on this?


also i have found 1 way to query my dataset but i dont quite like it
i would prefer the sql way of querrying my dataset

DataRow[] SydneyRecs = dsCity.Tables["City"].Select("CityName = 'Sydney'");

is it possible to do an sql type of query on my dataset rather than the

command above

thanx for your help

 

[shahrukh]

so whats the best way to do this?
and what are the other different ways?