Make a database with a table called "tblstudents"

Assignment Help Computer Engineering

Reference no: EM1336682

Create a database with a table called "tblStudents" with the following columns:

ID - Autonumber, Primary Key
Name - Text
Major - Text
Email - Text
Add several rows to this table.

Use Visual Studio.NET 2005 to create an ASP.NET project with four aspx forms. Use Master Pages to display a school name.

One form is called "start.aspx" and contains three TextBox controls that allow the user to enter his/her name, major, and student ID number. This form should appear when the user initially opens the application. (Hint: Use the Session_Start method contained in the global.asax file and the Response.Redirect method.) Use Session variables to save the user's entries.

The second form uses a GridView control to display the contents of the database table.

The third form uses a FormView control that displays one record at time. Provide buttons that allow the user to display a new record in the FormView control. The FormView control should also contain an "Add" button. When the user clicks this button, populate the fields of the DetailsView control with the data stored in the Session variables.

The fourth form uses a DetailsView control that also displays one record at time. Provide buttons that allow the user to display a new record in the DetailsView control. This form should only allow user to view the data. It should not allow users to modify the database.

Each form should contain a menu of buttons or hyperlinks that allow the use to move between city forms.

Use a RegularExpressionValidator control on the start page that displays an error message if the user does not enter a properly formatted e-mail address.

Please see below - very important

The directions state to provide "... three TextBox controls that allow the user to enter his/her name, major and student ID number." However, the ID field is an Autonumber data type in the database, therefore, you do not provide a value for that field when creating a new record because the RDBMS will perform that function. Therefore, the third TextBox control on start.aspx should be for the email address.

Making the above change supports the last requirement which is to "Use a RegularExpressionValidator control on the start page that displays an error message if the user does not enter a properly formatted e-mail address."

Reference no: EM1336682

Questions Cloud

Dual-court system and various sentencing goals : How might your choice of goal vary with the type of offense? Can you envision any circumstances which might make your choice less acceptable?

Explain expected return for an aggressive mix : Explain Expected return for an aggressive mix and Compute the anticipated return after financing costs on the most aggressive asset-financing mix

Define the utilization and efficiency : Define and discuss the utilization and efficiency.

Illustrate what would happen to the price level : If the demand for money depends positively on real income and depends inversely on the nominal interest rate, illustrate what would happen to the price level today if the central bank announces.

Make a database with a table called "tblstudents" : The third form uses a FormView control that displays one record at time. give buttons that allow the user to display a new record in the FormView control. The FormView control should also contain an "Add" button. When the user clicks this button, p..

Certain constitutional rights : Should juvenile offenders have a constitutional right to a jury trial? Should each state make that determination? Discuss the legal decision that addresses this issue.

Describe what type of foreign investments : Describe what type of foreign investments would be best for the economy's PPF. What are the opportunity costs of these decisions.

Explain marketing strategy select a segment and design : Explain Marketing strategy- select a segment and design a 'mix' that meets the needs

Determine the at&t strategic issues : Determine the AT&T strategic issues

User Account

All Pages