/// <summary> /// 增、删、改(SQLite) /// </summary> /// <param name="dbPath"></param> /// <param name="param"></param> /// <returns></returns> public int SQLiteExecute(string dbPath, SQLIteDbParameter param) { using (SQLiteConnection conn = new SQLiteConnection($"data source={dbPath}")) { conn.Open(); using (SQLiteCommand cmd = new SQLiteCommand(conn)) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = param.SqlCmdTxt; foreach (var item in param.SqlLiteParameters) { cmd.Parameters.Add(item); } return(cmd.ExecuteNonQuery()); } } }
public DataSet SQLiteGetDataSet(string dbPath, SQLIteDbParameter param) { using (SQLiteConnection conn = new SQLiteConnection($"data source={dbPath}")) { conn.Open(); DataSet dt = new DataSet(); using (SQLiteDataAdapter da = new SQLiteDataAdapter()) { using (SQLiteCommand cmd = new SQLiteCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = param.SqlCmdTxt; foreach (var item in param.SqlLiteParameters) { cmd.Parameters.Add(item); } da.SelectCommand = cmd; } da.Fill(dt); return(dt); } } }