Changing from Datasets to Sqlceresultsets

I have a project that uses a sdf with 13 tables. at program start I am
loading these tables into a cooresponding data table inside a dataset. My
first issue is the sdf is now to large 45mb and I am getting out of memory
errors. SO I want to move to a SqlCeResult set appraoch and pull the data fro
the sdf directly as needed.

Issue: I am having a hard time wrapping my head around where the datareader
comes in to play. Other issues are once I have the resultset created:

cmd.CommandText = "select asset_no, descript, qty, category from assets
Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Scrollable
Or ResultSetOptions.Updatable)

I know I can bind this to a control but how do I progrmatically access the
data?

Why is there no record count property for a resultset

Any guidance would be appreicated

chuck

There is a sample here, that should get you started:http://msdn.microsoft.

There is a sample here, that should get you started:
http://msdn.microsoft.com/en-us/library/bb219485(SQL.90).aspx
--
Erik Ejlskov Jensen - MCTS: Mobile App Dev