Windows Mobile development: creating databases and tables

Using system;
Using system. Collections. Generic;
Using system. componentmodel;
Using system. Data;
Using system. drawing;
Using system. text;
Using system. Windows. forms;
Using system. Data. sqlclient;
Using system. Data. sqlserverce;
Using system. net;
Using system. IO;

Namespace winappgrid
{
Public partial class form1: Form
{
Public form1 ()
{
Initializecomponent ();
}
// Create a database table
Private Boolean createtable ()
{
Try
{
Sqlceconnection myconn = new sqlceconnection ("datasource = mysdf. SDF ");
Sqlcecommand COM = new sqlcecommand ("create table pc (pcno nvarchar (10) primary key, XH nvarchar (10) Not null, werks nvarchar (4) not null, pc_date nvarchar (10 ))");
Myconn. open ();
Com. Connection = myconn;
Com. executenonquery ();
Myconn. Close ();
MessageBox. Show ("the database is created successfully! ");
Return true;
}
Catch (exception ex)
{
MessageBox. Show ("failed to create database" + ex. tostring (). substring (1, 60 ));
Return false;
}



}

 

Private void button#click (Object sender, eventargs E)
{
// Create a database
Try
{
If (file. exists ("mysdf. SDF "))
{
MessageBox. Show ("the database already exists ");

}
Else
{
Sqlceengine Eng = new sqlceengine ("datasource = mysdf. SDF ");
Eng. createdatabase ();
Eng. Dispose ();
MessageBox. Show ("database created successfully ");


}
Boolean RTU;
RTU = createtable ();
If (RTU = false)
{
MessageBox. Show ("the data table already exists! ");

}
Else
{
MessageBox. Show ("data table created successfully! ");


}

}
Catch (exception ex)
{
MessageBox. Show ("failed to create database" + ex. tostring (). substring ));

}

}

}
}