Changing from Datasets to Sqlceresultsets

Discussion in 'microsoft.public.sqlserver.ce' started by Chuck Hecht, Nov 12, 2009.

  1. Chuck Hecht

    Chuck Hecht Guest

    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
     
    Chuck Hecht, Nov 12, 2009
    #1
    1. Advertisements

  2. Chuck Hecht

    ErikEJ Guest

    ErikEJ, Nov 13, 2009
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.