添加System.Data.SQLite.dll并在项目属性设置目标框架为.NET 3.5。
//创建数据库
SQLiteConnection conn = null;
conn = new SQLiteConnection("Data Source = test1.db");
conn.Open();
//创建表格
SQLiteCommand cmd = new SQLiteCommand();
cmd.Connection = conn;
cmd.CommandText = "create table if not exists buffer(a text,b text)";
cmd.ExecuteNonQuery();
//添加数据
cmd.CommandText = "insert into buffer values(\"facebook\",\"google\")";
cmd.ExecuteNonQuery();
cmd.CommandText = "insert into buffer values(\"amazon\",\"microsoft\")";
cmd.ExecuteNonQuery();
//选择数据 sdr(很少用到)
cmd.CommandText = "select * from buffer";
SQLiteDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())// 读取其中一行
{
//MessageBox.Show(sdr[0].ToString());
//MessageBox.Show(sdr[1].ToString());
}
sdr.Close();
// 选择数据 sda
SQLiteDataAdapter sda = new SQLiteDataAdapter("select * from buffer",conn);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable ds_dt = ds.Tables[0];
// 删除记录
//cmd.CommandText = "delete from buffer";
//cmd.ExecuteNonQuery();
// 删除数据表格
//cmd.CommandText = "drop table buffer";
//cmd.ExecuteNonQuery();
conn.Dispose();