ALL SOFTWARE EXERCISES
- EXERCISES HOME PAGE (750)
- Access 2010 (66)
- Access VBA Macros (17)
- Advanced VBA (29)
- ASP.NET MVC (0)
- ASP.NET webforms - C# (25)
- ASP.NET webforms - VB (27)
- Excel 2010 (83)
- Excel 2013 (10)
- Excel VBA Macros (37)
- Power BI - Excel 2013 (25)
- Power BI Desktop (0)
- PowerPivot 2010 (26)
- Report Builder 3.0 (42)
- SQL (115)
- SSAS - multidimensional (21)
- SSAS - tabular (29)
- SSIS Integration Services (18)
- SSRS Reporting Services (53)
- Visual Basic 2010 (42)
- Visual C Sharp 2010 (65)
- WPF - Visual C# (20)
WPF - VISUAL C# EXERCISES
Exercise: Linked listboxes and datagrids - a full(ish) application
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 the Wise Owl course 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.
This is perhaps an exercise to begin now, but finish on another day!
First run the SQL script in the above folder if necessary to create a database, if you haven't already done so. You'll also need to add the images in the above folder into your project.
To start, first create a start-up menu as follows:
When you click on the Exit button, your menu should close; when you click on the Bouncing Ball button, you should get a suitable animation (the contents of which are left to your imagination!).
When you click on View packs, you should see a list box listing out all of the Top Trumps packs taken from the tblPack table:
You should be able to click on any item in the list, then click on OK to select it (the Cancel button should just return you to the main menu).
If you select OK without choosing a pack, you should see an error:
You should display a suitable message if no item is chosen.
If you choose a pack and select OK, you should see the details for this pack:
The image and categories come from the tblPack record chosen in the previous menu.
If you click on the Show a card button, you should see the first card in the relevant pack:
See overleaf for some notes on how this should work.
The categories and scores for the window on the previous page should come from the underlying data (you may find the view already created called vwCard useful at this point). The previous and next record buttons should take you to the previous and next card record for this pack (this is the only part of the model answer which isn't coded).
For all of the windows, make sure that the Cancel buttons return you to the previous window or main menu, as you deem appropriate.
If you have time, you could try:
- disabling the previous/next record buttons at the appropriate times in the above window;
- adding a menu and toolbar to your system;
- moving all formatting to styles, so that the XAML contains only the control definitions and binding.
Or you could try having a go at the real system waiting for you in the office ... !