public int ExecuteNonQuery(ref ClassSetupProgram setupProgram, string sSql) { int n = 0; try { using (OracleConnection con = new OracleConnection(setupProgram.connectionToDBString)) { con.Open(); using (OracleCommand oracleCommand = con.CreateCommand()) { oracleCommand.CommandText = sSql; n = oracleCommand.ExecuteNonQuery(); } con.Close(); } } catch (Exception ex) { n = 0; } return(n); }
public void Execute <T>(ref ClassSetupProgram setupProgram, string sSql, ref List <T> listResult) { string result = ""; try { string databaseName = setupProgram.connectionToDBString; OracleConnection con = new OracleConnection(setupProgram.connectionToDBString); con.Open(); OracleCommand command = new OracleCommand(); command.Connection = con; command.CommandText = sSql; command.CommandType = CommandType.Text; OracleDataReader dataReader = command.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { result = ""; for (int i = 0; i < dataReader.FieldCount; i++) { result += Convert.ToString(dataReader.GetValue(i)) + "!"; } if (result.Count() > 2) { result = result.Remove(result.Count() - 1); } if (result != "") { listResult.Add(GetObject <T>(result)); } } } con.Close(); } catch (Exception ex) { } }