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;<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
namespace WinAppGrid { public partial class Form1 : Form { public Form1() { InitializeComponent(); } //创建数据库的表 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("创建数据库成功!"); return true; } catch (Exception ex) { MessageBox.Show("创建数据库失败" + ex.ToString().Substring(1, 60)); return false; }