Home Page Icon
Home Page
Table of Contents for
.NET Compact Framework 3.5 Data-Driven Applications
Close
.NET Compact Framework 3.5 Data-Driven Applications
by Edmund Tan
.NET Compact Framework 3.5 Data-Driven Applications
.NET Compact Framework 3.5 Data-Driven Applications
.NET Compact Framework 3.5 Data-Driven Applications
Credits
About the Author
About the Reviewer
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Errata
Piracy
Questions
1. CRMLive.NET: An Overview
Tomorrow Inc.
The mobile sales force application
The mobile dashboard application
The mobile support case application
Data flow in CRMLive.NET
Deciding on the type of mobile application
Thin clients
Thick clients
Smart clients
Messaging
A brief summary
Defining the mobile sales force application
Capturing lead, opportunity, and customer information
Mobile screen design
Creating reusable controls
Maintaining global lists
Data retrieval and manipulation on the mobile device
Data transfer between multiple mobile devices
Task management
Full-text search functionality
Integrating with Windows Mobile and the hardware
Detect incoming phone calls and SMS
Integrating with the Windows Mobile Calendar and Contacts book
Data exchange using Bluetooth and IrDA
Capturing handwritten input
Data synchronization
Dual database support
Application maintenance and upgrades
Defining the mobile dashboard application
Using stateless web services as a data source
Rendering the dashboard
Road show revenue
Total monthly sales
Sales for last three months
Defining the mobile support case application
Building a messaging backbone with MSMQ
Summary
2. Building the Data Tier
Designing the data tier
SQL Server CE 3.5 versus Oracle Lite 10g
Connecting the Windows Mobile emulator to ActiveSync
Setting up SQL Server Compact 3.5
Installing SQL Server CE on the development machine
Installing SQL Server CE on the Pocket PC device.
Setting up Oracle Lite 10g
Installing Oracle Lite 10g on the development machine
Installing Oracle Lite 10g on the Pocket PC device
Building the data tier
Building the CRMLiveFramework project
Defining the IDataLibPlugin interface
Building the Plugin Manager UI
An overview
Implementing the PluginCollection class
Implementing the PluginManager class
Creating the SalesForceApp project
Building the ConfigurePlugin form
Building the PluginsSetup form
Testing what you've built so far
Building the database plugins
Implementing the SQL Server CE Plugin
Storing DDL in the resource file
Building the plugin class
Connecting to SQL Server CE
Programmatically creating the SQL Server CE database
Testing what you've done so far
Browsing the SQL Server CE database with Query Analyzer
Retrieving data from SQL Server CE
Data manipulation in SQL Server CE
Dealing with GUID values in SQL Server CE
Implementing the Oracle Lite plugin
Storing DDL in the resource file
Building the plugin class
Connecting to Oracle Lite
Programmatically creating the Oracle Lite database
Browsing the Oracle Lite database with Msql
Retrieving data from Oracle Lite
Data manipulation in Oracle Lite
Dealing with GUID values in Oracle Lite
Summary
3. Building the Mobile Sales Force Module
A brief walkthrough of what you will be building
Building a form navigation class
Building the main menu
Using Main() as the startup object
Creating the business objects to encapsulate your DataSets
Validating data in your business objects
Building the AccountViewer form
Data binding .NET controls to your business objects
Launching the AccountViewer form
Testing the AccountViewer form
Building the Tasks list
Populating the Tasks Datagrid control
Building the TaskDetailViewer form
Launching the TaskDetailViewer form
Testing the tasks list
Handling file attachments
Building a file manager class
Building the FileUpload user control
Building the FileDetailViewer form
Testing file upload functionality
Custom formatting and display in list controls
Building a collection sorter using the IComparer interface
Custom formatting and display in the list control
Using the History list control
Testing the History list control
Building the ProductList control
Using XML DOM to store and retrieve product selection
Using the ProductList control
Testing the ProductList control
Building a paged listing of accounts
Paging in SQL Server CE
Paging in Oracle Lite
Building a paging user control
Creating a context menu for the paging user control
Launching the accounts listing page
Testing the accounts listing page
Summary
4. Building Search Functionality
A brief walk-through of parameterized search
Building the parameterized search feature
Creating the parameterized search query in SQL Server CE
Creating the parameterized search query in Oracle Lite
Encapsulating the retrieved Dataset using business objects
Building the parameterized search forms
Building the search form
Building the search results listing form
Trying out your code
A brief walk-through of full-text search
Building the full-text search feature
Creating the Keyword Extractor classes
A sample keyword extractor—the HTML Keyword Extractor
Indexing the file
Creating the full-text search query for SQL Server CE
Creating the full-text search query for Oracle Lite
Encapsulating the retrieved dataset using business objects
Creating the full-text search forms
Trying out the full-text search
Improving the full-text search engine
Summary
5. Building Integrated Services
Sending SMS and e-mail from your application
Sending SMS and e-mail directly through code
Delegating to the default Windows Mobile Compose UI
Intercepting incoming SMS
Intercepting an SMS message
Placing phone calls from your application
Detecting incoming phone calls
Populating the History tab in the sales force application
Creating the data tier functions to insert historical records
Encapsulating SMS functionality
Encapsulating phone functionality
Intercepting incoming SMS messages and phone calls in the background
Handling outgoing SMS messages and phone calls
Testing your code
Synchronizing with Windows Mobile Contacts
Synchronizing with Windows Mobile Tasks
Sharing an account between two devices
Sharing an account between two devices using Infrared (IrDA)
Sharing an account between two devices using Bluetooth
Capturing handwritten input using the Smart Device Framework
Summary
6. Data Synchronization
Overview of the different data synchronization methods available for Microsoft SQL Server CE
SQL Remote Data Access (SQLRDA)
Merge replication
Microsoft Synchronization Services
Overview of the different data synchronization methods available for Oracle Lite
Oracle Mobile Server
A quick comparison between the various Synchronization frameworks
Using Microsoft Synchronization Services
Setting up Microsoft SQL Server and Microsoft Synchronization Services
Creating the CRMLive server tables
Creating the WCF service
Configuring the WCF service library
Setting filters for the Sync
Configuring the client project
Writing the sync code
Conflict resolution
Using Oracle Mobile Server
Installing Oracle Database Enterprise 11g and Oracle Mobile Server
Creating an Oracle Mobile repository
Creating the CRMLive server tables
Creating a new publication using the Mobile Database Workbench
Creating a new mobile project
Adding publication items to your project
Adding sequence items to your project
Adding a publication to your project
Publishing the mobile application to the mobile server
Setting up application users using the WebToGo portal
Registering the mobile device with the mobile server
Synchronizing with the mobile server
Synchronizing files with the server
Creating network-aware synchronization modules
Summary
7. Optimizing for Performance
Measuring performance
Measuring .NET CF code performance
Capturing application performance statistics
Optimizing database performance
Data caching
Using database indexes to boost search performance
Other database optimization tips
Optimizing data transfer performance
Managing better code
Managing better strings
Managing better Winforms
Using BeginUpdate and EndUpdate
Using SuspendLayout and ResumeLayout
Load and cache forms in the background
Managing better XML
Using XMLTextReader and XMLTextWriter
XML serialization and deserialization thesis
Managing better files
The .NET Compact Framework garbage collector
Summary
8. Securing the Application
Encrypting the database
Encrypting the SQL Server CE database
Encrypting the Oracle Lite database
Authenticating the sales force application
Performing one-way encryption using SHA256
Writing the code for authentication
Loading the login form
Encrypting data for inter-device transmission using AES
Summary
9. Globalization
Supporting double-byte languages
Supporting Japanese character input in Windows Mobile
Supporting Unicode at the application level
Designing culture-sensitive forms
Retrieving culture information
Summary
10. Building the Dashboard
An overview of the dashboard
Creating the web service
Creating the dashboard smart client
Connecting to the web service
Creating the line chart
Creating the round gauge
Creating the bar chart
Summary
11. Building the Support Case System
Introduction to MSMQ and the support case system
Setting up MSMQ on your mobile device
Writing your first MSMQ application
Setting up MSMQ on your server
Creating a queue on the server manually using the computer management panel
Sending a message from the server to a remote mobile device
Sending data to a remote queue
Creating the server-side application
Creating the client-side application
Sending a message from the mobile device to the server
Writing the client-side code
Writing the server-side code
Summary
12. Testing and Debugging
Overview of Power Toys for .NET CF 3.5
Installing Power Toys for .NET CF 3.5
Using the Remote Performance Monitor and GC Heap Viewer tool
Memory leaks and their causes
A sample application with memory leak
Using the Remote Performance Monitor tool to view application statistics in real time
Using PerfMon to graphically view runtime performance statistics
Using the GC Heap Viewer tool to detect memory leaks
Resolving the memory leak
Using the CLR Profiler tool
A sample application with bad performance
Launching the application with the CLR Profiler tool
Inspecting the Histogram view
Inspecting the Allocation Graph
Inspecting the Time Line view
Inspecting the Call Tree view
Using the App Configuration tool
Using the ServiceModel Metadata tool
Using the Remote Logging Configuration tool
Using the Network Log Viewer tool
Summary
13. Packaging and Deployment
Deploying your solution as a CAB file
Adding the SalesForce application files to your CAB project
Configuring other miscellaneous settings
Deploying your solution as an MSI file
Creating an INI file
Creating the custom action DLL
Creating the MSI installer project
Creating an automated update service
Creating the server-side web service
Creating the client-side updater tool
Summary
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
.NET Compact Framework 3.5 Data-Driven Applications
.NET Compact Framework 3.5 Data-Driven Applications
Edmund Tan
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset