In this lesson we add Save, Delete, Add, Modify functionality to the Navigation Bars which we built in the first part of the System Administration Function Form.
This lesson builds on our previous XML User Login and New User Application Lessons to complete the Administration Form and Functions.
This lesson is part of a group of lessons where we build a complete User Login and Administration System.
We start using the Admin Screen we built in Part 1 which displays the Applicants XML File as a DataGrid View, and the Registered Applicants from the User Details XML File as a Navigator Form underneath this.
We add functionality to Admin Form we have built in previous lessons including building and testing the following features.
We use Search and Update Processing in the Data Grid View of Applicants to Log and Track changes that we make to the User Details file.
We will also learn several important VB.Net processing techniques for Data Grids and Data Tables.
The Step by Step Guide which is available below for this lesson, shows exactly what needs to be done.
This Guide has all of the Design Principles and Theory behind what is being done at each stage of application development.
Included in the Resources Download for this lesson are Visual Basic Code Listings, as well as Form Designs and Images.
If you are a Teacher or Instructor 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 the video for this lesson which goes through everything in full detail slowly step by step with repetition of examples.
Note that the example Lesson Images shown on this web page are basic Printscreens, whereas the actual original Images are of perfect clarity and quality in the downloadable PDF Guide for this lesson.
LESSON OVERVIEW
This lesson consists of a Video Presentation where we cover the following:
- Lesson Introduction
- Preview of Finished Program
- Learning Objectives
- Sort Data Grid View records into Ascending Order
- Register New User and add to UserDetails.xml
- Adding New Copy/Paste icon to a Navigation Bar
- Program Code to Copy values from Data Grid View to Data Table
- Program Code for Save icon to save Data Table to Xml File
- Fixing Duplicate User ID Program Crash if Save icon clicked twice
- Find and Update New User to "True" in Applicants Grid and File
- Delete a Registered User Intro and Overview
- Are You Sure ? (Yes/No) for a Delete
- Delete of User from User Details File
- Applicant Update to "True" issue for a Delete
- Finding and Setting deleted User to "UDeleted" in Applicants Grid and File
- Backout Processing for Admin saying "No" to Are You Sure? to delete message
- Renumbering User Details records to fix any deleted record sequence gaps
- Placing Group Box around Applicants Data Grid View
- Fixing Font Size and Colour Inheritance Problems on Data Grid View
- Adding Save icon Program Code to Applicants Navigation Bar
- Deactivating Delete and + icons on Applicants Nav Bar
- Change User's Password Functionality
- Format Acknowledgement Email Text for a newly added User
- Regression Test the Login and Administration System
- Challenge Task
- Doing our Website Programming Course
- Video Wrap Up and Outro
Watch the following YouTube Video Tutorial about Adding System Administration Part 2.
We recommend you use the RESOURCE MATERIALS available below
to follow along step by step with the Tutorial Video.
The YouTube Video is free to watch as many times as you want, and the Lesson Build Guide including all required Images and full program code listing(s) are available at a small cost which can be paid for and downloaded using PayPal.
Before purchasing and downloading the following resources, check first with your Teacher or Instructor, as they may already have copies of these documents to give to you.
Our Programming Learning Modules are designed for complete beginners, and they have been extensively trialled with High School students learning Programming for the first time. They have a proven track record of being able to get everyone up and running with Microsoft Visual Basic - the world's most popular Beginner Programmer's language.
We highly recommend using the Step by Step Summary Guide as well as the other support materials to maximise learning outcomes.
Our students have found the Summary Guide to be far more useful than re-watching the Video, when it comes time for them to apply their newly acquired skills to Application Build tasks.
Prices for the Resource Package including the Guide, Images, Form Design, and full Program Code Listings are:
A Single Computer Licence for Personal Use is $AUD 2.50 (Approx $US 1.88).
A Site Licence for Business or Education Training for up to 30 people is $AUD 5.30 (Approx $US 3.97).
Licence Documentation will be included in your Downloads.
Click the appropriate PayPal Button below to be taken to PayPal's secured Gateway and complete your purchase.
The Transaction will be labelled on your PayPal Statement as "PASSYTUTES", and upon payment completion you need to click the PayPal option to "RETURN TO SELLER'S WEBSITE". (THIS IS VERY IMPORTANT AS SELECTING THE "RETURN TO SELLER'S WEBSITE" OPTION TAKES YOU THROUGH TO OUR SECURE DOWNLOADS PAGE.)
On the Downloads Page you will be able to easily and directly Download your purchased Digital Products.
If you experience any problems please email us immediately at:
One known issue is that if you PayPal buy using Mircosoft Edge, it often displays prices with A's around them like: A$2.50A.
The Edge purchase will work okay, but it is probably best to do Pay Pal purchases using Google Chrome as your browser.