主页地址:http://system.data.sqlite.org/
sqlite_ADO 示例代码:
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.Text;
namespace SQLite_ADO
{
class Program
{
static void Main(string[] args)
{
if (args.Length==0)
{
Console.WriteLine(" usage: sqlite_ADO ?????? ");
return;
}
try
{
string datasource = "test.db";
// 连接数据库
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
// connstr.Password = ""; // 设置密码
conn.ConnectionString = connstr.ToString();
conn.Open();
// 查询
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
string code = args[0];
string sql = String.Format(
"select code,cname from table where code in ('{0}0000','{1}00','{2}');",
code.Substring(0,2),code.Substring(0,4),code);
cmd.CommandText = sql;
cmd.Connection = conn;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine("{0}\t{1}",reader.GetString(0),reader.GetString(1));
}
reader.Close();
conn.Close();
} catch (Exception e) {
Console.WriteLine(e.ToString());
}
}
}
}
System.Data.SQLite.dll 下载在 http://download.csdn.net/detail/dingymm/3720915
编译: csc.exe /r:"System.Data.SQLite.dll" /t:exe sqlite_ADO.cs
运行 sqlite_ADO.exe