Prepare a database with a table called tblNames and tbl Login. The tbl Names table should have the following columns.
SSN - of type text. Set this as the Primary Key.
FirstName - of type Text.
LastName - of type Text.
The tblLogin table should have the following columns.
ID - this is the Primary Key. It type is auto number.
UserName - of type Text. It should be set to a unique value
Password - of type Text.Add several records to this table. Use Visual Studio.NET 2005 to create an ASP.NET application with three aspx forms.
The first form is a login page that contains a Login control. Users cannot view the other forms until they have successfully logged onto the application.
The second form contains a Grid View control. The Grid View control will allow the user to (1) view the entries in the database table and (2) update the first name and last name entries.
The last form contains three Text Box controls labeled "Social Security Number," "First Name," and "Last Name," a Button control, and a Label control. When the user presses the button, their entry is added to the database.
Use a Regular Expression Validator control to confirm the user entered a properly formatted social security number. Use Required Field Validator controls to confirm the user entered a string in the other text boxes. Use Try...Catch to display an error message in the Label control, if the user tries to enter a social security number already stored in the database.
The name of your Visual Studio project should be based on your last name. For example, if your last name is Jones, then assign the name, Jones_IP3.