i want to insert values into a table select one field value from other table
(want to write select statement into insert statement but not knows how to
do it)
how can i implement it

Is it possible to connect a PocketPC with SQL CE to any other databases than
SQL Server?  I know that the typical connection uses the SQL Server Agent and
an ISAPI DLL to connect to SQL.  ARe there other ways to connect to say an
Oracle database using RDA?

I created a database with four tables in my VS.NET 2003 and SQL Server 2000.
Now I replicated the tables with the Replication Mechanism on the SQL Server
CE database on my PocketPc. But now when I want to make a Select Statement
with a Where and a parameter there occurs always ...

I created a function in C-Sharp to do a connection between Windows CE
.Net 4.1 and one MSDE SQL Server. This function work when I run it on
a PC but when I run it on WinCE the connection failed.
There is a procedure, files to copy or something to install on WinCE

my method for retrieving data from the sql server ce database and display it
in a data grid looks as follows:
dataSet = new DataSet("Jobs");
daptJobs = new SqlCeDataAdapter("Select Priority, Problem, EmailClient From

Sorry I have to write once more, because I was not able to fix the problem
yet. I have replicated the database of the SQL Server 2000 to SQL Server CE
on my PocketPc (the types of the fields are almost NVarChar, int oder image).
But always when I want to execute a simple SELECT ...

Help system states:
Compact determines the properties of the new database based on the
properties of the existing database and the initialization properties passed
to Compact in the data source object. The caller need only set properties

my method for retrieving data from the sql server ce database and display it
in a data grid looks as follows:
dataSet = new DataSet("Jobs");
daptJobs = new SqlCeDataAdapter("Select Priority, Problem, EmailClient From

I read in this forum that the SQL Server CE does not support stored
proedures but in my .NET Compact Framework Programming with C# there are
samples to user stored procedures. Or is it only possible to use stored
procedures when the device is connected to the SQL Server? - ...

From what I have read in the documentation altering columns isn't support.
I need to remove an identity field from a table.
So far I basically drop the column and then add it again.
The problem arises though when I want to create my new column and assign it

I have delevoped a Smart Device Application on my PocketPc with a local Sql
Server Ce database. Now i want to develop a desktop application with the same
functionality and replication between these two databases.
Can anybody explain what i have to consider referring the creation ...

Am trying to install SQL Server 2000 Personal Edition onto my computer. The install goes along fine until  it tries to register the server and comes with the followng message "Setup failed to configure server". Upon reviewing the lop file the following is noted:
"10:01:42 C ...

We have an application that we ported over C# on the PocketPC.  It accesses a
backend SQL Server database using a wireless connection.  The SQL Server is
running on a standalone PC which also has our dsktop application running on
it.  There may be as many as 10 concurrent users ...

I'm getting a Native Exception from the synchronize method in my app, and
I'm dead in the water :(
I have 2 tables: tbl_Products and tbl_Inventory. tbl_Products is part of a
publication. tbl_Inventory has been created using an RDA Pull. They both

Where can i download SQL CE Server Components ?
I need to install the components in visual Studio.NET
Ankit Parikh
Software Developer