In this exercise, you create an application that keeps track of cookie sales. Create a Windows Forms application. Use the following names for the project and solution, respectively: Cookies Project and Cookies Solution. Save the application in the VB2017\ Chap11 folder.
a. Figure 11-59 shows the Sales table contained in the VB2017\Chap11\Databases\ Cookies.mdf file. The table contains the numbers of boxes of cookies sold in each of three weeks. The Week field is an auto-numbered field. Open the Data Sources window and click Add New Data Source to start the Data Source Configuration Wizard. Connect the Cookies.mdf file to the application. Include the entire Sales table in the dataset.
b. Set the Cookies.mdf file’s Copy to Output Directory property to “Copy if newer”.
c. Display the dataset information in a DataGridView control and then make the necessary modifications to the control.
d. Enter an appropriate Try...Catch statement in the SalesBindingNavigatorSaveItem_ Click procedure.
e. Save the solution and then start the application. Change the Chocolate Chip cookie sales in Week 1 to 205. Then, enter the following record for Week 4: 150, 112, and 76. Save the changes.
f. Stop the application and then start it again to verify that the changes you made were saved.