常用的C#带参数SQLite数据库,修改数据
public bool Updata(Model.ProgrammeModel model){bool b = false;StringBuilder strSql = new StringBuilder();strSql.Append("update programme set ");strSql.Append("dy=@dy,");strSql.Append("dl=@dl,");strSql.Append("xx=@xx,"…
NetBlog主题
常用的C#带参数SQLite数据库添加(插入)数据
public bool InsertData(Model.ProgrammeModel model){bool b = false;StringBuilder strSql = new StringBuilder();strSql.Append("insert into programme(");strSql.Append("dy,dl,xx,glys,pl,xh,fa,pinli,mdjx)");strSql.Append(" values ("…
C#,常用的SQLiteHelper基类
using System;using System.Data;using System.Data.SQLite;namespace LQWVJE.DAL{ public static class SQLiteHelper { /// summary /// ConnectionString样例：Data Source=Test.db3;Pooling=true;FailIfMissing=false /// /summary…