Re: SQL Server CE vs. DataTable

Shloma,

The notification you want is part of Windows Mobile 5.0, but it isn't
available before that. When the OS wants to close your app, it sends a
WM_CLOSE message, you can put some code in your OnClosing event handler. But
honestly, if you really care about saving your data, I'd recommend writing
it out to persistent storage as it's collected. If you have a lot of data,
then SQL Mobile is a great choice. If you only have a little and you're just
adding records and not changing them, you can add them to a file in a custom
format perhaps based on CSV.

--
Ginny Caughey
..NET Compact Framework MVP


"Shloma Baum" <shlomabaum-spam@xxxxxxxxx> wrote in message
news:OfXGKt2wFHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
> Ginny,
>
> I'm new to the CF, however I'm also wondring if I should go with SQL
> Mobile or DataTable, but about what you mention isn't there a way to raise
> an event that when when the machine for instance gets to a specific
> percent of battary usage it should save the dataset to disk?, and the same
> when you do a reset?
>
> Thanks in advance
> Shloma
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in
> message news:emtde2twFHA.3400@xxxxxxxxxxxxxxxxxxxxxxx
>> If you truly don't care if you lose the data if your app ends or the
>> device gets reset, then there's no need to store it elsewhere, but are
>> you really, really sure you don't care?
>>
>> Ginny Caughey
>> .NET Compact Framework MVP
>>
>> "blue_nirvana" <bluenirvana@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:409647D1-0A0B-43D0-A883-05A597113495@xxxxxxxxxxxxxxxx
>>> Is there any benefit of using SQL Server CE for data storage rather than
>>> simply using a dataset? I'm simply getting some data from a SQL Server
>>> and
>>> will be using this data to verify data that will be scanned with the
>>> wireless
>>> scanner. I'm thinking that since I do not care if the data is lost if
>>> the
>>> program is terminated, then I do not need to keep it in SQL Server CE
>>> and can
>>> easily use a dataset. Is this an OK way of doing this?
>>
>>
>
>


.

Relevant Pages

  • Re: Alternatives to SQL Server Mobile?
    ... synchronization product. ... It is by far the most robust mobile DB ... > want to move our app to Windows Mobile, so I try to get used to ... > However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)
  • Re: Model app
    ... Yeah I did but it does not seem to use sql server 2005 mobile which I need. ... WeRock 247 is a better application for me but as far as I can tell it is a ... vs2003 app. ...
    (microsoft.public.dotnet.languages.vb)
  • Synchronize SQL Server with Access MDB?
    ... but I recently moved a app to SQL Server ... Now I have a new CRM tool that needs ... to be mobile, but should also synch with the Project table on SQL Server. ...
    (comp.databases.ms-access)
  • Re: Generate SQL Server Mobile Database
    ... central a base de dados SQL Mobile e depois copiar para o equipamento ... SQL Server e irão ser exportados os dados. ...
    (microsoft.public.sqlserver.ce)
  • Re: Alternatives to SQL Server Mobile?
    ... Intellisync offers robust database sync between SQL Mobile, ... > However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)