Visual Basic 2005 - HELP
Not what you're looking for?
Attached is what the form is suppose to look like...I tried asking my classmates for help but they are stuck as well.... Can you please help...
Requirements
For this project you will use the following database schema, which has two tables.
Table 1 -- Schema for the tblCategories table
Column Name Data Type
ldCategoryID Integer
fldCategoryDesc String
Table 2 -- Schema for table named tblAlbums
Column Name
Data Type
fldAlbumID
Integer
fldCategoryID
Integer
fldAlbumName
String
fldArtist
String
fldDatePurchased
Date
fldCost
Single
The input form contains a ListBox and a DataGrid control. Select album categories in the list box and then the corresponding album information appears 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 that 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 tblAlbums, 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 albums.
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 Album 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.
Enhancements (optional to achieve maximum points)
Add a basic help system to your application.
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Javscript Basics
Quiz on basics of javascript programming language.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.