In this exercise, you will create a solution that works with two tables having a Master/Detail relationship.

For this assignment, you will create a Visual Basic.NET application to
extend IP2 into a more complete personal asset manager. In this
exercise, you will create a solution that works with two tables having a
Master/Detail relationship. The first table contains asset category
records, and the second table contains asset detail records for each
category.



Minimum Requirements

Table 1 -- Schema for the tblCategories table

Column Name Data Type

fldCategoryID Integer

fldCategoryDesc String

Table 2 -- Schema for table named tblAssets

Column Name Data Type

fldAssetID Integer

fldCategoryID Integer

fldAssetName String

fldDescription String

fldDateAcquired Date

fldCost Single

For this project, you will use the following database schema, which has
two tables.

The input form contains a ListBox and a DataGrid control. Select asset
categories in the list box and then the corresponding asset information
will appear in the DataGrid. As you select different categories, the
total costs are recalculated for the selected category and displayed in
a label on your form, formatted as currency.

Configure the form so it appears on the center of the desktop when the
solution is run.

Do not allow the user to resize the form.

Remove minimize, maximize, and close buttons from the title bar.

Perform the appropriate steps to create a connection to the sample
database. Be sure to select the option to copy the database to your
project so it will be automatically included in the project.

Create an instance of the ListBox control. Set the necessary properties
so the ListBox control will display the field fldCategoryDesc.

Create an instance of the DataGrid control on the form. Configure the
DataGrid control instance so it displays records from the table named
tblAssets, but only for those records matching the selected category
shown in the list box.

Format the DataGrid so the column header names are the same as the ones
shown in the Figure. Set appropriate column widths, and format the cost
column as currency, right justified. The date column should also be
right justified.

Write the necessary code to calculate the total cost of the displayed
assets. Display the results in a Label control above the cost column of
the DataGrid. Format the output as currency. Right-justify the output in
the Label control instance.

Create an Update button that will allow the user to save any changes
made to the DataGrid back to the database. Write the necessary code for
the button. Allow the user to add, change, and delete records in the
Asset table.

Create an Exit button for the solution. In the Click event handler for
the button, display a message box to get confirmation from the user
before exiting the solution.

Add a basic help system to your application.