Tutorial describes remote database access for Smartphones

[Guest squall]

Source: windowsfordevices.com

One for the wanna-be developers amongst us:

MSDN has published an extensive tutorial on how to build remote database access applicatons for Smartphones and Pocket PCs running Windows Mobile 2003. Based on the Dataset Server CE sample project, the tutorial explains how to perform data synchronization between a Windows Mobile-based device and a Microsoft SQL Server.

Developers choose SQL Server CE for a variety of reasons, including its high performance, security, stability, easy programmatic access, and direct links to server-side Microsoft SQL Server 2000 databases, the article says. The article aims to show how to use the sample project DataSet Server CE to get data store and data synchronization features, similar to those of SQL Server CE, in application development for Smartphones running Windows Mobile 2003 software.

DataSet Server CE client and server (Source: Microsoft)

The bulk of the article consists of walkthroughs of extensive source code listings comprising five projects:  

DataSet Server CE client engine (DataSetServerCE.csdproj) -- Class component that implements a RemoteDataAccess class with the same interfaces as SQL Server CE.

DataSet Web Service Server Agent (DataSetServerAgent.csdproj) -- Server-side Web service that is similar to the SQL Server CE Server Agent. Manages communication with remote databases and implements the synchronization and tracking features.

Smartphone 2003 demonstration client (dssceClientSMP.csdproj) -- A Windows Mobile 2003-based Smartphone client that uses the DataSet Server CE client to execute Pull, Push, and submitSQL statements.

Pocket PC 2003 demonstration client (dssceClientPPC.csdproj) -- Windows Mobile 2003-based Pocket PC client that uses the DataSet Server CE client to execute Pull, Push, and submitSQL statements.

The full MSDN article is available here:

DataSet Server CE: Database Connectivity for Windows Mobile-Based Devices

[Guest rasheed1979]

I have written a article about it and it is available in http://www.codeproject.com/netcf/PocketPCwithSQLCE.asp

I have written this article for Pocket Pc. I guess it will work in smartphone too. Hope this sample will help some of us.

Rasheed.