Purchase Solution

Coding and design

Not what you're looking for?

Ask Custom Question

Create a database with a table called tblNames and tblLogin. The tblNames 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 autonumber.
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 GridView control. The GridView 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 TextBox 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 RegularExpressionValidator control to confirm the user entered a properly formatted social security number. Use RequiredFieldValidator controls to confirm the user entered a string in the other textboxes. 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.

Purchase this Solution

Solution Summary

Coding and design are encompassed.

Purchase this Solution


Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.