Developing SQL Server CE based Pocket PC Applications using Visual Studio.NET - Where did the installation actually take place in the Pocket PC?
(Page 4 of 5 )
Don't just be happy after your deployment! We need to really understand where our applications actually were installed.
Let us check where our "SmartDeviceApplication1" was installed in the Pocket PC. Go through the following steps:
- Within the "Pocket PC" emulator, click on Start -> Programs. You should be able to see the "File Explorer" icon as follows (fig8).

- Click on the "File Explorer" icon. You will be taken to "My Documents" (by default) as shown in the following image (Fig9).

- You click on "My Documents" (boxed off in red in the above image) and select "My Device."
- Once you see "My Device" at the top, proceed by clicking on green marks (and try to observe the red marks) as shown in the following image (fig10). In fact, you are simply clicking on MyDevice -> Program Files -> SmartDeviceApplication1->SmartDeviceApplication1.exe.

Now, as you understand our application and where it stays, we need to search for the SQL Server CE folder. Actually, it is pretty simple; once you search, you should be able to find something like the following (fig11):

You can play with the "Query Analyzer" (shown in the above figure) to create and work with SQL Server CE databases.
Next: Creating an SQL Server CE database programmatically >>
More MS SQL Server Articles
More By Jagadish Chaterjee