C sharp 使用sqlite.doc

System.Data.Sqlite入手。。。?首先import/using：? ? 代码 using?System.Data.SQLite;?? Connection和Command:? 代码 private?SQLiteConnection?conn;?? ?????????? ????????private?SQLiteCommand?cmd;?? 连接db：? 代码 conn?=?new?SQLiteConnection(Data?Source=c:\\test.db);?? ????????????????conn.Open();?? INSERT/UPDATE: 代码 cmd?=?conn.CreateCommand();?? cmd.CommandText?=?INSERT?INTO?user(email,name)?VALUES?(email,name);?? cmd.ExecuteNonQuery();?? ?? cmd.CommandText?=?UPDATE?userSET?name?=?Codelicious?WHERE?ID?=?1;?? cmd.ExecuteNonQuery();?? SELECT: 代码 cmd.CommandText?=?SELECT?ID,?name?FROM?user;?? SQLiteDataReader?reader?=?cmd.ExecuteReader();?? if?(reader.HasRows)?? ????????????{?? ????????????????while?(reader.Read())?? ????????????????{?? ????????????????????Console.WriteLine(ID:??+?reader.GetInt16(0));?? ????????????????????Console.WriteLine(name:??+?reader.GetString(1));?? ????????????????}?? ????????????}?  模板程序： using?System;?using?System.Data;?using?System.Data.Common;?using?System.Data.SQLite;?namespace?SQLiteQueryBrowser?{?????????/// summary?????????///?说明：这是一个针对System.Data.SQLite的数据库常规操作封装的通用类。?????????///?作者：zhoufoxcn(周公）?????????///?日期：2010-04-01?????????///?Blog: or /zhoufoxcn?????????///?Version:0.1?????????/// /summary?????????public?class?SQLiteDBHelper?????????{?????????????????private?string?connectionString =?string.Empty;?????????????????/// summary?????????????????///?构造函数?????????????????/// /summary?????????????????/// param name=dbPathSQLite数据库文件路径/param?????????????????public?SQLiteDBHelper(string?dbPath)?????????????????{?????????????????????????this.connectionString =?Data Source=?+ dbPath;?????????????????}?????????????????/// summary?????????????????///?创建SQLite数据库文件?????????????????/// /summary?????????????????/// param name=dbPath要创建的SQLite数据库文件路径/param?????????????????public?static?void?CreateDB(string?dbPath)?????????????????{?????????????????????????using?(SQLiteConnection connection =?new?SQLiteConnection(Data Source=?+ dbPath))?