I'm curious about the Parameters property in SqlCeCommand. Is this the
preferred/best usage of  the SqlCeCommand object? I suppose one benefit
of using Parameters is the ability to set binary/image data (as those
are byte arrays) for insertions/updates. Are there other benefits? I

How to conver Sql Express *.mdf database files to SQL Mobile *.sdf?
Thank you.
Krzys

I have SQL Standard 2000.  I need to create an application to use on a PDA
and then sync with our SQL 2000.  At a high level what are the steps I need
to perform.
Is SQL CE free, can I write the app in visual fox pro?  That sort of thing.

I am trying to upgrade an sqlce database to sql server moble edition. There
is a tool that comes with visual studio 2005 called upgrade.exe that I have
copied onto an hp4700. Now the problem is that this exe needs some
parameters. I therefore need a way of invoking a command line ...

is the SQL Mobile (CE 3.0) supported under Windows CE 4.2?
I see the SQL Mobile component in the Platform Builder 5.0, but not in the  
4.2 PB (the CF 2.0 is supported though)
Best regards

We are getting ready to move from PALM to Windows CE 5.0 Framework 2.0
on a Symbol device (MC3000, I think)... we are using visual studio
2005, btw...
Now I am trying to figure out the best approach...

I am designing a database that needs to be Synchronised with SQL Server CE
and I want to use a free version of SQL Server
Can I use MSDE, SQL Server Express?
Thank you,

How do you set the AllowSorting parameter on a Data Grid for a pocket PC
app. I want to be able to click on a column header and sort by that column.
I believe this is posible with .NET but not sure about .NET CF. Any other
work rounds would be appreciated.

I went through the procedure to install the query analyzer (3.00) with the
VS2005 tools on my Dell Pocket PC and it seemed like my installation went
fine (I actually reinstalled and that did not help)
But when I try to open a database I get a "isqlw error" saying "Faild to

We have  a big table ( >200000 rec.)  in our mobile sql database,
receiving it from main server every morning using RDA PULL method. Then
2 indexes are being created  - one is unique nchar(15) and another one
is not unique nchar(10). When we used SQL CE 2.0  it took about 2 min

I'd like to learn more about how to do queries *without* using SQL
commands, since I've found it to be faster.  However, it seems
difficult to find this information anywhere, and the documentation is
pretty skimpy.

I am developing application using .NET CF 2.0. I am using SQL Mobile 2005
for saving records in the PPC.
I have ARM processor's cab file for the same, but don't have for Intel
processor. Can any one help me in this regards...

We are using Mobile 5.0 Devices and need to start encrpting our
database. Does anyone know what the performance hit is when you encrypt
the database? We have a 20 or more tables within a database with a
total SDF foot print of about 80MB. More than what can fit in memory so

I am trying to figure out all the impact of migrating .NET 2.0 code
from using SQL Express to being database independent and sometimes
using SQL Everywhere.
The documentation states that

we have a system where users need to be authenticated in a windows
mobile based applciation. this has to be offline database (user db
stored in device).
I'm just wondering if anyone can help me identify if it would be a good