Programming with Microsoft VB 2017 Diane Zak Chapter 11 Total Cookie Sales Solution

Description

Programming with Microsoft VB 2017 Diane Zak Chapter 11 Total Cookie Sales Solution

Open the Total Cookie Sales Solution.sln file contained in the VB2017\Chap11\Total Cookie Sales Solution folder
a. Figure 11-63 shows the Sales table contained in the CookieSales.mdf file. The table contains the numbers of boxes of cookies sold in each of six weeks. The database is already connected to the application and the CookieSalesDataSet has already been created.

b. Open the Data Sources window and then drag the Sales table to the DataGridView control. Change the control’s AutoSizeColumnsMode to Fill. Use the control’s task list to disable adding, editing, and deleting records. Also, right-align the numbers in the cookie sales columns.

c. Lock the controls on the form. Start the application to verify that the six records appear in the DataGridView control. Stop the application.

d. The Calculate button should display the total sales for each cookie type. Code the btnCalc_Click procedure. (The database does not allow NULLs in any of the fields, so you do not need to check if a field contains the NULL value.)

e. Save the solution and then start and test the application.