Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 2
0
        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);
        }