SQLClient to SQL Server (not CE !!!) with CF Example ?

  • Thread starter Thread starter Axel Stallknecht
  • Start date Start date
A

Axel Stallknecht

Hi,

does anyone know where I can find an example, maybe a little VS.NET project,
that shows how to connect, filling datasets etc. from a PPC 2002-Client
to a SQL Server 2000 ? The example should be in C#.
Momentary I have a Windows CE Database that is replicated with the SQL
Server if the iPAQ is in the docking station. But since a few weeks we have
a
WLAN, so that I make the synchronisation wireless. So we have a WLAN
connection
it makes sence to use a direct connection to the SQL Server insted of
replication.

Thanks in advance.
JT
 
Hi, i assume you have Visual Studio.net 2003, if so, you
can go to program files\Microsoft Visual Studio .NET 2003
\CompactFrameworkSDK\v1.0.5000\Windows
CE\Samples\VB\Pocket PC\Inventory

This sample demonstrates the use of system.Data.DataSet
and system.Data.SqlClient.SqlDataAdapter. If you don't
have a copy of the sample Northwind database that comes
with SQL Server, you can use "Inventory.xml" as the
datasource.
"Inventory.xml" is deployed to the same directory as the
sample.

best regards
Ronald Armas
MCSD
 
Hi Ronald,

oooh yes. I have found it. I'd better look to my harddisk
before post. ;-)

Thank you very much,
JT
 
Back
Top