SQLCE实例源码下载

【实例简介】SQLCE 类似 Sqlite

Microsoft SQL Server Compact 4.0 下载：

http://www.microsoft.com/downloads/zh-cn/details.aspx?familyid=033cfb76-5382-44fb-bc7e-b3c8174832e2

【核心代码】

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 WindowsApplication2
{
	public partial class Form1 : Form
	{
		public Form1()
		{
			InitializeComponent();
		}

		private string connStr = "Data Source = Test.sdf; Password = <password>";

		private void button2_Click(object sender, EventArgs e)
		{
			SqlCeConnection conn = null;

			try
			{
				conn = new SqlCeConnection(connStr);
				conn.Open();

				SqlCeCommand cmd = conn.CreateCommand();
				cmd.CommandText = "INSERT INTO myTable values(@col1, @col2)";
				Random rand = new Random();
				cmd.Parameters.AddWithValue("col1", rand.Next(100));
				cmd.Parameters.AddWithValue("col2", "hello");
				cmd.ExecuteNonQuery();
			}
			catch { }
			finally
			{
				conn.Close();
			}
			
			loadData();
		}

		private void loadData()
		{
			SqlCeConnection conn = null;

			try
			{
				conn = new SqlCeConnection(connStr);
				SqlCeDataAdapter ad = new SqlCeDataAdapter("select * from myTable", conn);
				DataSet ds = new DataSet();
				ad.Fill(ds);
				dataGridView1.DataSource = ds.Tables[0];
			}
			catch { }
			finally
			{
				conn.Close();
			}
		}

		private void Form1_Load(object sender, EventArgs e)
		{
			if (!File.Exists("Test.sdf"))
			{
				SqlCeEngine engine = new SqlCeEngine(connStr);
				engine.CreateDatabase();
				engine.Dispose();
			}

			SqlCeConnection conn = null;

			try
			{
				conn = new SqlCeConnection(connStr);
				conn.Open();

				SqlCeCommand cmd = conn.CreateCommand();
				cmd.CommandText = "CREATE TABLE myTable (col1 int, col2 ntext)";
				cmd.ExecuteNonQuery();
			}
			catch { }
			finally
			{
				conn.Close();
			}
			
			loadData();
		}

		private void button1_Click(object sender, EventArgs e)
		{
			SqlCeConnection conn = null;

			try
			{
				conn = new SqlCeConnection(connStr);
				conn.Open();

				SqlCeCommand cmd = conn.CreateCommand();
				cmd.CommandText = "DELETE myTable";
				cmd.ExecuteNonQuery();
			}
			catch { }
			finally
			{
				conn.Close();
			}

			loadData();
		}
	}
}