MS SQL Server
  Home arrow MS SQL Server arrow Page 4 - Developing SQL Server CE based Pocket PC A...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MS SQL SERVER

Developing SQL Server CE based Pocket PC Applications using Visual Studio.NET
By: Jagadish Chaterjee
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 21
    2006-05-17

    Table of Contents:
  • Developing SQL Server CE based Pocket PC Applications using Visual Studio.NET
  • Installing SQL Server CE onto a Pocket PC emulator: developing the application
  • Installing SQL Server CE onto a Pocket PC emulator: deploying the application
  • Where did the installation actually take place in the Pocket PC?
  • Creating an SQL Server CE database programmatically

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    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.

    More MS SQL Server Articles
    More By Jagadish Chaterjee


       · Hello guys, contributed another on developing Pocket PC applications. Enjoy and give...
     

    MS SQL SERVER ARTICLES

    - Completing the Introduction to Transact-SQL
    - A Brief Introduction to Transact-SQL
    - Lookups and Blocking Bad Data
    - Field Validation Rules for Blocking Bad Data
    - Using Masks to Block Bad Data
    - Blocking Bad Data
    - Using @@ROWCOUNT and TABLE Variables for Dat...
    - How to Use Variables, IF and CASE in Databas...
    - Creating Important Aspects of Notification S...
    - Working wth Variables in Database Interactio...
    - Delving Deeper into Notification Services
    - Notification Services
    - Building a Multi-table Report with SQL 2005 ...
    - A Secure Way of Building Connection Strings
    - Transferring a Database Using the SSIS Desig...

     
    Application Delivery: Everything You Wanted to Know, but Didn`t Know You Needed to Ask
    A comprehensive guide to examining the topics of Wide-area Data Services and app....

     
    Best Practices: Safe and Secure Hardware Asset Recovery
    Companies increasingly must meet EPA and local requirements for the disposal of ....

     
    Managing SSL Security in Multi-Server Environments
    Read this white paper to learn how to simplify management of your organization's....

     
    Open Source Security Myths
    Open Source Software (OSS) is computer software whose source code is available t....

     
    Power and Cooling Capacity Management for Data Centers
    This paper describes the principles for achieving power and cooling capacity man....

     




    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
    Stay green...Green IT