wince中使用SQLite

1、下载System.Data.SQLite.DLL,下载地址：
ADO.NET 2.0 Provider for SQLite – Browse /SQLite for ADO.NET 2.0 at SourceForge.net
http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/
安装后会在C:\Program Files\SQLite.NET\bin\CompactFramework下面有 System.Data.SQLite.dll 和SQLite.Interop.066.DLL两个文件
在VS2008项目中引用System.Data.SQLite.DLL即可。

2、创建表、读取数据等操作

using System.Data;
using System.Data.SQLite;

private void BtnGetData_Click(object sender, EventArgs e)
{
//创建一个空数据库
string datasource=System.IO.Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase) +”\test.db”;  //数据库文件放在了程序运行根目录下

SQLiteConnection.CreateFile(datasource);
//连接数据库
SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();

conn.ConnectionString = “Data Source=” + datasource + “;Pooling=true;FailIfMissing=false”;
conn.Open();
//创建表
SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
string sql = “CREATE TABLE users(username varchar(20),password varchar(20))”;
cmd.CommandText=sql;
cmd.Connection=conn;
cmd.ExecuteNonQuery();
//插入数据
sql = “INSERT INTO [users] VALUES(‘AAA’,’123556′)”;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
//取出数据
sql = “SELECT * FROM [users]”;
cmd.CommandText = sql;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
while (reader.Read())
{
sb.Append(“username:”).Append(reader.GetString(0)).Append(“\n”);
sb.Append(“password:”).Append(reader.GetString(1));
}
MessageBox.Show(sb.ToString());
}
注意：
程序编译完后需要将安装后的两个DLL文件复制到WINCE的程序运行目录下，即：System.Data.SQLite.dll和SQLite.Interop.066.DLL（该文件需要更名为SQLite.Interop.DLL）