Reference no: EM13935056
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
|
Using VB.NET 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.
|
How the joint venture limited the risk of the business
: Explain how the joint venture enabled Anheuser-Busch to achieve its objective of maximizing shareholder wealth. Explain how the joint venture limited the risk of the international business
|
|
Calculate the total cost for the knee surgery
: Calculate the total cost for the knee surgery.
|
|
Quality of legal research methodology
: Essay is an opportunity to provide advice to someone about how to deal with a hypothetical problem they have in the cyberlaw area.
|
|
Which cells are the smallest-bacteria. elodea or spirostomum
: What is similar about the functions of RER,SER, and Golgi complex? How might they interact? Which organelles are exclusive to plants? To animals? How does this affect the functions of these organisms?
|
|
Remove minimize, maximize, and close buttons from the title
: 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.
|
|
Generally about what it development and operations
: The novel is generally about what IT Development and Operations (Dev-Ops) has to learn from manufacturing. Summarize as a list, what these recommendations are. For each recommendation, list a page in the novel where the recommendation is made or r..
|
|
Describe the nature of the interdependency
: Describe the nature of the interdependency that exists between you and these critical groups or individuals. That is: in what way do you rely on each other?
|
|
How to solve time value of money problems
: Note the tabs in the file: Intro, Future Value, Present Value, FV of an Annuity, PV of an Annuity, Amortized Loans 1, and Uneven Cash Flows 1. Each of these tabs provides detailed information on how to solve time value of money problems and each a..
|
|
Useful principle about it management
: The novel is generally about what IT Development and Operations (Dev-Ops) has to learn from manufacturing. Summarize as a list, what these recommendations are. For each recommendation, list a page in the novel where the recommendation is made or r..
|