初始化数据库地址：

public static readonly string ConnStr = AppDomain.CurrentDomain.BaseDirectory +  ConfigurationManager.AppSettings["SqliteDbPath"];

可工具不同的项目使用不同的语句，WEB项目和WINFORM有所不同。

要记得添加 System.Data.SQLite.DLL 引用。

using System; using System.Data; using System.Text.RegularExpressions; using System.Xml; using System.IO; using System.Collections; using System.Data.SQLite; using System.Configuration;  namespace IBOOK.Communication.DBUtility {     /// 
     /// SQLiteHelper is a utility class similar to "SQLHelper" in MS     /// Data Access Application Block and follows similar pattern.     /// 
     public class SQLiteHelper {         /// 
           /// 获得连接对象           /// 
           /// 
                 ///            public static readonly string ConnStr = AppDomain.CurrentDomain.BaseDirectory +  ConfigurationManager.AppSettings["SqliteDbPath"];         public static SQLiteConnection GetSQLiteConnection() {             return new SQLiteConnection("Data Source=" + ConnStr);          }          private static void PrepareCommand(SQLiteCommand cmd, SQLiteConnection conn, string cmdText, params object[] p) {              if (conn.State != ConnectionState.Open)                 conn.Open();             cmd.Parameters.Clear();             cmd.Connection = conn;             cmd.CommandText = cmdText;              cmd.CommandType = CommandType.Text;             cmd.CommandTimeout = 30;              if (p != null) {                 foreach (object parm in p)                     cmd.Parameters.AddWithValue(string.Empty, parm);              }         }          /// 
           /// 返回DataSet           /// 
           /// The CMD text.           /// The p.           /// 
                 public static DataSet ExecuteDataset(string cmdText, params object[] p) {             DataSet ds = new DataSet();             SQLiteCommand command = new SQLiteCommand();             using (SQLiteConnection connection = GetSQLiteConnection()) {                 PrepareCommand(command, connection, cmdText, p);                 SQLiteDataAdapter da = new SQLiteDataAdapter(command);                 da.Fill(ds);             }              return ds;         }          /// 
           /// Executes the data row.           /// 
           /// The CMD text.           /// The p.           /// 
                 public static DataRow ExecuteDataRow(string cmdText, params object[] p) {             DataSet ds = ExecuteDataset(cmdText, p);             if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)                 return ds.Tables[0].Rows[0];             return null;         }          /// 
           /// 执行SQL 返回受影响的行数           /// 
           /// a           /// 传入的参数           /// 
                 public static int ExecuteNonQuery(string cmdText, params object[] p) {             SQLiteCommand command = new SQLiteCommand();              using (SQLiteConnection connection = GetSQLiteConnection()) {                 PrepareCommand(command, connection, cmdText, p);                 return command.ExecuteNonQuery();             }         }          /// 
           /// 返回SqlDataReader对象           /// 
           ///            /// 传入的参数           /// 
                 public static SQLiteDataReader ExecuteReader(string cmdText, params object[] p) {             SQLiteCommand command = new SQLiteCommand();             SQLiteConnection connection = GetSQLiteConnection();             try {                 PrepareCommand(command, connection, cmdText, p);                 SQLiteDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);                 return reader;             } catch {                 connection.Close();                 throw;             }         }          /// 
           /// 返回结果集中的第一行第一列，忽略其他行或列           /// 
           ///            /// 传入的参数           /// 
                 public static object ExecuteScalar(string cmdText, params object[] p) {             SQLiteCommand cmd = new SQLiteCommand();              using (SQLiteConnection connection = GetSQLiteConnection()) {                 PrepareCommand(cmd, connection, cmdText, p);                 return cmd.ExecuteScalar();             }         }          /// 
           /// 分页           /// 
           ///            ///            ///            ///            ///            ///            /// 
                 public static DataSet ExecutePager(ref int recordCount, int pageIndex, int pageSize, string cmdText, string countText, params object[] p) {             if (recordCount < 0)                 recordCount = int.Parse(ExecuteScalar(countText, p).ToString());              DataSet ds = new DataSet();              SQLiteCommand command = new SQLiteCommand();             using (SQLiteConnection connection = GetSQLiteConnection()) {                 PrepareCommand(command, connection, cmdText, p);                 SQLiteDataAdapter da = new SQLiteDataAdapter(command);                 da.Fill(ds, (pageIndex - 1) * pageSize, pageSize, "result");             }             return ds;         }       } }