Create a Maintenance application

In this exercise, you will create an application that uses a data source text boxes and DataGridView controls to maintain the products and order options in the Products and OrderOptions table of the MMABooks database.

1. Start a new project named MaintenanceApp.
2. Rename the form1.cs to frmMaintenanceApp. When ask to modify any references to the form, click the Yes button.
3. Add the MMABooks.mdf file provided by the instructor to the project.
4. Use the Data Source Configuration Wizard to create a data source that includes the ProductCode, Description, and UnitPrice columns from the Products table and SalesTaxRate, FirstBookShipCharge, and AdditionalBookShipCharge from the OrderOptions table.
5. Set the Copy to Output Directory property of the MMABooks.mdf file to Copy if Newer.
6. Display the Data Sources window, and associate the columns in the Products table of the data source you just created with individual controls.
7. Drag the Products table onto the default form to add a text box for each column.
8. Display the Data Sources window, and drag the OrderOptions table in the data source you just created onto the default form to add a DataGridView control thats bound to the table.
9. Set the properties of the form and controls so they appear as shown above.

Maintenance Application 1 of 16+ XP Product Code: 2JST Description: Murach's JavaScript (2nd Edition) Unit Price: 54.5000 Sales Tax Rate 0.0750 First Book ShipCharg Additional Book Ship 3.7500 1.2500 dbo.Order Options [Data] dbo.Products [Data] = x frmMaintenanceApp.cs [Design]* Max Rows: 1000 ST Product Code Description UnitPrice OnHandQuant... 2JST Murach's JavaS... 54.5000 6937 2QRY Murach's jQuer... 54.5000 677 A46C Murach's ASP... 57.5000 4637 A46V Murach's ASP.... 57.5000 3974 ADC4 Murach's ADO.... 56.5000 3756 ADV4 Murach's ADO.... 56.5000 4538 CRFC Murach's CICS ... 50.0000 1865 CS15 Murach's C# 20... 56.5000 5136 DB1R DB2 for the Co... 42.0000 4825 DB2R DB2 for the Co... 45.0000 621 JAVP Murach's Java... 56.5000 3455 JSP2 Murach's Java S... 57.5000 4999 MCBL Murach's Struct... 62.5000 2386 MCCP Murach's CICS... 54.0000 2368 SQ12 Murach's SQL S... 57.5000 2465 VB15 Murach's Visual... 56.5000 2193 NULL NULL NULL NULL Maintenance Application 1 of 16+ XP Product Code: 2JST Description: Murach's JavaScript (2nd Edition) Unit Price: 54.5000 Sales Tax Rate 0.0750 First Book ShipCharg Additional Book Ship 3.7500 1.2500 dbo.Order Options [Data] dbo.Products [Data] = x frmMaintenanceApp.cs [Design]* Max Rows: 1000 ST Product Code Description UnitPrice OnHandQuant... 2JST Murach's JavaS... 54.5000 6937 2QRY Murach's jQuer... 54.5000 677 A46C Murach's ASP... 57.5000 4637 A46V Murach's ASP.... 57.5000 3974 ADC4 Murach's ADO.... 56.5000 3756 ADV4 Murach's ADO.... 56.5000 4538 CRFC Murach's CICS ... 50.0000 1865 CS15 Murach's C# 20... 56.5000 5136 DB1R DB2 for the Co... 42.0000 4825 DB2R DB2 for the Co... 45.0000 621 JAVP Murach's Java... 56.5000 3455 JSP2 Murach's Java S... 57.5000 4999 MCBL Murach's Struct... 62.5000 2386 MCCP Murach's CICS... 54.0000 2368 SQ12 Murach's SQL S... 57.5000 2465 VB15 Murach's Visual... 56.5000 2193 NULL NULL NULL NULL