My app is a .NET CF 2.0
I m working with SQL Server CE 3.5
I can read data in my database but write or delete operations raise no
exception but they dont have any influence on the database...

This is weird! My medical database works just fine and has done since ages,
until someone treid to look for a medicin begining with 'ney...'
Major Error 0x8007007A, Minor Error 0

Env.: SqlCE 3.5, Windows Mobile 6
Hi All,
I use .xsd based strongly typed data sets to access my DB.
Is it possible to retrieve @@identity from an Insert method?

Using VS2005
Sqlce 3.1
I have changed the dataset designer to generate ResultSets.  The
generated code seems to open the table with no ability to select the

I need to move a DataTable records to a table. How can I do that quickly?
Now I'm iterate the DataTable, and for each record I'm build the sql
instruction and insert it. The problem it is the time.
Any ideea?

I'm evaluating sqlserver compact and I have detected an ugly
restriction.
Apparently, its not possible to create a table containing 'double
precision' values, like

I have an SQL 2005 server with Connectivitiy tools and Windows Mobile 2003
and 5.0 clients.
The solution has recently been migrated from SQL 2000 to 2005.
I have an error message when making transfer with the main SQL 2005 database.

I'm using VS 2005 and ActiveSync 4.5.
Using the Server Explorer in VS 2005, I get the following error when I
try to add a connection to a sql server compact edition database that
resides on a CE device:

I have a quirky SQL problem that I would like solved. I used the
following SQL:
Dim sqlTA As New SqlCeCommand("UPDATE tblStandInfo SET si_samplearea =
(convert(float, si_samplelength) * convert(float, si_samplewidth) /

SqlCeDataReader will not return any records when using a string value in the
Where clause.  Integers work fine.   Following is a example of the problem
// Database columns            
//------------------

I'm looking for an example or tutorial that explain how create a
DataBase at run time though C#.
And then how to populate the Database with Tables and columns.
Thanks