Microsoft VisualBasic.Net HELP!!
Is there anyone fluent in this program!?!
It's absolutely horrid!
I have this project due next week and its causing me major stress wrinkles! 😛
Anyone care to help?
INSY 3301
Project 2
Create a “front-end” application to view and manipulate the Supplier table of the Northwind database provided on the course website. Valid login information (User IDs and Passwords) is also provided in this database, in the SystemUser table. You must download and save the Northwind database in the Bin folder inside your project folder.
The program should have a neat and professional appearance, and it should be user-friendly and intuitive (i.e., the GUI should be designed in such a way that the user knows what to do on that form). Forms should be sized for 1024 x 768 resolution, and the Supplier form should be maximized.
This is an individual project. You must use your initials as a suffix on all object, file names, variable, and user-defined subs/functions; e.g., frmSupplier_abc (if you do not have a middle initial, use X).
Login Form
The application should first display a Login window. Use a MaskedEdBox for the User ID and a TextBox for the Password (they should be blank when the form first opens, with focus on the User ID MaskEdBox). Put a “User ID” label in front of the MaskedEditBox and a “Password” label in front of the TextBox. The MaskedEditBox control should restrict the user’s entry to 8 upper case characters for the User ID. The TextBox for the Password should display an asterisk (*) as the password character (i.e., when the user types into the TextBox, the characters will display as asterisks, rather than show the actual characters entered). In order to login successfully, the user must enter one of the User ID/Password combinations in the Northwind.mdb database (you will need code to ensure that the Password will be recognized whether it is entered as upper case or lower case letters). If the user enters a correct User ID and Password, display the Supplier Form and close the Login form. Otherwise, display an appropriate message box and allow another try. Give up to 3 tries to login successfully (if the user leaves either the User ID or Password blank, display a message box, but DO NOT count it as a failed attempt). If the user reaches 3 failed attempts, display an appropriate message box on the 3rd attempt and close the Login form.
Supplier Form
This form should use the OleDbDataAdapter and DataSet objects to show all columns from the Supplier table. The values for the rows should display in text boxes, and you will need labels in front of each TextBox. Only one row will show at a time.
The rows should be sorted by Supplier ID in ascending order. Provide the following buttons to allow the user to display the various rows in the TextBoxes:
• First – to display the first row (Supplier with lowest ID)
• Previous – to display the previous row
• Next – to display the next row
• Last – to display the last row (Supplier with highest ID)
• Find – provide a TextBox (with Label) on this form for the user to enter the desired Supplier ID—if it exists, display the row; otherwise, display a message and remain on the current row
Provide the following buttons to make changes to the data in the Supplier table:
• Add – to add a new row *
• Delete – to delete the current row (confirm with a Message Box)
• Save – to save the current row
• Cancel – to cancel pending changes on the current row (confirm with a Message Box)
* Each time the user chooses to add a new Supplier, provide the appropriate value in the Supplier ID TextBox (find the highest existing Supplier ID in the table and increment it by 1). Since Supplier ID is the primary key, the Supplier ID TextBox should always be disabled to prevent the user from changing its value.
Place a label on the bottom of the form to show the number of rows in the Supplier table (e.g., if there are 100 rows in the table, the label should display “Total Number of Suppliers: 100”). The caption on this label should be updated each time a new row is saved and each time a row is deleted; i.e., each time the row count changes.
Provide validation in the Save option to ensure values are entered into the following required fields:
• Company Name
• Contact Name
• Contact Title
• Address
• City
• Postal Code
• Country