28 Extra exercises for Murach's Visual Basic 2015 Extra 15-2 Create a Master/Detail form In this exercise, you'll create a form that lets the user display an invoice, along with the line items for that invoice. Invoice Line Items nwoice ID: 46 Get Invoice Neev Product Total Sales Tax Shipping Invoice Tetal 1/13/2015 $21650 $1624 $7.50 240 24 VB Code Product Code Unit Prioe tem Total $57501 545 001 57.50 945.00 57.50 $56 50 $57 50 5012 $56 50 1 Open the project and add the database 1. Start a new project named InvoiceLinel Items in the Extra Exercises Chapter 15 InvoiceLineltems directory Add the MMABooks.mdf file in the Extra Exercises Database directory to the project. Then, use the Data Source Configuration Wizard to create a data source that includes all of the columns except for CustomerlD from the Invoices table and all of the columns from the Invoicel ineltems table. When you're done, set the "Copy to Output Directory" property of the MMABooks.mdf file to "Copy if Newer 2. Add the invoice information and toolbar Drag the columns in the Invoices table onto the form as text boxes, and format them as shown above. 3. Delete the binding navigator toolbar, and delete the statement in the Load event handler for the form that fills the Invoices table. 4. Create a parameterized query named FillByInvoicelD that gets the invoice data for a specific invoice ID, and modify the Toolstrip control that's generated so it appears as shown above. Simplify the code that was generated for the Click event handler of the button on the Toolstrip control. Test the application to be sure that the invoice data is displayed when you enter an invoice ID and click the Get Invoice button. 5. 6. 28 Extra exercises for Murach's Visual Basic 2015 Extra 15-2 Create a Master/Detail form In this exercise, you'll create a form that lets the user display an invoice, along with the line items for that invoice. Invoice Line Items nwoice ID: 46 Get Invoice Neev Product Total Sales Tax Shipping Invoice Tetal 1/13/2015 $21650 $1624 $7.50 240 24 VB Code Product Code Unit Prioe tem Total $57501 545 001 57.50 945.00 57.50 $56 50 $57 50 5012 $56 50 1 Open the project and add the database 1. Start a new project named InvoiceLinel Items in the Extra Exercises Chapter 15 InvoiceLineltems directory Add the MMABooks.mdf file in the Extra Exercises Database directory to the project. Then, use the Data Source Configuration Wizard to create a data source that includes all of the columns except for CustomerlD from the Invoices table and all of the columns from the Invoicel ineltems table. When you're done, set the "Copy to Output Directory" property of the MMABooks.mdf file to "Copy if Newer 2. Add the invoice information and toolbar Drag the columns in the Invoices table onto the form as text boxes, and format them as shown above. 3. Delete the binding navigator toolbar, and delete the statement in the Load event handler for the form that fills the Invoices table. 4. Create a parameterized query named FillByInvoicelD that gets the invoice data for a specific invoice ID, and modify the Toolstrip control that's generated so it appears as shown above. Simplify the code that was generated for the Click event handler of the button on the Toolstrip control. Test the application to be sure that the invoice data is displayed when you enter an invoice ID and click the Get Invoice button. 5. 6