SQL Server CE Programming with Pocket PC and Visual Studio.NET 2003: Databases and Tables - Creating SQL Server CE databases and tables on Pocket PC programmatically: deployment
(Page 3 of 4 )
Before proceeding with the following steps, make sure that you completed all the steps in the previous section.
- Execute your application by pressing F5 and you should be looking at something like the following image (Fig2).
- If necessary, you can also click the “Set As Default” button and switch off the check box to not to show in the future.
- Finally click on “Deploy.”
- After a few seconds, you can observe the installation of the .NET Compact Framework and SQL Server CE installation (which is after the .NET Compact Framework).
- Finally, after few more seconds, we will see our application with the button. Once you click on that button, it simply shows a message something like the one in the following image (fig3).
The above process gets repeated every time you execute your application. If you face any deployment errors, just close any existing emulators and try pressing F5 again (without switching on emulators manually by yourself).
Where is the database and table? You need to open the database “emp.sdf” (by simply clicking on it) available in root (or at “My Device”). Once you open it, it simply gives you a "wrong password" message and prompts for the password to open. You provide the password as specified in the previous source code. Once everything is successful, you should be able to see the database and table as something like the following image (fig4):
If you don’t know how to open the database, I suggest that you go through my previous article.
Next: Creating SQL Server CE databases and tables on Pocket PC programmatically: explanation >>
More MS SQL Server Articles
More By Jagadish Chaterjee
