Designing the Database
For this application, you'll use a Microsoft Access database to hold the stocks that you are tracking. The database is called Ch13.mdb and is placed somewhere accessible by the application you'll be building. Ch13.mdb contains one table called tblStocks, whose structure is as follows:
| Field Name | Data Type | Length |
|---|---|---|
| StockID | Text | 5 |
| LowPriceAlert | Currency | |
| HighPriceAlert | Currency | |
| CurrentPrice | Currency | |
| LastPriceAlert | Date/Time |
The only field that is required is the StockID, which is also the primary key for the table. All the fields in the table will be provided for each row based on the stocks that you choose to watch.
Get Creating and Consuming Web Services in Visual Basic® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
