Create a Windows Form application for Clancy Boutique. Use the following names for the project and solution, respectively: Clancy Project and Clancy Solution. Save the application in the VB2017\Chap11 folder. 

a. Create the interface shown in Figure 11-65. The interface contains a DataGridView control, a group box, six labels, and two buttons. (The DataGridView tool is located in the Data section of the toolbox.)

b. Figure 11-66 shows the table definition and records for the Stores table, which is contained in the VB2017\Chap11\Databases\Clancy.mdf file. The Ownership field indicates whether the store is company-owned (C) or a franchisee (F). Connect the database to the application. Include the entire table in the dataset. 

c. Drag the Stores table to the DataGridView control. Use the control’s task list to disable adding, editing, and deleting records. The numbers in the Sales column should be right-aligned and displayed with a comma and no decimal places. Center the letters in the Ownership column. Also, be sure that the entire city name appears in the City column. Make the necessary modifications to the control.
d. Lock the controls on the form and then set the tab order.
e. The Calculate button should display the total sales made by company-owned stores and the total sales made by franchisees. It should also display the total sales for all of the stores. Code the button’s Click event procedure. Display the total sales amounts with a dollar sign and no decimal places. 

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