dataset manipulation

[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

[Magnus Persson]

Well...not as long as your system time is messed up ;)

"shahrukh" <sh******@hotmail.com> wrote in message
news:ez****************@TK2MSFTNGP11.phx.gbl...

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

[Nick Bennett]

Sharukh

Something like this may do the trick:

DataSet ds = new DataSet();
SqlConnection myConnection = new SqlConnection(...);
SqlDataAdapter adapter = new SqlDataAdapter(
"SELECT * FROM City WHERE CityName = 'Sydney'", myConnection);
adapter.Fill(ds, "City");

Nick
"shahrukh" <sh******@hotmail.com> wrote in message
news:ez****************@TK2MSFTNGP11.phx.gbl...

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