dataset manipulation

  • Thread starter Thread starter Magnus Persson
  • Start date Start date
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
 
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
 
Back
Top