System.Data.Sqlite for winform

来源：互联网发布：c 高级编程第9版编辑：程序博客网时间：2024/05/16 17:35

 项目中想要引用System.Data.Sqlite，一番查询，需要安装过[ADO.NET 2.0 Provider for SQLite](http://download.csdn.net/detail/mh942408056/9500484) ，通过引用其中System.Data.Sqlite可以访问SQLite 数据库，不过目前只支持到framowork4.0以下，4.0以上包括4.0，无法使用。

SQLite帮助类：

using System.Data;using System.Data.SQLite;namespace DTS.Winfrm.res.code{    public class SqliteHelper     {        private static SQLiteConnection GetConnection()        {            string connStr = System.Configuration.ConfigurationSettings.AppSettings["sqlite"].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;            }        }    }}

0 0