Book on developing enterprise applications using embedded Visual Basic.
Table of Contents
1. Introduction to eVB Development.
You, the Reader. What You Will Need. Pocket PC, Handheld PC 2000, and Other Devices. Pocket PC. Handheld PC 2000. Other Devices. Overview of eMbedded Visual Basic (eVB). Compared to Visual Basic 6.0. Using eMbedded Visual C++ (eVC). Emulation. Development Tools Installation. Creating a “Hello World” Application. Network Connections. Configuring HPC 2000 Network Support. Configuring Pocket PC Network Support. Platform Manager. Remote Tools. ActiveX Controls and the Windows CE Control Manager. Project Settings and Properties. Error Handling. eVB Data Types. Debugging. Conclusion.2. Creating a User Interface.
The Pocket PC Interface. Managing Pocket PC MenuBars. Responding to Menu Selections. Using the New Button. Changing a Menu Item at Run Time. Accessing Menu Items at Run Time. Inserting and Deleting Menu Items. Adding MenuBar Buttons. Pocket PC Dialog Boxes. The HPC 2000 Interface. Designing Application Windows. Creating a Pocket PC Application Window. Creating an HPC 2000 Application Window. Conclusion.3. ADOCE and ADOXCE.
Microsoft SQL Server for CE Features. The ADOCE 3.1 Architecture. Microsoft SQL Server for CE Installation. Installing ADOCE and ADOXCE on the Device. Copying SSCE Files. Installing ISQLW for Windows CE. Simple Database Operations. Creating a Database (Catalog). Opening and Closing Databases. Creating a Table. Adding Records. Listing Records. Using ISQLW_CE. Tables and Columns. Integer Data Types. Numeric, Float, Real, and Money Data Types. Binary, VarBinary, and Image Data Types. UniqueIdentifer Data Type and ROWGUIDCOL. The Identity Property. Null ability and Uniqueness. Referential Integrity and Primary and Foreign Keys. Default Values. Using DROP TABLE. Using ADOXCE With Tables. Indexes. Manipulating Data. Creating and Opening Databases. Error Handling. ADOCE Record sets and the SELECT Statement. INSERT, DELETE, and UPDATE Statements. Managing Transactions. Encryption and Password Protection. Compacting a Database. Creating a Database For Distribution. Conclusion.4. SQL Server CE Remote Data Access and Replication.
Remote Data Access. RDA Installation and Configuration. Programming RDA. SQL Server CE Relay. Security. SQL Server Replication. Installation and Configuration. Programming Replication. Dealing with Conflicts. Conclusion.5. HTTP and Internet Programming.
Using the WinSock Control. Sending Data with an HTTP GET. Sending Data with an HTTP POST. The HTTP Component. Making a Simple Request. Posting Data. Using NT Authentication. Using a Proxy Server. Conclusion.6. XML and DOM.
XML. Document Object Model (DOM). Microsoft SQL Server 2000 and XML. Configuring XML Support. Creating a Template. Accessing a Template from evb. Parameterized Templates. Displaying XML Documents in a TreeView Control. Handling SQL Errors. Adding Data with Templates. Annotated Schemas and Xpath. ADO Recordsets and XML. Creating and Managing XML Documents with DOM. Creating XML Documents with Elements. Creating XML Documents with Attributes. Sending an XML Document to an ASP Page. Conclusion.7. SOAP and .NET Web Services.
The Simple Object Access Protocol (SOAP). Installing SOAP 2.0 Toolkit. SOAP XML Document Structures. Making SOAP Calls from Pocket PC and HPC 2000 Applications. Using .NET Web Services. Creating a .NET Web Service with VB.NET. Calling Web Services with HTTP GET and POST. Calling Web Services with SOAP. Using Class Objects in .NET Web Service. Using ADO.NET DataSets. Conclusion.8. Managing Connections with RAS.
Creating RAS Phone Book Entries. Listing RAS Phone Book Entries. Determining If a Connection Exists. Making an RAS Connection. Disconnecting an RAS Connection. Conclusion.9. Pocket Outlook Object Model (POOM).
Overview of POOM Model. Logging on and POOM Version. Adding a Reference to PIMStore.DLL. Logon, Logoff, and Version Information. Folders and Items. Managing Contacts. Using OIDs. Finding and Restricting Items. Displaying Contacts. Managing Contacts. Managing Tasks. Managing Appointments. Conclusion.10. The Object Store, File Input/Output, and the Registry.
The FileSystem Control. Folder Listing. File Listing. File Operations. The Object Store. Memory Status. Storage Cards. The Common Dialog Control. File Open Dialog on Pocket PC. File Open Dialog on HPC 2000. File Save As Dialog on Pocket PC. File Save As Dialog on HPC 2000. Reading and Writing Files. Text-Based Files. Unicode Files. Binary Files. Random Files. The Registry. Writing a Registry Key. Accessing a Registry Key. Conclusion.11. Setup and Installation.
Using the “Application Install Wizard”. Installing the Application. Conclusion.12. Architecting and Designing a Mobile Solution.
Connectivity Options. Local Storage Options. Data Transfer Options. Data Synchronization. Creating a Green Field Mobile Architecture. Integrating with Client Server Architectures. Integrating with n-Tier Architectures. Conclusion.Appendix A: The CEUtils ActiveX Control.
The DatePicker Control. The ObjectStore Component. The Process Component. The RASConnection Component. The StrRegistry Component.Appendix B: HTTP ActiveX Component. Index.
Mobile solutions-in your pocket!
- The complete guide for developing wireless applications using Microsoft(r) eMbedded Visual Basic(r)
- Enterprise solutions, including XML, SQL, SOAP, and .NET
The Pocket PC offers more wireless capabilities than any other handheld mobile device. Now you can use the power of Microsoft eMbedded Visual Basic to develop applications that allow you to manage connections to corporate networks, access data from any Web site, synchronize information with corporate databases, and call SOAP and .NET web services, all on your Pocket PC. This is the one book that provides comprehensive coverage of all these applications and more.
Developers at all levels can learn to take advantage of the Microsoft SDKs to interact with existing database and Internet applications, using such technologies as:
- User interfaces for Pocket PC and Handheld PC 2000
- SQL Server for Microsoft Windows(r) CE
- XML and DOM
- SOAP and .NET
- HTTP and ASP
No other book provides more complete coverage in a single volume. Jump right into wireless mobile computing with the Pocket PC, Handheld PC Developer's Guide.
Nick Grattan is co-founder and Technical Director at Software Paths Limited in Dublin, Ireland (www.SoftwarePaths.com). A specialist in mobile solutions, he is also the co-author of Windows CE 3.0 Application Programming (0-13-025592-0), also published by Prentice Hall PTR.