c# 操作Sqlite数据库

声明变量

     System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
       System.Data.SQLite.SQLiteConnection conn = null;
       string sql = "";
       string value = "";
       int state = 0;

（1）打开数据源

   private SQLiteConnection openDataSource()
       {
           string datasource = System.AppDomain.CurrentDomain.BaseDirectory.ToString() + @"db\test.db";
           conn =new System.Data.SQLite.SQLiteConnection();
           System.Data.SQLite.SQLiteConnectionStringBuilder connstr =new System.Data.SQLite.SQLiteConnectionStringBuilder();
           connstr.DataSource = datasource;
           conn.ConnectionString = connstr.ToString();
           conn.Open();
           return conn;
       }

（2）入库

   //保存
       public int addData(string value)
       {
           string sql = "insert into test(myvalue) values("+value+")";
           cmd.CommandText = sql;
           cmd.Connection = openDataSource();
           state=  cmd.ExecuteNonQuery();
           closeDataSource();
           return state;
       }

（3）查询

 public DataSet GetTable(string strWhere)
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("select * from test");
           if (strWhere.Trim() != "")
           {
               strSql.Append(" where " + strWhere);
           }
           cmd.CommandText = strSql.ToString();
           cmd.Connection = openDataSource();
           SQLiteDataAdapter da = new SQLiteDataAdapter();
           da.SelectCommand = cmd;
           DataSet ds = new DataSet();
           da.Fill(ds);
           closeDataSource();
           return ds;
       }

（4）关闭连接

    private void closeDataSource()
       {
           conn.Close();
           conn.Dispose();
       }