This is a VB.NET 2003 prgram that needs coding. Please review.
? Start VB NET and create a new solution named LCarson_Unit02.sln setting the drive designator as necessary.
? Create the form's user interface with the necessary labels and text boxes to display the fields from the underlying table.
? Create a main menu for the form. Create a menu title having a menu item named Exit to exit the solution. On the Edit menu, create menu items to add, edit, and cancel editing of the current record, and to update and delete database records. On the Navigate menu, create menu items to locate the first, previous, next, and last record in the database table.
? Using the Data tab on the Toolbox, create an instance of the OleDbConnection control, and configure it so that you establish a connection with the database named Chapter.08Data08Factory.mdb, setting the drive designator as necessary.
? Generate a DataSet for the DataAdapter you just created. Set the DataSet name to dsParts.
? Write the necessary code to bind the fields in the underlying DataSet to the text boxes that you just created. Perform this task when the form loads.
? Create the code for the Add, Edit, Update, Cancel, and Delete menu items. So that the user cannot add or delete a record while the current record is being edited, create a sub procedure named EditState to enable and disable menu items as necessary. Enable or disable the text boxes also.
? Your solution should calculate the gross profit for the current item by subtracting the cost from the sales price. The total inventory at cost is calculated by multiplying the cost by the quantity on hand. You should display these output values whenever tile user locates a different record, or updates a record. I-lint: Create a sub procedure and call that procedure from the navigation menu items.
Below is actually a table but it wouldn't put it into table format, so i have used Numbering as the key. All the ones stay together etc....
1. Field Name 2. Description 3. Data Type
1. fldPartNumber 2. Unique Identification Number 3. Long Integer
1. fldDescription 2. Description on part 3. String
1. fldCost 2. Cost of part 3. Single
1. fldSalesPrice 2. Sales price of part 3. Single
1. fldQuantityOnHand 2. Number of items in inventory 3. Integer
Please make sure not to miss adding the EditState() procedure to the code and calling that procedure with the appropriate value to prevent the user from adding or deleting a record while the current record is being edited; displaying the calculated values whenever the user locates a different record or updates a record (note that the Hint suggests calling a programmer-defined procedure from the navigation menu items, however, you must also call it when a record is updated); formatting the calculated values as currency which includes trailing zeros; clearing the controls used to display the calculated values when the Add menu item is clicked.© BrainMass Inc. brainmass.com March 4, 2021, 6:19 pm ad1c9bdddf