public void Execute_Query(string com_str, int connId) { WorkerResult = new SqlWorkerQueryResult(com_str); WorkerResult.Start(); try { com = GetConnection(connId).CreateCommand(); com.CommandText = com_str; int cnt = com.ExecuteNonQuery(); WorkerResult.Success(cnt); } catch (Exception ex) { WorkerResult.Error(ex.Message); } WorkerResult.End(); }
public void Execute_Query(string com_str, int connId, SQLiteParameter[] prm) { WorkerResult = new SqlWorkerQueryResult(com_str); WorkerResult.Start(); try { com = GetConnection(connId).CreateCommand(); com.CommandText = com_str; for (int i = 0; i < prm.Length; i++) { com.Parameters.Add(prm[i]); } int cnt = com.ExecuteNonQuery(); WorkerResult.Success(cnt); } catch (Exception ex) { WorkerResult.Error(ex.Message); } WorkerResult.End(); }