form1.cs

这是用c#开发的

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.SqlServerCe;
using System.IO;

namespace Sqlcetests
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            BindDataGrid();
        }

        private void BindDataGrid()
        {
            //SqlCeEngine eng = new SqlCeEngine("Data Source = \\DiskOnChip\\MyDatabase#1.sdf");
            //eng.CreateDatabase();
            //eng.Dispose();
            //SqlCeConnection con = new SqlCeConnection("Data Source = \\DiskOnChip\\MyDatabase#1.sdf");
            //con.Open();
            //SqlCeDataAdapter sda = new SqlCeDataAdapter("select * from Test", con);
            //sda.Fill(_MyDatabase_1DataSet);
            //this.dataGrid1.DataSource = _MyDatabase_1DataSet.Tables[0];
            //con.Close();
            string strSQLPath = "\\DiskOnChip\\MyDatabase#1.sdf";
            string strConString = "Data Source = \\DiskOnChip\\MyDatabase#1.sdf";
            if (File.Exists(strSQLPath))
            {
                // 删除数据库
                MessageBox.Show("数据库已存在！");
                return;
            }
            else
            {
                // 创建数据库
                SqlCeEngine engine = new SqlCeEngine(strConString);
                engine.CreateDatabase();
                engine.Dispose();
                //    MessageBox.Show("数据库创建成功！");

            }
            // 创建表id int(4),id int(4),
            if (File.Exists(strSQLPath))
            {

                SqlCeConnection cn = new SqlCeConnection(strConString);
                cn.Open();
                try
                {
                    string strSQL = @"CREATE TABLE employee(id nvarchar(9),name nvarchar(50),code nvarchar(10),bm nvarchar(50),zhch nvarchar(10),sex nvarchar(10),zhw nvarchar(10),chshdate nvarchar(50),gzdate nvarchar(50),state nvarchar(10),djdate nvarchar(50),djname nvarchar(50),yhmm nvarchar(50),zhqchbtime nvarchar(10))";
                    SqlCeCommand SqlCeCmd = new SqlCeCommand(strSQL, cn);
                    SqlCeCmd.ExecuteNonQuery();

                    strSQL = @"create table xhaihu(id nvarchar(9),khname nvarchar(50),number nvarchar(50),zhjm nvarchar(50),zhjh nvarchar(50),phone nvarchar(50),khsection nvarchar(50),khscname nvarchar(50),jiage nvarchar(10),address_lou nvarchar(10),address_dy nvarchar(10),address_shi nvarchar(10),bzh nvarchar(50),state nvarchar(10),khdate nvarchar(50),djname nvarchar(50),chbflag nvarchar(10))";
                    SqlCeCmd = new SqlCeCommand(strSQL, cn);
                    SqlCeCmd.ExecuteNonQuery();

                    strSQL = @"create table section(id nvarchar(9),sqname nvarchar(50),sqaddress nvarchar(50),sqcode nvarchar(10),sqstate nvarchar(10),djdate nvarchar(50),djname nvarchar(50))";
                    SqlCeCmd = new SqlCeCommand(strSQL, cn);
                    SqlCeCmd.ExecuteNonQuery();

                    strSQL = @"create table hmzhr(id nvarchar(9),hm_username nvarchar(50),hm_number nvarchar(50),hm_newusername nvarchar(50),hm_feiyong nvarchar(10),hm_fpnum nvarchar(50),hm_time nvarchar(50),hm_djname nvarchar(50))";
                    SqlCeCmd = new SqlCeCommand(strSQL, cn);
                    SqlCeCmd.ExecuteNonQuery();

                    strSQL = @"create table bjgl(id nvarchar(9),number nvarchar(50),biaohao nvarchar(50),bjsh nvarchar(10),zhq nvarchar(10),zhqtime nvarchar(10),state nvarchar(10),djdate nvarchar(50),hm_djname nvarchar(50))";
                    SqlCeCmd = new SqlCeCommand(strSQL, cn);
                    SqlCeCmd.ExecuteNonQuery();

                    strSQL = @"create table ChaoBiao(id nvarchar(9),number nvarchar(10),biaohao nvarchar(20),bcchb nvarchar(10),bcql nvarchar(10),price nvarchar(10),jine nvarchar(20),zhq nvarchar(10),dw nvarchar(10),state nvarchar(10),jfstate nvarchar(10),chbtime nvarchar(20),chboperator nvarchar(10),jftime nvarchar(20),jfoperator nvarchar(10),chbyear nvarchar(10),chbmonth nvarchar(10))";
                    SqlCeCmd = new SqlCeCommand(strSQL, cn);
                    SqlCeCmd.ExecuteNonQuery();

                    strSQL = @"create table yhqxb(id nvarchar(9),code nvarchar(10),ygadd nvarchar(10),ygmod nvarchar(10),ygdel nvarchar(10),khadd nvarchar(10),khmod nvarchar(10),khdel nvarchar(10),bjadd nvarchar(10),bjmod nvarchar(10),bjdel nvarchar(10),shqadd nvarchar(10),shqmod nvarchar(10),shqdel nvarchar(10),chaobiao nvarchar(10),jiesuan nvarchar(10),bjshzh nvarchar(10),gh nvarchar(10),qxchk nvarchar(10),qxxg nvarchar(10))";
                    SqlCeCmd = new SqlCeCommand(strSQL, cn);
                    SqlCeCmd.ExecuteNonQuery();
                    MessageBox.Show("数据库创建成功", "提示信息");
                }
                catch (SqlCeException ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    cn.Close();
                }
            }
            else
            {
                MessageBox.Show("创建数据库失败！");
            }
        }
    }
}