News

  • Home > News

        Tutorial describes remote database access for Smartphones

        Doug | Date: Aug 27, 2004 | Comments: 1


        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