Advanced Visual Basic 2010 Chapter 5 Programming Challenge 5 Training Workshops
Use the Programming Challenge 3 from Chapter 1 as a starting point for this challenge.
This version will be a 3-tier application.
1. Add an ID property to the Workshop class.
2. Create a database to replace the data file that was used for input in Chapter 1. In it, create a database table named Workshops that contains the workshop ID, category ID, number of days, cost of the workshop, and workshop title. Also in the database, create a Categories table that contains category ID and category description columns.
3. Create a DataSet containing table adapters based on the two database tables. In addition, create a TableAdapter that joins the two tables and contains the workshop ID, workshop category name, number of days, cost, and workshop description.
4. The Workshop class represents the middle tier. In this class, declare an instance of the TableAdapter class so you can call the TableAdapter methods. Provide properties and methods in the Workshop class that are called by your MainForm and DetailsForm classes.
5. Display the list of workshops in a DataGridView control, as shown in Figure 5-32. When the user selects a workshop in the grid, display the Workshop Details form, as shown in Figure 5-33. The combo box is filled from the Categories TableAdapter. The user must be able to modify a workshop in this window and save his or her changes. When the details form closes, the grid must be refreshed, so the user can see the changes he or she made.