using Visual studio:(note : the language used in the web from is C#) 

the following database stored in university.mdf file. And it’s connectionString is: “Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=|DataDirectory|university.mdf;Integrated Security=True;Connect Timeout=30”

The database consists of the following tables:

1.       Student (ID: int, name: varchar(30), address: varchar(30), password: varchar(15))

2.       Course (cno:int, cname:varchar(20),crs:int)

3.       Enrolled (stno: int, cno: int, grade: int)

 

Build a project that has two pages as described below:

·         login.aspx:  allows the student to enter his ID and password using two text boxes and then clicks a button.  After clicking the button, the student is either forwarded to another page named main.aspx if his ID and password are correct (same as those stored in the database). Otherwise, a message is displayed on a label (or using a message box) indicating that student ID or password are incorrect.

1.       The main.aspx will ONLY be displayed after the user enters a valid ID and password. Otherwise, the user/student is forwarded to login.aspx.

2.       Student name and grade are displayed on the top of the page (using a label) right after the page is loaded. In addition, registered courses of the logged-in student are displayed in a list box.

3.       The main page contains three buttons; Button1, Button2 and Button3 that works as follows:

a.       Button1 is used to delete the selected course (in list box) from the list box only (not from the database).

b.       Button2 is used to register a new course to the list of student courses. It directs the user to another page named add_courses.aspx.

c.       Button3 is used to end user session (logout).

         add_courses.aspx:

1.       If the page is requested before successful login, the user will be directed to login.aspx.

2.       Right after page is loaded,  all the courses in the course table are loaded into a DropDownList control And a list box (ListBox1) displaying the student registered courses.

3.       The page contains two Buttons (Button1 and Button2) that work as follows:

a.       Button1 allows the student to add the selected course in the DropDownList to a List of type Course (hint: implement a course class with the following attributes cno, cname and crs). The selected course should also be added to ListBox1.

b.       ListBox1 should not contain any duplicate courses.

c.       Button2 is used to store delete the selected course from the list box.