DataSets and SQLServerCe

Discussion in 'microsoft.public.sqlserver.ce' started by Hollywood, Jul 22, 2003.

  1. Hollywood

    Hollywood Guest

    [Note: This is more about the DataSet, so it was posted to the compact
    framework group, but I figured someone here might have seen the same
    things... thanks!]

    Yes, I am attempting to use a DataSet with one DataTable to manage data in
    memory from a SQLServerCe data adapter. The DataTable is defined by a
    select statement that includes several joins (since the DataGrid control
    only supports reading from one table... the DataGrid however is fed by
    another DataView other than the DefaultView). However, when I attempt to
    get or set explicit pieces of data in the DataSet via the DataTable, i.e.
    dataset.Tables["myTable"].Rows["myRow"][0], it takes roughly a second to
    complete the operation. My understanding was that the DataSet was all in
    memory and that it does not update the database until the AcceptChanges
    method is called. To me this means that data access with the DataSet should
    be very fast. Am I missing something?

    Hollywood, Jul 22, 2003
    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.