Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This page links to Help topics about common smart device data-handling tasks.
In General
How to: Generate SqlCeResultSet Code (Devices)
Describes how to generate ResultSets instead of DataSets.How to: Change the Design-Time Connection String (Devices)
Describes how to change the string that Visual Studio uses to connect to a SQL Server Compact 3.5 database at design time.How to: Change the Run-Time Connection String (Devices)
Describes how to change the string that the application uses to connect to a SQL Server Compact 3.5 database at run time.How to: Add Navigation Buttons (Devices)
Describes an alternative to the DataNavigator class, which is not supported in the .NET Compact Framework.How to: Persist Data Changes to the Database (Devices)
Describes how to apply changes in the DataSet back to the database.How to: Install SQL Server Compact 3.5 on a Device
Describes how to install the SQL Server Compact runtime on a device or emulator.
Adding Data Sources
How to: Create a Database (Devices)
Describes how to use the Visual Studio environment to create a SQL Server Compact 3.5 database, inside or outside a project.How to: Add a Database to a Device Project
Describes how to add a SQL Server Compact 3.5 database, available in Server Explorer, as a data source for a Visual Basic or Visual C# project.How to: Add a SQL Server Database as a Data Source (Devices)
Describes how to add a SQL Server database as a data source for a Visual Basic or Visual C# project.How to: Add a Business Object as a Data Source (Devices)
Describes how to add a business object as a data source for a Visual Basic or Visual C# project.How to: Add a Web Service as a Data Source (Devices)
Describes how to add a Web service as a data source for a Visual Basic or Visual C# project.
Managing Data Sources
How to: Manage Tables in a Database (Devices)
Describes how to add and remove tables, and how to edit an existing table schema.How to: Manage Columns in a Database (Devices)
Describes how to add and remove columns and to modify their properties.How to: Manage Indexes in a Database (Devices)
Describes how to add and remove indexes, and how to change their sort-order property.How to: Manage Passwords for a Database (Devices)
Describes how to set a password for a new SQL Server Compact 3.5 database and how to change a password for an existing database.How to: Shrink and Repair a Database (Devices)
Describes how to shrink and repair SQL Server Compact 3.5 databases.
Building Queries
How to: Create Parameterized Queries (Devices)
Describes how to create parameterized queries.Walkthrough: A Parameterized Query Application
Provides step-by-step instructions for an end-to-end project that includes building a parameterized query.
Processing Master-Detail Relationships
How to: Create Master-Detail Applications (Devices)
Describes how to implement a master-detail relationship.Walkthrough: A Master-Detail Application
Provides step-by-step instructions for an end-to-end project that includes creating and running a master-detail application.
Viewing and Editing Data
How to: Preview Data in a Database (Devices)
Describes several options for viewing data in a database.How to: Generate Summary and Edit Views for Data Applications (Devices)
Describes how to use data forms to view and modify single rows of data in a datagrid.
See Also
Concepts
How Do I in Smart Device Development
Other Resources
Working with Data in Managed Device Projects