Developing SQL Server CE based Pocket PC Applications using Visual Studio.NET - Installing SQL Server CE onto a Pocket PC emulator: developing the application
(Page 2 of 5 )
Before proceeding with the following steps, make sure that you have "Smart Device Extensions" installed (which need to be selected during the Visual Studio.NET setup).
Let us begin now:
- Open Microsoft Visual Studio.NET 2003.
- Go to File -> New -> Project.
- Within the "New Project" Dialog, select "Visual Basic Projects" from the "Project Types" and "Smart Device Application" from the "templates" (as shown in Fig1).
- Currently, I left the name of the application "SmartDeviceApplication1." You can change it according to your requirements.
- Once you click "OK," you will be presented with the "Smart Device Application Wizard." Select "Pocket PC" as the platform of target and "Windows application" as "project type" (as shown in Fig2).
- Click "OK" to accept your settings. You will be presented with a form (very similar to a Visual Basic 6 form), where you can design with the controls available in the toolbox.
- Right click on your project and go to "Add References." Select "System.data.common" and "System.data.SqlServerCE" and click "select," then finally click on "OK" (as shown in Fig3).
- Drag a "Button" control from your toolbox onto the form and write the following code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles Button1.Click
MessageBox.Show("This app mainly used for deploying SQL
Server CE on to this mobile device")
End Sub
The above is not necessary. You can consider it a dummy. Our main intention is to have SQL Server CE deployed on the Pocket PC emulator. For that purpose, I need to have those two assemblies added to the project.
Next: Installing SQL Server CE onto a Pocket PC emulator: deploying the application >>
More MS SQL Server Articles
More By Jagadish Chaterjee
