.NET Xpress

Microsoft Technology Xplicit

SQLCE Demo

Posted by anandkumar2004 on May 7, 2009

There are several ways to setup SQLCE database in mobile device. I usually prefer SQL replication in this demo I am trying to create database and tables programmatically so when you launch the application it will create the database if it is not present in the device.

In order to make it more clear I have created a class called  SqlCeHelper. Primary objective of this class is
Create Database if not available
Establish connection on request
Insert data into table
Perform queries
Close database on request

I have also created two windows forms to add and view data. This is a very simple application, hope this will help to those who are trying to know how to work with SQLCE database

Click Here to down the source code

Cheers
Anand

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>