[Video] using SQL Server compact to create a simple Windows Application

This afternoon I recorded a SQL Server compact application.ProgramThe Quick Start video helps friends in the garden open the door for SQL Server compact development.

Technical Level: 100

Prerequisites: Visual Studio 2005, SQL Server 2005 mobile Developer Tools, SQL Server 2005 compact edition RC1

Content:
1. Create a Windows application named beginningwithssev for Visual C #.
2. Create an SQL Server mobile data connection and select the northwind. SDF database that comes with Visual Studio 2005.
3. Create a data source and select the Products table of the northwind database. Visual Studio 2005 automatically creates a northwinddataset strong dataset.
4. Select the Products table of northwinddataset in the data source form, and modify the display mode from the datagridview to details.
5. Drag the Products table from the data source form to form1. Visual Studio 2005 automatically creates related controls on form1.
6. Compile and run the beginningwithssev Project

Final effect:

Download video files and ExamplesCode

No program code is written manually throughout the demo. All the code is generated through Visual Studio 2005. If you want to understand the principles of the sample program, you also need to spend some time looking at its code.

SQL Server 2005 mobile developer tools is installed with Visual Studio 2005 by default. for SQL Server 2005 compact edition RC1, see SQL Server compact edition RC1.

If you have any questions or suggestions, please submit them here!