In this lesson we read in an XML File of Doctor Appointments, and then Search Filter and Sort this data using a program defined Results Data Table. This lesson will be useful to anyone building a VB.Net Application which requires Search and Filter functions.
This lesson builds on our previous XML File Processing Lessons.
Specifically we do the following:
- Set up a Data Grid View showing ALL Doctor Appointments
- Set up Search Buttons and Data Entry Boxes for Search/Filter Criteria
- Create Different Searches which produce Filtered Results
- Use an internal Program Data Table to store the Results
- Sort the Search Results on one to many fields in the Results Data Grid View
- Display the Search Results in a separate Data Grid View
- Clear and Reset the Data Table in between successive Searches
- Set up a Combo Box and a Date Picker to use for selecting Search Criteria.
See the full lesson contents in the Video Timeline Index further below.
It is recommended, but not essential, that you have done our previous lessons about working with XML Files.
This is a very long lesson, and so we recommend you use the YouTube "Tools Cog" on the payer bar to watch it at a speed of 1.5x or even 1.75x.
If you are a Teacher watching this video we suggest you click the downloads link below and get the lesson materials for your students.
Give these resources to your students and we think you will find that some of them will "get it" very quickly.
The other students need to watch this video which goes through everything in full detail slowly step by step with repetition of examples.
This is a detailed video, if you want to fast track learning about adding the finishing parts of the System Administration, then just Download and quickly read through the PDF of the Presentation using the Link given further down below.
There is also a downloadable Word Document giving all of the Form Designs as well as the Full Program Code that goes behind each Form.
Then for anything you do not fully understand in these two documents, simply use the Timeline Index below to go and watch the relevant section of Video explanation.
If you have the time it will be extremely beneficial to watch the entire video to maximize learning outcomes.
VIDEO TIMELINE INDEX:
(Click on the time number to jump to that section of the video).
00:00 to 01:16 Introduction
01:16 to 04:04 Preview of Finished Program
04:04 to 06:44 Lesson Contents List
06:40 to 08:31 Doctor Appointments XML File
08:31 to 09:34 Starting the New Project and Form
09:34 to 13:40 Multi-Step process to build Bound DataView
13:40 to 18:26 Setup and Add Bound DataGridView to Form
18:26 to 21:38 Add and Modify Group Box for DataGridView
21:38 to 23:37 Loading DataGridView using the XML File
23:37 to 24:54 Fixing Date Format Program Crash Problem
24:54 to 28:50 Fixing Boolean Data Program Crash Problem
28:50 to 30:09 Fine Tuning the DataGridView Display
30:09 to 31:04 Sorting DataGridView on one column
31:04 to 31:56 Set up Search Data Options on Form
31:56 to 36:07 Search 1 - Doctor Appointments
36:07 to 39:31 Test the Doctor Name Search Msg Boxes
39:31 to 45:44 Make Doctor Search Results DataGridView
45:44 to 46:44 Cummulative Appended Search Results Problem
46:44 to 47:43 Clearing the Results in between Searches
47:43 to 49:26 Testing the Doctor Name Searches
49:26 to 51:34 Sorting the Doctor Results on 2 Columns
51:34 to 54:13 Add Drop Down List for Doctor Name
54:13 to 54:54 Summary of Work Done So Far
54:54 to 58:57 Setting Up Date Time Picker for Date
58:57 to 01:00:55 Tips for Using the Date Picker
01:00:55 to 01:02:27 Coding Doctor + Date Search
01:02:27 to 01:04:20 Testing Doctor + Date Search
01:04:20 to 01:08:59 Coding Unpaid Bills Search
01:08:59 to 01:11:14 Challenge Task
01:11:14 to 01:11:54 Our Website Programming Course
01:11:54 to 01:13:41 Video Wrap Up and Outro
This video will be useful for anyone learning Computing, especially students doing VCE Computing or VCE Software Development or HSC Computing high school courses in Australia, and GCSE in the UK.
Check with your Teacher or Instructor before getting any Downloads from our Website, as they may already have these materials for you.
You can download a hard copy of this Presentation, all of the required Images and the Full Program Code at the following link:
Check with your Teacher or Instructor first, as they may already have these Download materials for you.
You can check out our full Programming Course at the following link:
We are planning to make a number of Programming Videos that will be a great course for people to learn how to program in Visual Basic.
Like this video if you found it helpful.
Subscribe to our Channel to get notified of our weekly video updates.
Enjoy,
Passy
0 Comments