Data (How Do I in Smart Devices)
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