Certificado

Querys con SQLite en C#



public void QueryUpdate(string table, string campos, string condicion) { this.query = "UPDATE " + table + " SET " + campos + " WHERE " + condicion + ";"; } public void QueryInsertar(string table,string campos, string columnas) { this.query = "INSERT INTO "+table+" ("+campos+") VALUES ("+columnas+");"; }

public void EjecutarConsulta() { conectar(); SQLiteCommand sqlite_cmd = sqlite_conn.CreateCommand(); sqlite_cmd.CommandText = this.query.Trim(); try { sqlite_cmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine("No se ha podido insertar"); Console.WriteLine("Error encontrado: {0} ", e.Message); } desconectar(); }

Comentarios

Entradas populares