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 = “;

		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 loa

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件     349536  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlceca40.dll

     文件      88416  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlcecompact40.dll

     文件      79712  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlceer40CN.dll

     文件     153952  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlceer40EN.dll

     文件      66912  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlceme40.dll

     文件     171360  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlceoledb40.dll

     文件     642400  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlceqp40.dll

     文件     387424  2011-01-05 22:12  WindowsApplication2\WindowsApplication2\bin\Debug\sqlcese40.dll

     文件     465248  2011-01-05 22:36  WindowsApplication2\WindowsApplication2\bin\Debug\System.Data.SqlServerCe.dll

     文件      32768  2012-04-25 16:46  WindowsApplication2\WindowsApplication2\bin\Debug\Test.sdf

     文件      20480  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\bin\Debug\WindowsApplication2.exe

     文件      26112  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\bin\Debug\WindowsApplication2.pdb

     文件       5632  2005-12-08 14:51  WindowsApplication2\WindowsApplication2\bin\Debug\WindowsApplication2.vshost.exe

     文件       2294  2012-04-25 16:46  WindowsApplication2\WindowsApplication2\Form1.cs

     文件       3496  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\Form1.Designer.cs

     文件       5814  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\Form1.resx

     文件       4570  2012-04-25 16:03  WindowsApplication2\WindowsApplication2\obj\Debug\ResolveAssemblyReference.cache

     文件        842  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\obj\Debug\WindowsApplication2.csproj.GenerateResource.Cache

     文件      20480  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\obj\Debug\WindowsApplication2.exe

     文件        180  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\obj\Debug\WindowsApplication2.Form1.resources

     文件      26112  2012-04-25 16:45  WindowsApplication2\WindowsApplication2\obj\Debug\WindowsApplication2.pdb

     文件        180  2012-04-25 16:03  WindowsApplication2\WindowsApplication2\obj\Debug\WindowsApplication2.Properties.Resources.resources

     文件       1174  2012-04-25 16:46  WindowsApplication2\WindowsApplication2\obj\WindowsApplication2.csproj.FileListAbsolute.txt

     文件        400  2012-04-25 15:44  WindowsApplication2\WindowsApplication2\Program.cs

     文件       1196  2012-04-25 15:44  WindowsApplication2\WindowsApplication2\Properties\AssemblyInfo.cs

     文件       2546  2012-04-25 15:44  WindowsApplication2\WindowsApplication2\Properties\Resources.Designer.cs

     文件       5612  2012-04-25 15:44  WindowsApplication2\WindowsApplication2\Properties\Resources.resx

     文件       1026  2012-04-25 15:44  WindowsApplication2\WindowsApplication2\Properties\Settings.Designer.cs

     文件        249  2012-04-25 15:44  WindowsApplication2\WindowsApplication2\Properties\Settings.settings

     文件       3516  2012-04-25 16:20  WindowsApplication2\WindowsApplication2\WindowsApplication2.csproj

............此处省略13个文件信息