Scenario/Summary

In this week's lab, we will create a login form, validate a user based on their login name and password, and allow them to access the system or not. We will assign a session variable to determine the user's level of security and allow certain functions to be displayed or not displayed in the existing frmPersonnel form depending on the assigned security level.

(NOTE: In some cases, the instructions for this lab will be less specific than in earlier labs, because you are expected to apply what you have learned in earlier weeks. Refer to the detailed instructions in previous weeks' labs if you need to do so.)

Please watch the tutorial before beginning the Lab.

Transcript Transcript

Deliverables

When you try to log in, if you use User Name = Mickey and Password = Mouse, the frmMain form should open with all links visible. If you use User Name = Minnie and Password = Mouse, the frmMain form should open with only the Salary Calculator, View Personnel, and Search options available. You will have a new option called Manage Users that will allow you to add new users and remove or update existing users. Once you have verified that it works, save your website, zip up all files, and submit it.

Note on database connections: We are using a SQLDataSource control for the Edit employees feature that we added. You should be using the connection string stored in the web.config file for your database connection for this control. Rather than creating a new connection each time, just use this connection.

If you change the folder where your website is stored (e.g., you copy each week's work to a new location), you will need to update the web.config. The advantage of using the database connection in the web.config is that you only have to set the configuration in one location.

Before starting this week's lab, make sure that everything is working and that all database connections are properly configured.