Create a Visual Basic application that meets the following requirements: Follow
ID: 3761395 • Letter: C
Question
Create a Visual Basic application that meets the following requirements:
Follow class/textbook standards for Windows form design.
Use an MDI parent form.
Use separate child forms for each area of selected information.
All forms must include a tool icon from the Tool Graphics and Icons zip file that was attached to Assignment 1.
All child forms and the About form must display the Tool icon and the Vandeman’s logo (also in the zip file attached to Assignment 1.)
You will use the VANDEMANS SQL database included with this assignment.
Create an MDI parent form that contains a menu strip and a tool strip. Use buttons for the tool strip.
Include a status bar that displays the date and time in two separate panels at the bottom of the MDI parent form. (You will need to add the status bar to your tool box.)
On the MDI menu provide
A file menu to allow the user to open child forms, print the active form and exit the application
A windows menu that allows the user to arrange the open child forms (cascade, horizontal and vertical.)
A help menu that displays an About Box using the About Box Windows forms template.
Create an Employees child form. Create a new DataSource that includes all fields in the Employee table. Use the ‘Details’ selection for the dataset and change the EmployeeLastName control to a Combo Box. Follow the instructions on pages 417-419 of the textbook to set up the Combo Box to set data bound items. Update the SELECT statement with a WHERE clauseso that the Employees are displayed in alphabetical order by EmployeeLastName.
Create a Products child form. Create a new DataSource that uses all of the fields in the Product table. Use the DataGridView when dragging the Product table to the Products form.
Create an Orders-OrderDetails child form. Create a new DataSource that uses all fields from the Orders table and all fields from the Order Details table.
Use the ‘Details’ selection when dragging the fields from the Orders table to the form.
Use the ‘DataGridView’ selection when dragging the fields to the form from the Order Details table.
When dragging the Order Details fields, be sure to select the Order Details table that is nested within the Orders table in the data sources window and not the ‘stand alone’ Order Details table.
Note: In the schema file for the dataset, right click on the line connecting the Orders and Order Details tables. Click the “Edit Relation” option that appears in the context menu. Order is the parent table and Order Details the child table. Select ‘Both Relation and Foreign Key Constraint’ and cascade in the drop down boxes for both Update and Delete Rules. Double check the Order form to ensure the Order table fill automatic code is before the Order Details table fill code in the Form_Load event.
Play the Birthday Song if it’s the employee’s birthday. You will need to find an employee whose birthday is on the current date or change an employee’s birthday to test this. Changing the date requires update rights to the Employee record.
About the Test Data :
Each child form must load from the menu item and the tool strip button and correctly display the information from the appropriate DataSet.
Navigation is correctly coordinated on the Orders – Order Details.
The date and time must display on the MDI Parent form when it runs.
Each arrangement (cascade, horizontal, vertical) of child forms must work from the Windows menu.
Use the Test Scenarios supplied in the Assignment folder to create a Test Plan Execution Log. Execute the test scenarios and record the results in the test plan execution log.
I already have created the database and the log file I just need help creating the actual forms.
Create a Visual Basic application that meets the following requirements:
Follow class/textbook standards for Windows form design.
Use an MDI parent form.
Use separate child forms for each area of selected information.
All forms must include a tool icon from the Tool Graphics and Icons zip file that was attached to Assignment 1.
All child forms and the About form must display the Tool icon and the Vandeman’s logo (also in the zip file attached to Assignment 1.)
You will use the VANDEMANS SQL database included with this assignment.
Create an MDI parent form that contains a menu strip and a tool strip. Use buttons for the tool strip.
Include a status bar that displays the date and time in two separate panels at the bottom of the MDI parent form. (You will need to add the status bar to your tool box.)
On the MDI menu provide
A file menu to allow the user to open child forms, print the active form and exit the application
A windows menu that allows the user to arrange the open child forms (cascade, horizontal and vertical.)
A help menu that displays an About Box using the About Box Windows forms template.
Create an Employees child form. Create a new DataSource that includes all fields in the Employee table. Use the ‘Details’ selection for the dataset and change the EmployeeLastName control to a Combo Box. Follow the instructions on pages 417-419 of the textbook to set up the Combo Box to set data bound items. Update the SELECT statement with a WHERE clauseso that the Employees are displayed in alphabetical order by EmployeeLastName.
Create a Products child form. Create a new DataSource that uses all of the fields in the Product table. Use the DataGridView when dragging the Product table to the Products form.
Create an Orders-OrderDetails child form. Create a new DataSource that uses all fields from the Orders table and all fields from the Order Details table.
Use the ‘Details’ selection when dragging the fields from the Orders table to the form.
Use the ‘DataGridView’ selection when dragging the fields to the form from the Order Details table.
When dragging the Order Details fields, be sure to select the Order Details table that is nested within the Orders table in the data sources window and not the ‘stand alone’ Order Details table.
Note: In the schema file for the dataset, right click on the line connecting the Orders and Order Details tables. Click the “Edit Relation” option that appears in the context menu. Order is the parent table and Order Details the child table. Select ‘Both Relation and Foreign Key Constraint’ and cascade in the drop down boxes for both Update and Delete Rules. Double check the Order form to ensure the Order table fill automatic code is before the Order Details table fill code in the Form_Load event.
Play the Birthday Song if it’s the employee’s birthday. You will need to find an employee whose birthday is on the current date or change an employee’s birthday to test this. Changing the date requires update rights to the Employee record.
About the Test Data :
Each child form must load from the menu item and the tool strip button and correctly display the information from the appropriate DataSet.
Navigation is correctly coordinated on the Orders – Order Details.
The date and time must display on the MDI Parent form when it runs.
Each arrangement (cascade, horizontal, vertical) of child forms must work from the Windows menu.
Use the Test Scenarios supplied in the Assignment folder to create a Test Plan Execution Log. Execute the test scenarios and record the results in the test plan execution log.
Explanation / Answer
Full-fleged solution to this assignment requires access to zipped file and database mentioned in the problem statement. But these have not been made availavble. However, you can use the following tips for completing your assignment (assuming you are using MS Visual Studio):
1. Creating an MDI form:
a) First create a Windows Forms. This can be created as below:
Public Class MDIForm
Inherits Form
Public Sub New()
End Sub
<STAThread()> _
Public Shared Sub Main()
Application.EnableVisualStyles()
Application.Run(New MDIForm())
End Sub
End Class
b) Inside the constructor, set 'isMdiContainer' property to be 'True'. Once this property is set, your form will work like an MDI form.
Public Sub New()
isMdiContainer=True
End Sub
1. Creating a child form: Creating a child form is just like creating another form. The only thing you need to set the 'MdiParent' property.
For example:
Here, MdiParent property of ChildForm is set to 'parent' form. This makes 'ChildForm' the child of an already created MDI form.
3. Creating menustrip: A menustrip can be created as:
For example, following code creates a menustrip and adds it to MDIForm with a menu item.
Public Sub New()
isMdiContainer=True
menustrp.Items.Add(fileMenuItem)
Me.Controls.Add(menustrp)
End Sub
4. Creating a toolstrip: A toolstrip can be created as
For example:
Public Sub New()
isMdiContainer=True
Dim toolstrpButton1 as New ToolStripButton()
toolstrp.Items.Add(toolstrpButton1)
menustrp.Items.Add(fileMenuItem)
Me.Controls.Add(menustrp)
End Sub
Note: Example code is for your tips only. You will need to change the example code as per the requirements of your assignment.