sqlite这个精巧的小数据库，无需安装软件，只需要一个System.Data.sqlite.DLL文件即可操作sqlite数据库。sqlite是一个开源数据库，现在已变得越来越流行，它的体积很小，被广泛应用于各种不同类型的应用中。sqlite已经是世界上布署得最广泛的sql数据库引擎，被用在无以计数的桌面电脑应用中，还有消费电子设备中，如移动电话、掌上电脑和MP3播放器等。sqlite的源码就放在公有领域（即WikiPedia的public domain)中。

using System; using System.Collections.Generic; using System.Text; using System.Web; using System.Configuration; using System.Data; using System.Data.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>ite; namespace DAL { public class <a href="/tag/sql/" target="_blank" class="keywords">sql</a>ite { /// <summary> /// 获得连接对象 /// </summary> /// <returns></returns> public static <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection Get<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection() { return new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection("Data Source=" + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["db"].ToString())); } private static void PrepareCommand(<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand cmd,<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection 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); //for (int i = 0; i < p.Length; i++) // cmd.Parameters[i].Value = p[i]; } } public static DataSet ExecuteDataset(string cmdText,params object[] p) { DataSet ds = new DataSet(); <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand command = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand(); using (<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection connection = Get<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection()) { PrepareCommand(command,connection,cmdText,p); <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteDataAdapter da = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteDataAdapter(command); da.Fill(ds); } return ds; } 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; } /// <summary> /// 返回受影响的行数 /// </summary> /// <param name="cmdText">a</param> /// <param name="commandParameters">传入的参数</param> /// <returns></returns> public static int ExecuteNonQuery(string cmdText,params object[] p) { <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand command = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand(); using (<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection connection = Get<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection()) { PrepareCommand(command,p); return command.ExecuteNonQuery(); } } /// <summary> /// 返回<a href="/tag/sql/" target="_blank" class="keywords">sql</a>DataReader对象 /// </summary> /// <param name="cmdText"></param> /// <param name="commandParameters">传入的参数</param> /// <returns></returns> public static <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteDataReader ExecuteReader(string cmdText,params object[] p) { <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand command = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand(); <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection connection = Get<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection(); try { PrepareCommand(command,p); <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); return reader; } catch { connection.Close(); throw; } } /// <summary> /// 返回结果集中的第一行第一列，忽略其他行或列 /// </summary> /// <param name="cmdText"></param> /// <param name="commandParameters">传入的参数</param> /// <returns></returns> public static object ExecuteScalar(string cmdText,params object[] p) { <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand cmd = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand(); using (<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection connection = Get<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection()) { PrepareCommand(cmd,p); return cmd.ExecuteScalar(); } } /// <summary> /// <a href="/tag/fenye/" target="_blank" class="keywords">分页</a> /// </summary> /// <param name="recordCount"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="cmdText"></param> /// <param name="countText"></param> /// <param name="p"></param> /// <returns></returns> public static DataSet ExecutePager(ref int recordCount,int pageIndex,int pageSize,string countText,params object[] p) { if (recordCount < 0) recordCount = int.Parse(ExecuteScalar(countText,p).ToString()); DataSet ds = new DataSet(); <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand command = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteCommand(); using (<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection connection = Get<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteConnection()) { PrepareCommand(command,p); <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteDataAdapter da = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteDataAdapter(command); da.Fill(ds,(pageIndex - 1) * pageSize,pageSize,"result"); } return ds; } } }