c#连sqlite数据库，实现数据更新、插入

1. data.db 需自行导入至bin文件夹内
2. 安装sqlite包

         

外部调用

---

      3.更新和插入方法：

private void insert_sql(string str)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into test(");
            strSql.Append("id,name,ph,tds,yang,press)");
            strSql.Append(" values (");
            strSql.Append("@id,@name,@ph,@tds,@yang,@press)");
            SQLiteParameter[] parameters = {
            new SQLiteParameter("@id",2),
            new SQLiteParameter("@name","test1 "),
            new SQLiteParameter("@ph",3 ),
            new SQLiteParameter("@tds",4 ),
            new SQLiteParameter("@yang",5 ),
            new SQLiteParameter("@press",4)
              };
            Service.SQLiteHelper.ExecSQL(strSql.ToString(), parameters);
        }

//更新
        private void updata()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update test set ");
            strSql.Append(" name=@name,ph=@ph,tds=@tds,yang=@yang,press=@press");
            strSql.Append(" where id=1");
            SQLiteParameter[] parameters = {
            new SQLiteParameter("@name","test2 "),
            new SQLiteParameter("@ph",3 ),
            new SQLiteParameter("@tds",4 ),
            new SQLiteParameter("@yang",5 ),
            new SQLiteParameter("@press",4)
              };
            Service.SQLiteHelper.ExecSQL(strSql.ToString(), parameters);    
       }

这篇好文章是转载于：学新通技术网