Analysts access financial data constantly. This homework will give you practice with (a) dynamic SQL queries, and (b) combo boxes.
SmallBankDB contains a table called StockMarket, which contains six months of closing prices for a basket of a dozen stocks. Create an app that
- Connects at startup with the database, and fills up two combo boxes with distinct dates and distinct tickers.
- At the press of a button, it shows either all the available stocks for a given date, or all the available prices (i.e., dates) for a given stock
A vLab is provided. The vLab is a partial solution.