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

  • Thread starter Thread starter Antonio Contreras
  • Start date Start date
A

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)
 
You cannot use Stored Procedure on PocketPC
because SQL Server CE doesn't supports them.

Antares
 
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.
 
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
 
Back
Top