private static OracleCommand getNewCommand(string funcName) { OracleCommand com = new OracleCommand(); var connection = DBSingleton.GetConnection(); if (connection.State != System.Data.ConnectionState.Open) { connection.Open(); } com.Connection = connection; com.CommandType = System.Data.CommandType.StoredProcedure; com.CommandText = funcName; return(com); }
public static DataTable TrySelectSql(string TrySql) { try { OracleDataAdapter dataAdapter = new OracleDataAdapter(); dataAdapter.SelectCommand = new OracleCommand() { Connection = DBSingleton.GetConnection(), CommandText = TrySql }; DataTable dt = new DataTable(); dataAdapter.Fill(dt); return(dt); } catch (Exception e) { return(null); } }
public static DataTable SelectSql(string sql) { try { OracleDataAdapter dataAdapter = new OracleDataAdapter(); dataAdapter.SelectCommand = new OracleCommand() { Connection = DBSingleton.GetConnection(), CommandText = sql }; DataTable dt = new DataTable(); dataAdapter.Fill(dt); return(dt); } catch (Exception e) { MessageBox.Show(e.Message, "SQL Error!"); return(null); } }