本文共 2790 字，大约阅读时间需要 9 分钟。

App.config

备注：如果开发环境是4.0，而System.Data.Sqlite是比较低的版本，则可能会弹出错误信息“混合模式程序集是针对“v2.0.50727”版的运行时生成的，在没有配置其他信息的情况下，无法在 4.0 运行时中加载该程序集”，解决方法是在上面加上：

</startup>

数据库读写助手SqliteHelper.cs

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.Common;using System.Data.SQLite;public class SqliteHelper{    public SqliteHelper()    {        //        //TODO: 在此处添加构造函数逻辑        //    }    private static SQLiteConnection GetConnection()    {        string connStr = System.Configuration.ConfigurationManager.AppSettings["DbSQLite"].ToString();         SQLiteConnection conn = new SQLiteConnection(connStr);        conn.Open();        return conn;    }    public static int ExecuteSql(string sql)    {        using (SQLiteConnection conn = GetConnection())        {            var cmd = new SQLiteCommand(sql, conn);            return cmd.ExecuteNonQuery();        }    }    public static int ExecuteScalar(string sql)    {        using (SQLiteConnection conn = GetConnection())        {            var cmd = new SQLiteCommand(sql, conn);            object o = cmd.ExecuteScalar();            return int.Parse(o.ToString());        }    }    public static SQLiteDataReader ExecuteReader(string sql)    {        SQLiteConnection conn = GetConnection();        var cmd = new SQLiteCommand(sql, conn);        SQLiteDataReader myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);        return myReader;    }    public static DataSet ExecDataSet(string sql)    {        using (SQLiteConnection conn = GetConnection())        {            var cmd = new SQLiteCommand(sql, conn);            SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);            DataSet ds = new DataSet();            da.Fill(ds);            return ds;        }    }}

窗体中应用Form1.cs

//判断表是否存在，不存在则生成            int result = SqliteHelper.ExecuteScalar("SELECT COUNT(*) FROM sqlite_master where type='table' and name='tb'");            if (result == 0)            {                //创建表                SqliteHelper.ExecuteSql("create table [tb] (id integer PRIMARY KEY autoincrement, [name] varchar(20), [createDate] datetime default (datetime('now', 'localtime')))");            }            //插入一行数据            result = SqliteHelper.ExecuteSql("insert into [tb](name) values ('Luck')");            if(result > 0)            {                string msg = "";                //读取数据                SQLiteDataReader dr = SqliteHelper.ExecuteReader("select * from [tb]");                if (dr.Read())                {                    msg += dr[0] + "," + dr[1] + "," + dr[2];                }                MessageBox.Show(msg);            }

转载地址：http://smzrf.baihongyu.com/