Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

only need code for the btncalc (#8) asap please, thank you VB9elChap11|Total Cookie Sales Solution folder. 2. Figure 11-66 shows the Sales table contained in

image text in transcribed

only need code for the btncalc (#8) asap please, thank you

VB9elChap11|Total Cookie Sales Solution folder. 2. Figure 11-66 shows the Sales table contained in the CookieSales.mdf file. The table contains the number of boxes of each type of cookie sold in each of six weeks. The database is already connected to the application and the CookieSalesDataSet has already been created. Figure 11-66 Details Sales table for Exercise 5 3. Open the Data Sources window and then drag the Sales table to the DataGridView control. 4. 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. 5. Lock the controls on the form. 6. Start the application to verify that the six records appear in the DataGridView control. Stop the application. 7. Create a new tableAdapter with a SQL query that returns the total for each of the three (3) cookie types. 8. The Calculate button should display the total sales for each cookie type. Code the btnCalc_Click procedure. (You may need to move the code from one sub procedure to the button click sub 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions