ALL SOFTWARE EXERCISES
- EXERCISES HOME PAGE (954)
- Access 2010 (66)
- Access VBA Macros (17)
- Advanced VBA (29)
- DAX (0)
- Excel (49)
- Excel 2010 (83)
- Excel 2013 (10)
- Excel VBA Macros (49)
- Power BI - Excel 2013 (25)
- Power BI - Excel 2016 (24)
- Power BI Desktop (26)
- PowerPivot 2010 (26)
- Report Builder (42)
- SQL (192)
- SSAS - multidimensional (21)
- SSAS - tabular (29)
- SSIS Integration Services (40)
- SSRS 2012 (53)
- SSRS 2016 (43)
- Visual Basic (45)
- Visual C Sharp (65)
- WPF - Visual C# (20)
VISUAL BASIC EXERCISES
- Drawing forms (2)
- Form events (1)
- Variables and data types (2)
- Enumerations and constants (2)
- Form validation (3)
- Menus and toolbars (1)
- Files and folders (1)
- Basic DataGridViews (1)
- Reacting to DataGridView events (3)
- Advanced DataGridViews (2)
- Creating classes (4)
- Coding in VB.NET (2)
- Variables and constants (3)
- Testing conditions (2)
- Passing arguments (3)
- Using arrays (2)
- Loops (2)
- Working with files (3)
- Lists (3)
- Creating properties (3)
Exercise: Create classes to facilitate writing your shopping list
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
The answer to the exercise will be included and explained if you attend one of more of the courses listed below!
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Right-click on your project in Solution Explorer and choose to add the form from the above folder (you can alternatively press SHIFT + ALT + A ).
The initial form. The idea is that when you type in an item and click on the Add Item button, it will be added to the list on the right.
First add code to the Cancel button so that clicking on it closes the form.
Remember that you can use me to refer to the current form.
Create a class called ShoppingList. Within this, create 3 simple properties, to hold the item name, unit and amount. Here's an example for the item name:
'item name property
Private _ItemName As String = ""
Public Property ItemName As String
Set(value As String)
_ItemName = value
You should now be able to attach code to the Add Item button which:
- Creates a new instance of your ShoppingList class;
- Sets the item name, unit and amount properties.
The only thing you need to add now is the code to add the item to the textbox on the right of the form. To do this you could add a public method to your class, which passes in the textbox to which you want to add text:
Public Sub Add(ListTextBox As TextBox)
'add a blank line if appropriate
If ListTextBox.Text.Length > 0 Then _
ListTextBox.Text &= vbCrLf
'add item to the list of items
ListTextBox.Text &= Amount.ToString("0.00") & _
" " & Unit & " of " & ItemName
Make sure that you call this method at the end of your Add Item button code, and test your system to check that it accumulates items to buy:
You'll gradually accumulate items in your list.
Test that your system works, then close the form down (don't worry for now that this will then lose your shopping list!).