static void Main5(string[] args) { try { DBAccessController ora = new DBAccessController(); string[] connectionString = { "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=latx24.nam.nsroot.net)(PORT=1521)))", "Data Source=latx24.nam.nsroot.net;User Id=PRISM9;Password=PRISM9;", "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=latx24.nam.nsroot.net)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SIT11G)));User Id=PRISM9; Password = PRISM9; " }; OracleConnection conection = new OracleConnection(connectionString[2]); conection.Open(); //OracleCommand cmd = new OracleCommand("SELECT A.*, B.* FROM all_tab_columns A LEFT JOIN(SELECT B.* FROM all_tab_columns B) B ON B.column_name = A.column_name;", conection); OracleCommand cmd = new OracleCommand("SELECT A.* FROM all_tab_columns A", conection); OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { } OracleDataAdapter da = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); WriteLine("finished"); ReadKey(); } catch (Exception ex) { ForegroundColor = ConsoleColor.Red; WriteLine(ex.Message); } ReadKey(); }
static void Main(string[] args) { //setUpVariables(); DBAccessController obj = new DBAccessController(); if (DBAccessController.dbGetOracleConnection() != null) { DataTable ddt = createOraCmd(); if (ddt != null) { createFileFromDt(ddt); } } else { Main(null); } }
static DataTable createOraCmd() { DataTable dt = null; try { WriteLine("Command Line = "); cmd = ReadLine(); OracleCommand oraCmd = new OracleCommand(cmd, DBAccessController.dbGetOracleConnection(connection)); OracleDataAdapter da = new OracleDataAdapter(oraCmd); da.Fill(dt); return(dt); } catch { dt = null; } return(dt); }