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();
}
//創(chuàng)建數(shù)據(jù)庫的表
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("創(chuàng)建數(shù)據(jù)庫成功！");
return true;
}
catch (Exception ex)
{
MessageBox.Show("創(chuàng)建數(shù)據(jù)庫失敗" + ex.ToString().Substring(1, 60));
return false;
}
}
private void button1_Click(object sender, EventArgs e)
{
//創(chuàng)建數(shù)據(jù)庫
try
{
if ( File.Exists("mysdf.sdf"))
{
MessageBox.Show("數(shù)據(jù)庫已經(jīng)存在");
}
else
{
SqlCeEngine eng = new SqlCeEngine("DataSource=mysdf.sdf");
eng.CreateDatabase();
eng.Dispose();
MessageBox.Show("創(chuàng)建數(shù)據(jù)庫成功");
}
Boolean rtu;
rtu = CreateTable();
if (rtu = false)
{
MessageBox.Show("數(shù)據(jù)表已經(jīng)存在！");
}
else
{
MessageBox.Show("創(chuàng)建數(shù)據(jù)表成功！");
}
}
catch(Exception ex)
{
MessageBox.Show("創(chuàng)建數(shù)據(jù)庫失敗"+ ex.ToString().Substring(1,60));
}
}
}
}
喜歡 
頂
難過
囧
圍觀
無聊
