EXPLAIN! How to use Store Procedures for a Pocket PC device application.

[Antonio Contreras]

I would really like to know if I can use SQL Server Store Procedures on my
program for Pocket PC devices. If is possible, where can I get code examples
about using Store Procedures? or where to get information about it.



I count whit this tools:

1 My device is Pocket PC 2002

2 My DB is SQL Server 2000

3 Recently buy Visual Studio.NET 2003



Any help?



Thanks in advance!!



Antonio Contreras

(e-mail address removed)

 

[Antares]

You cannot use Stored Procedure on PocketPC
because SQL Server CE doesn't supports them.

Antares

 

[Antonio Contreras]

So, I can't make a pocket PC application that uses SP to send data to an
external SQL server Host...

What options we have then? Who can I send data to an SQL Server Host?

Thanks for your help.

 

[Alex Feinman [MVP]]

Look for any tutorial that shows how to use SqlClient class on the desktop.
In COmpact Framework SqlClient is a subset of the desktop class, but a
nearly complete subset, so you won't have many problems adapting the sample
code.

A sample of invoking SqlCommand on stored procedure can be found in your
Visual Studio installation under
SDK\v1.1\QuickStart\howto\samples\adoplus\outparamswithacommand\cs\outparams
withacommand.cs
towards the end of the module

 

[Antares]

If you need to send data to SQL Server host,
my advice is to use SQL Replication.
Here there are a lot of informations about that:
http://smartdevices.microsoftdev.com/Learn/Code+Samples/Qui
ckStarts/default.aspx

Good luck.
Antares