Creating a database with a table

Assignment Help Data Structure & Algorithms

Reference no: EM1380696

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: EM1380696

Questions Cloud

Illustrate what are chief policies-practices and systems : Illustrate what are chief policies, practices, and support systems also management approaches that underlie Manpower's strategy execution efforts?

Explain purposes also key provisions of rehabilitation act : Explain purposes also key provisions of Rehabilitation Act of 1973 also Americans with Disabilities Act of 1990. Have employee attitudes toward disabled changed as a result of se pieces of federal legislation

Creating asp.net project with visual studio.net : Design an ASP.NET assignment with Visual Studio.NET 2005. Add an aspx form to the application. Place a ListBox control, a TextBox control and a Button control on the form.

Illustrate what effect should a realistic job preview have : Illustrate what effect should a realistic job preview have on a new hire's attitude also behaviour.

Creating a database with a table : Design a database with a table called tblStudents and use Visual Studio.NET 2005 to create an ASP.NET project with four aspx forms. Use Master Pages to show a school name.

Illustrate what is a virtual organization : Illustrate what is a virtual organization. Illustrate what would you say are biggest challenges to creating an effective virtual organization.

Illustrate difference between line-staff personnel : Illustrate what is difference between line personnel also staff personnel. Explain why are two groups so often in conflict. Would you rather have a line job or a staff job.

Creating an exception class and applet file : Create an applet document that prompts the user for an ID number and an age. Construct an Exception class and throw an Exception of that class if the ID is not in the range of valid ID numbers.

Find article related to capital structure summarize it : Find article related to Capital Structure 2012 summarize it also explain why it is important also explain problems also write name of author also name of website.

User Account

All Pages