Explore BrainMass
Share

Explore BrainMass

    Web Application Development - Visual Studio.Net

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Create a database with a table called "tblStudents" and "tblLogin." This table should have the following columns.

    StudentID -Text (Primary Key.)
    LastName - Text.
    TelephoneNumber - Text.
    Level (e.g. "sophomore," "junior," etc.)

    The table, tblLogin, should have the following columns -

    ID - Autonumber (Primary Key.)
    UserName - Text (set it to a unique value.)
    Password - Text.
    Add several records to this table.

    Use Visual Studio.NET 2005 to create an ASP.NET 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
    -view the entries in the database table
    -update the telephone number column.

    The last form contains three textboxes labeled "StudentID," "Last Name," and "Telephone Number" and a drop down menu with the entries, "Freshman," "Sophomore," "Junior," and "Senior," and a Label control. When the user presses the button, their entry is added to the database.
    Use a RegularExpressionValidator control to confirm that the user has entered a properly formatted telephone number. Use RequiredFieldValidator controls to determine if 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 student ID that is already stored in the database.

    © BrainMass Inc. brainmass.com October 9, 2019, 7:13 pm ad1c9bdddf
    https://brainmass.com/computer-science/web-design/web-application-development-visual-studio-net-111497

    Solution Preview

    Please see attached file.

    This is a web application for managing student's information.
    This has an access database with tables called "tblStudents" and "tblLogin." This table should have the following columns.
    StudentID -Text (Primary Key.)
    LastName - Text.
    TelephoneNumber - Text.
    Level (e.g. "sophomore," "junior," etc.)

    The table, tblLogin, should have the following columns -
    ID - Autonumber (Primary Key.)
    UserName - Text (set it to a unique value.)
    Password - Text.
    Added several records to these ...

    Solution Summary

    This solution is provided in two documents, a .zip and Word file.

    $2.19