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