book

Microsoft® .NET Compact Framework (Core Reference)

by Andy Wigley, Stephen Wheelwright, Robert Burbidge, Rory MacLoed, Mark Sutton

January 2003

Intermediate to advanced

896 pages

19h 58m

English

Microsoft Press

Read now

Unlock full access

Microsoft® .NET Compact Framework (Core Reference)
SPECIAL OFFER: Upgrade this ebook with O’Reilly
A Note Regarding Supplemental Files
Dedication
Acknowledgments
Introduction
System Requirements
Sample Code
Support
I. .NET Compact Framework Architecture
1. Introducing the .NET Compact Framework
A Brief History of Smart Mobile Computing DevicesBeginnings of Portable ComputingPSION Invents the Personal OrganizerPDA Market ExpandsMicrosoft and Handhelds

Microsoft .NET
Before .NET.NET Is a Better COMIs That It?.NET and Mobility.NET Compact FrameworkSQL Server CEASP.NET Mobile ControlsMobile Information Server
.NET Compact Framework Target Platforms
Platforms That Run ItAnd Platforms That Don’t
Developer Tools
Visual Studio .NET 2003eMbedded Visual Tools Version 3eMbedded C++ Version 4Getting Started with Smart Device Projects in Visual Studio .NETDifferences between Smart Device and PC Application ProjectsCreating a Smart Device Application ProjectSmart Device Application WizardManaging Your ProjectHelp SystemCreating a Hello World ApplicationCreate a Smart Device Application ProjectModify the ProjectUsing the EmulatorRequirement for Development PC to Be on a NetworkUsing the Pocket PC EmulatorUsing the Windows CE .NET Emulator
Unique Challenges Facing Mobile Developers
Get Data to Your DeviceXML Web ServicesSQL Server CEResource-Constrained DevicesSecurity Implications
Summary
2. .NET Framework Fundamentals
.NET Compact Framework Execution EnvironmentCommon Language RuntimeManaged Code and Native CodePortable Execution Environment?Application Domain HostsApplication DomainsVerifiable Type-Safe ExecutionJIT Compilation Not Interpreted!Garbage CollectionRich Exception HandlingRemote DebuggingAssemblies
Working with Class Objects
Constructors and FinalizersReleasing Resources with IDisposableThe C# using StatementDelegates and Events
.NET Compact Framework Class Libraries
Class Library StructureSystem.ObjectValue and Reference TypesElementary Data TypesLanguage InteroperabilityCommon Language SpecificationPrimary Differences from the Full .NET FrameworkApplication Configuration FilesCOM InteropInternet DeploymentNgen.exeReflection EmitRemotingSerializationSystem.CodeDom NamespaceSupport for PrintingVisual Basic File I/OWeb FormsXPath/XSLT
Summary
II. Developing Applications with the .NET Compact Framework
3. GUI Development with Windows Forms
Introducing the System.Windows.Forms Namespace
Creating Windows Forms
The Forms DesignerWindows Forms Target Platform DifferencesPocket PC ProjectsWindows CE .NET Projects
Comparing Forms Behavior in the .NET Framework and the .NET Compact Framework
AcceptButton and CancelButtonAutoScrollAnchorIsMdiContainerKeyPreviewTabIndex and TabStopKeyboard EventsPaint and Resize EventsSupported and Unsupported ControlsGraphics Support
Exploring Windows Forms Controls
Creation of ControlsMembers of ControlsPropertiesMethodsEventsProperty and Event Settings.NET Compact Framework ControlsThe Button ControlThe CheckBox ControlThe ComboBox ControlThe ContextMenu ControlThe DataGrid ControlDetermining the User’s SelectionFormatting DataGrid OutputThe DomainUpDown ControlThe HScrollBar and VScrollBar ControlsThe ImageList ControlThe Label ControlThe ListBox ControlThe ListView ControlThe MainMenu ControlThe NumericUpDown ControlThe OpenFileDialog and SaveFileDialog ControlsThe Panel ControlThe PictureBox ControlThe ProgressBar ControlThe RadioButton ControlThe StatusBar ControlThe TabControl ControlThe TextBox ControlThe Timer ControlThe ToolBar ControlThe TrackBar ControlThe TreeView Control
Summary
4. Building Windows Forms Applications
Working with FormsSetting Properties of the Form ClassKeeping to Form Display GuidelinesCreating Custom Dialog BoxesUsing Built-In Dialog Boxes
Working with the InputPanel Control
Using the MainMenu Control
Using the ToolBar Control
Programming Form Activation and Deactivation on Pocket PC
Programming Activate and DeactivateProgramming Form CloseClosing of Applications by the Pocket PC Shell
Handling the Tap-and-Hold Event
Handling Pocket PC Hardware Keys
Giving an Application Its Final Touches
Associating an Icon with Your ApplicationAdding a Shortcut to the Start Menu
General Design Guidelines
Summary
5. Testing and Debugging
Detecting and Correcting Programming Errors
Using the Debugger
Debugging an Example ApplicationUnderstanding Default Exception HandlingHandling Exceptions in the Debugger
Drawing on Debugger Features
Entering Break ModeCreating a BreakpointWatching Variables and ExpressionsCommand WindowWatch WindowDataTipsStepping Through an ApplicationContinuing a Program from Break ModeTerminating a ProgramRemoving BreakpointsSetting More Complex BreakpointsBreakpoints with ConditionsBreakpoints with CountersDisabled BreakpointsStarting Applications Without Debugging
Unsupported Debugger Features
Tracing Output from an Application
Using Assertions Within an Application
Handling Exceptions in the Debugger
Controlling Release Code Size
Generating Longer Error Messages in Exceptions
Adopting Strategies for Testing and Debugging
Configuring the Emulator from Visual Studio
Starting the Emulator Manually
Using Emulator Skins
Using Image FilesEmulating Hardware ButtonsStarting the Emulator with a Skin File
Summary
6. Completing and Distributing Your Application
Choosing Project SettingsUsing the File Build Action PropertyAssociating an Icon with Your ApplicationSetting the Deployment Directory
Packaging Your Application
Creating Processor-Specific CAB FilesBuilding CAB Files Using Visual Studio .NETBuilding CAB Files Using CAB WizardUsing the Resource File GeneratorUnderstanding the Configuration FileConfiguration File Directory IdentifiersDescription of the Version SectionApplying the CEStrings SectionUsing the Strings SectionDescription of the CEDevice SectionSpecifying the DefaultInstall SectionDefining the SourceDisksNames SectionDefining the SourceDisksFiles SectionSpecifying the DestinationDirs SectionUsage of the CopyFiles SectionDescription of the AddReg SectionUsage of the CEShortCuts Section
Distributing Your Application
Installing the .NET Compact FrameworkDeploying from a Web SiteDeploying from a File ShareDeploying from Another DeviceDeploying with Memory Storage CardsDeploying Through ActiveSyncCreating an Application Manager Initialization File
Using Trickle-Feed Deployment
Installing Assemblies into the Global Assembly Cache
Understanding Strong-Named AssembliesSigning an Assembly with a Strong NameUsing Side-by-Side VersioningVersion Policy
Summary
III. Common Programming Tasks
7. Working with Collection Classes
Introducing the .NET Framework Collection Classes
Using Simple Arrays
Initializing Arrays of Reference TypesWorking with Multidimensional ArraysRectangular ArraysArrays of ArraysConverting Array Types
Using the .NET Compact Framework Collections
Creating an ArrayList CollectionStoring Key-and-Value Pairs Using a Hashtable CollectionUsing the Stack ClassStoring Elements with a ListDictionary CollectionUsing the HybridDictionary CollectionStoring String Key-and-Value Pairs with NameValueCollection
Sorting Objects in Collections
Sorting with IComparableImplementing Multiple Sort Orders with IComparer
Creating Your Own Collections
Summary
8. Working with Dates and Strings
Understanding the String ClassUsing StringsCreating and Comparing StringsCreating Strings from Other StringsSearching StringsModifying StringsUsing String Utility MethodsDifferences from the Full .NET Framework String ClassUsing the CharEnumerator Class
Using the StringBuilder Class
Using StringBuilder Methods and PropertiesDifferences from the Full .NET Framework StringBuilder ClassUsing the EnsureCapacity MethodUsing the Replace Method
Using Dates
Constructing DatesUsing DateTime PropertiesUsing DateTime Arithmetic MethodsUsing DateTime Utility MethodsUsing DateTime OperatorsDifferences from the Full .NET Framework
Using Regular Expressions
Understanding Regular ExpressionsUsing Simple Regular Expression Matches and the Match ObjectProcessing Multiple Matches with the MatchCollection ObjectUsing Groups and CapturesReplacing Text PatternsUsing the Split Method
Formatting Strings for Output
Understanding Concepts and TerminologyWorking with Format SpecifiersUsing Format SpecifiersClassifying Format SpecifiersUsing Standard Numeric Format SpecifiersUsing Custom Numeric Format SpecifiersFormatting Dates and TimesUsing Enumerated Type FormattingUsing Format Specifications and the String.Format MethodUnderstanding Format ProvidersUsing Cultural Settings with Date Formats
Parsing
Resolving Parsing IssuesParsing Dates
Summary
9. Working with XML
Using XML in the .NET Compact Framework
Differences from the Full .NET Framework
Reading XML with the XmlReader Class
Understanding the XmlTextReader ClassConstructing an XmlTextReader ObjectReading an XML Document with the XmlTextReader ClassDisregarding Unnecessary NodesReading Attribute NodesHandling Namespaces with XmlTextReaderDealing with Validation, DTDs, and EntitiesHandling Comment NodesHandling CDATA Nodes
Writing XML with the XmlWriter Class
Writing an XML Document with the XmlTextWriter ClassConstructing an XmlTextWriterWriting XML DataHandling Namespaces with XmlTextWriter
Processing XML with the XmlDocument Class
Understanding the XmlDocument ClassDifferences from the Full .NET FrameworkReading XML with the XmlDocument ClassNavigating an XML DocumentHandling NamespacesAccessing Element ValuesAccessing AttributesAccessing Other Types of XmlNodeReading XML from an XmlNodeSearching an XML Document with GetElementsByTagNameModifying an XML DocumentModifying ValuesAdding an ElementAdding an AttributeRemoving Elements and AttributesSaving an XML Document
Summary
10. Input and Output
Understanding the Stream ClassCreating a FileStream ObjectSpecifying File Access Modes for StreamsSpecifying File Sharing for StreamsReading and Writing Bytes Using a FileStream ObjectUsing the BinaryReader and BinaryWriter ClassesSeeking on StreamsLocking FilesUsing the NetworkStream ClassHandling Network Errors When Using NetworkStreamPerforming Asynchronous Read/Write Operations on NetworkStream ObjectsUsing the MemoryStream ClassImplementing a Product Ordering Example
Using the StreamReader and StreamWriter Classes
Creating StreamReader and StreamWriter ObjectsReading a File Stream with a StreamReader ObjectUsing Encodings with StreamReader and StreamWriter ObjectsSpecifying Byte Ordering When Using EncodingsWriting to a File Stream with StreamWriter
Processing Strings with StringReader and StringWriter
Using the File, Path, and Directory Classes
Using the File Class to Create a FileUsing the Directory ClassDifferences from the Full .NET FrameworkUsing the Path Class
Summary
11. Networking
Using the System.Net Namespace
Using the WebRequest and WebResponse Classes
Understanding WebRequest and WebResponse BasicsFetching a Resource Using HTTPHandling ErrorsWorking with HTTP HeadersNetwork Transfer EncodingSending Data to the Server with HTTP GET and HTTP POSTUsing HTTP GET Query StringUsing HTTP POSTAlternatives to Cookies for Session State SupportSecuring Network Transfers with SSLAuthenticating Requests with the NetworkCredential ClassAsynchronous Web RequestsMaking Network Requests via a Proxy Server
Determining Whether the Device Is Connected
Working with Sockets
Understanding Your IP Network While Using the Emulators and ActiveSyncPerforming DNS LookupsUsing System.Net.Sockets.TcpListenerUsing System.Net.Sockets.TcpClientUsing System.Net.Sockets.UdpClientUsing the Socket ClassUsing Sockets for Synchronous OperationsUsing Sockets for Asynchronous OperationsHandling Errors with SocketsInfrared CommunicationsDiscovering InfraRed Devices with IrDAClient.DiscoverDevicesListening for Infrared Connections with IrDAListenerMaking Infrared Connections with IrDAClient
Serial Communications
Summary
12. .NET Compact Framework Application Security
Considering the Basics of Handheld Device SecurityContemplating User AuthenticationUsing Antivirus SoftwareEmploying Firewalls
Securing Wireless Data Transmission
Using Virtual Private NetworkingUsing SSLPreventing Spoofing
Authenticating and Authorizing Mobile Clients
Supplying Logon Credentials in .NET Compact Framework ApplicationsGiving Mobile Users Appropriate Authorization
Securing XML Web Services
Using Custom Authentication with SOAP Headers
Securing SQL Server CE Connectivity
Securing Data on the Device
Using Cryptography on a Handheld DeviceSecuring SQL Server CE Databases
Programming .NET Compact Framework Security
Understanding the .NET Compact Framework Security PolicyEmploying Secure Coding PracticesStoring User Names and Passwords in CodeAvoiding Malicious Downloads
Summary
IV. Connecting with Data
13. Accessing Data
Caching, Replicating, and Resolving ConflictsCachingEmploying Change ReplicationDealing with Conflict Resolution
Avoiding Replication
Synchronizing Data in Mostly Disconnected Solutions
Synchronizing with ActiveSync File ReplicationSynchronizing with SQL Server CE RDASynchronizing with SQL Server 2000 Merge Replication
Synchronizing Data in Mostly Connected Solutions
Accessing SQL Server 2000 DirectlyImplementing Mobile Web ApplicationsUsing Web Services
Employing Other Network Solutions
Working with SocketsExploiting Infrared Light
Summary
14. ADO.NET Data Objects
Recognizing the Advantages of ADO.NETADO.NET Is ConnectionlessADO.NET Is Centered on XMLADO.NET Enables Data Binding
Introducing the ADO.NET Objects
Understanding the DataSet ObjectRepresenting Data TablesDefining Relations with the DataRelation ObjectUnderstanding the DataView Object
Building a DataSet Object from Scratch
Adding the DataSet, DataTable, and DataColumn ObjectsAdding DataRow ObjectsReading, Updating, or Deleting a DataRow ObjectFinding a DataRow ObjectViewing the XML Representation of a DataSet ObjectUsing Typed DataSet ObjectsCreating a DataSet Object with the DataSet DesignerLoading a Saved Schema
Using Multitable DataSet Objects
Defining Relations in a Multitable DataSet ObjectAdding a Relation with XML Schema DesignerAdding the Relation in CodeNavigating the Relation in CodeSetting Constraints in a DataRelation Object
Saving a DataSet Object Locally
Writing the DataReading the DataPutting It All Together
Working with Updates, Data Views, and Data Binding
Tracking DataSet UpdatesUnderstanding Row StatesUnderstanding Row VersionsWorking with the DataView ObjectUsing the Sort PropertyUsing the RowFilter PropertyUsing the RowStateFilter PropertyCommiting ChangesExamining Data BindingUnderstanding Simple Data BindingUnderstanding Complex Data BindingCreating Data Bindings in CodeWorking with Default Data ViewsTracking the Current Row in a DataGridImplementing a Data Binding Sample
Summary
15. Integrating Data with SQL Server
Examining Data Access ArchitectureUsing the SQL Server 2000 Managed ProviderUnderstanding Differences from the Desktop .NET FrameworkUsing Forms DesignerImplementing TransactionsEstablishing ConnectionsIntroducing the System.Data.SqlClient NamespaceIntroducing the SqlConnection ObjectIntroducing the SqlCommand ObjectIntroducing the SqlParameter ObjectIntroducing the SqlDataReader ObjectIntroducing the SqlDataAdapter ObjectIntroducing the SqlCommandBuilder ObjectIntroducing the SqlException and SqlError Objects
Retrieving Data
Creating a SqlConnection ObjectConnecting to an Instance of SQL ServerSpecifying Security OptionsUsing the SqlCommand ObjectUsing the SqlDataReader ObjectUsing the SqlException Object
Binding Data
Using the DataSet and SqlDataAdapter Objects
Updating Data
Updating Bound DataUsing SqlCommandBuilderHandling the Update ProcessHandling Update EventsHandling Update Exceptions
Using SQL Server Stored Procedures
Using Transactions in the .NET Compact FrameworkUsing Stored Procedures That Get DataReturning Result SetsReturning ScalarsReturning Multiple Result SetsUsing Stored Procedures with ParametersCreating Input ParametersCreating Output ParametersAccessing Return ValuesExecuting Stored Procedures That Do Not Return Data
SQLXML
Using SQLXML in an ApplicationFurther Reading
Summary
16. Working with XML Web Services
XML Web Services Architecture
XML Web Services Infrastructure
XML Web Services DirectoriesXML Web Services DiscoveryXML Web Services DescriptionXML Web Services Wire Formats
Outline of an XML Web Service at Work
The XML Web Service ClientThe Web Service at Run Time
Compact Framework Limitations
A Simple XML Web Service
A Client for the Simple XML Web Service
Web ReferenceProxy GenerationProxy Class Allows Dynamic Web Service URLXML Web Service Consumption
A Web Service That Returns a Dataset
The TimesheetService Web ServiceAn XML Web Service Client with a Typed DatasetTechniques for Changing a Web Service to Use Standard DatasetsWeb Service Client with a Standard DatasetAsynchronous Operation
Procedure for Returning a Dataset for Update
Design Considerations for XML Web Services
Summary
17. Using SQL Server CE
Using SQL Server on a Smart DeviceGetting Data to and from SQL Server
Programming a SQL Server CE Application
Introducing SqlServerCe Data Programming ObjectsCreating a Local Database in CodeAdding Data Using SQLRetrieving Data RowsUsing the SqlCeDataReader ClassUsing a Dataset and Data BindingUsing the SqlCeCommand Object with ParametersUpdating with Data Binding
Programming Remote Data Access
Introducing RDA ArchitectureInstalling RDA ServerInstalling the SQL Server CE Server AgentConfiguring RDA SecurityPulling Data into a Local DatabaseUsing RDA PullTracking OptionsUnderstanding RDA Pull Data Type ConversionsMaking Changes to a Pulled TablePushing Changes Back to the Remote DatabaseUsing Optimistic ConcurrencyUsing the Push methodExamining the RDA Errors TableRunning Commands on the Remote DatabaseTroubleshooting RDA
Using Merge Replication
Introducing Merge Replication ArchitectureSetting Up Merge ReplicationSetting Up the PublicationSetting Up the Web ServerUnderstanding Merge Replication SecurityProgramming Merge ReplicationAdding a SubscriptionSynchronizing DataTroubleshooting Merge Replication
Choosing Between RDA and Merge Replication
Summary
V. Advanced Mobile Application Development
18. Custom Controls
Inheriting from a Toolbox Control
Inheriting from the Control Class
Creating a Clickable Label Control
Adding Custom Events: SlideShow
Adding a Custom Event to the ControlEnhancing the SlideShow Control with a Timer
Placing a Custom Control in Its Own Assembly
Creating a Component
Creating a Design-Time Custom Control
Creating a Designer Version of a Custom ControlDifferences Between the Full .NET Framework and the .NET Compact FrameworkConnecting the Design-Time Assembly to the .NET Compact Framework RuntimeSpecifying a Designer for the ClassBuilding and Deploying the Design-Time ControlAdding the Control to the Toolbox
Summary
19. Globalization and Localization
Cultures and the CultureInfo ClassThe CultureInfo ClassDetermining the Current CultureCreating a New CultureInfo Instance
Data for Specific Cultures
Numbers for Specific CulturesCulturally Aware String ComparisonsDate and Time Values for Specific CulturesHandling Time ZonesUsing Alternative Calendars
Character Encoding
Localized Resource Files
Localized Resource CreationLocalized Resource Retrieval
Summary
20. Multithreading
Understanding MultithreadingUnderstanding the Advantages of MultithreadingAvoiding Pitfalls in Multithreading
Scheduling
Creating a Multithreaded Application
Constructing a new Thread ObjectPutting a Thread to SleepUsing TimersUsing Thread Pools
Synchronizing Threads and Thread Safety
Determining What Memory Is Used by ThreadsUnderstanding Thread SafetyExploring Synchronization Features of the .NET Compact FrameworkUsing the Monitor ClassUsing the Mutex ClassUsing the ManualResetEvent and AutoResetEvent ClassesUsing the Interlocked ClassAvoiding DeadlocksCreating Thread-Safe Wrappers
Using Multithreading with Controls
Comparing the Two Frameworks
Setting Thread PrioritiesUsing the Join MethodUsing the Suspend and Resume MethodsUsing Application DomainsUsing the Thread Class’s Abort and Interrupt MethodsUsing the ReaderWriterLock ClassEmploying Background ThreadsUsing the SynchronizationAttribute Class
Summary
21. Graphics Programming
Classes for Graphics Programming
Classes Used to Draw Shapes, Bitmaps, and Text
The Pen ClassThe SolidBrush ClassThe Color ClassThe Font ClassThe Icon ClassThe Bitmap ClassThe Point StructureThe Rectangle StructureThe Region Class
Graphics Class Drawing Methods
The DrawImage MethodThe DrawIcon MethodThe FillRegion MethodThe DrawRectangle and FillRectangle MethodsThe DrawLine MethodThe DrawString MethodThe DrawEllipse and FillEllipse MethodsThe DrawPolygon and FillPolygon Methods
The OnPaint Method
Summary
22. Interoperating with Native Code
Understanding Managed and Unmanaged Code
Writing Custom Unmanaged DLLs
Choosing an eMbedded Visual C++ 4 Project TypeSpecifying Processor-Specific OptionsDealing with C++ Name ManglingExporting Entry PointsUsing DUMPBIN to Determine Entry PointsDeploying Unmanaged DLLsEnsuring Compatibility with Different Windows CE Versions
Using P/Invoke
Declaring an Unmanaged Code FunctionDeclaring Unmanaged Code Functions Using C#Declaring Unmanaged Code Functions Using Visual Basic .NETCalling the Unmanaged Code FunctionHandling Run-Time ErrorsDealing with Special Cases: The EntryPoint PropertyMarshaling ParametersMarshaling Value and Reference TypesPassing Value ParametersMarshaling Alternative TypesUsing Directional AttributesWorking with Symbolic Constants and Enumerated TypesProcessing Reference TypesPassing ArraysPassing String and StringBuilder VariablesPassing Structures and ClassesMarshaling More Complex StructuresCalling ConventionsUsing Callbacks and DelegatesMarshaling DateTime Objects
Calling the Windows CE API
Retrieving Windows Error CodesUnderstanding the MessageWindow ComponentUsing MessageWindow and Sending MessagesCalling from Unmanaged Code to Managed CodeIntercepting Messages Using MessageWindow
Calling COM Objects
Using Wrapper Functions for COM Objects
Developing a Simple COM WrapperMaintaining State with a COM Wrapper
Summary
23. Migrating eMbedded Visual Tools Applications and Cross-Framework Development
Migrating eMbedded Visual Tools ApplicationsBinary CompatibilityLanguage ChangesUser Interface Programming ModelActiveX ControlsUser Interface and Business Logic DecoupledTransitional ArrangementsDatabasesCOM Interoperability
Writing Cross-Framework Applications
Retargetable AssembliesRun-Time Determination of the Operating SystemConditional Compilation
Summary
A. .NET Compact Framework Base Class Libraries
Microsoft.VisualBasic Namespace
Microsoft.WindowsCE.Forms Namespace
System Namespace
System.CodeDom Namespace
System.Collections Namespace
System.Collections.Specialized Namespace
System.ComponentModel Namespace
System.ComponentModel.Design Namespace
System.Configuration.* Namespaces
System.Data Namespace
System.Data.Common Namespace
System.Data.Odbc Namespace
System.Data.OleDb Namespace
System.Data.SqlClient Namespace
System.Data.SqlServerCe Namespace
System.Data.SqlTypes Namespace
System.Diagnostics Namespace
System.DirectoryServices Namespace
System.Drawing Namespace
System.Drawing.Design Namespace
System.Drawing.Drawing2D Namespace
System.Drawing.Imaging Namespace
System.Drawing.Printing Namespace
System.Drawing.Text Namespace
System.EnterpriseServices Namespaces
System.Globalization Namespace
System.IO Namespace
System.Management Namespaces
System.Messaging Namespace
System.Net Namespace
System.Net.Sockets Namespace
System.Reflection Namespace
System.Resources Namespace
System.Runtime.CompilerServices Namespace
System.Runtime.InteropServices Namespace
System.Runtime.Remoting Namespaces
System.Runtime.Serialization Namespaces
System.Security Namespace
System.Security.Cryptography.X509Certificates Namespace
System.Security.Permissions Namespace
System.Security.Policy Namespace
System.ServiceProcess Namespace
System.Text Namespace
System.Text.RegularExpressions Namespace
System.Threading Namespace
System.Timers Namespace
System.Web Namespaces
System.Web.Services Namespace
System.Web.Services.Description Namespace
System.Web.Services.Protocols Namespace
System.Windows.Forms Namespace
System.Windows.Forms.Design Namespace
System.Xml Namespace
System.Xml.Schema Namespace
System.Xml.Serialization Namespace
System.Xml.XPath Namespace
System.Xml.Xsl Namespace
B. About the Author
SPECIAL OFFER: Upgrade this ebook with O’Reilly

Content preview from Microsoft® .NET Compact Framework (Core Reference)

Chapter 17. Using SQL Server CE

This chapter describes how to program a smart device application to work with a local SQL Server 2000 Windows CE Edition (SQL Server CE) database, and it discusses methods of creating the database and synchronizing it with a central or an enterprise SQL Server database. For example, a delivery service driver could download the day’s delivery schedule at a central depot at the start of a day into a local SQL Server CE database. During the day, the driver could use a smart device application to check the loading of goods and record the deliveries into the local SQL Server CE database. On returning to the depot after completing the day’s rounds, the driver could reconnect to the central database to coordinate stock ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Microsoft® .NET Compact Framework Kick Start

Publisher Resources

ISBN: 0735617252Catalog Page Errata

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® .NET Compact Framework (Core Reference)

by Andy Wigley, Stephen Wheelwright, Robert Burbidge, Rory MacLoed, Mark Sutton

Chapter 17. Using SQL Server CE

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

More than 5,000 organizations count on O’Reilly

Julian F.

Addison B.

Amir M.

Mark W.

You might also like

Microsoft® .NET Compact Framework Kick Start

Professional C# 5.0 and .NET 4.5.1

C# 5.0 Unleashed

Pro C# 7: With .NET and .NET Core

Publisher Resources