public override bool Select(string SQL) { OracleCommand command = new OracleCommand(SQL, DataBaseOracle.Get()); OracleDataReader reader; try { reader = command.ExecuteReader(); } catch (Exception) { return(false); } DataRows row; Rows = new List <DataRows>(); while (reader.Read()) { row = new DataRows(); for (int i = 0; i < reader.FieldCount; i++) { row.AddField(new DataField(reader.GetName(i), Convert.ToString(reader.GetValue(i)))); } Rows.Add(row); } DataBaseOracle.Disconnect(); return(true); }
public static void Disconnect() { if (_instance != null) { _instance.DisconnectFromBase(); _instance = null; } }
private static void Create() { if (_instance == null) { _instance = new DataBaseOracle(); _instance.ConnectToBase(ConnectionString); } }
public override bool Execute(string SQL) { OracleCommand command = new OracleCommand(SQL, DataBaseOracle.Get()); try { command.ExecuteNonQuery(); } catch (Exception) { return(false); } return(true); }