visual studio midsem exams. urgent m

Questions

1. Create a Database StudentDB
2. Create the table STUDENTS with the given fields

ID	GUID
INDEXNUMBER	VARCHAR	TEXTBOX
NAME	VARCHAR	TEXTBOX
GENDER	VARCHAR	RADIOBUTTON
USERNAME	VARCHAR	TEXTBOX
PASSWORD	VARCHAR	TEXTBOX
AGE	NUMERIC	TEXTBOX
EMAIL ID	VARCHAR	TEXTBOX
COURSE	NCHAR	DROPDOWNLIST
YEAR	NCHAR	DROPDOWNLIST

 

1. Create a Web App that uses a web service
   1. to display all the details of students from the database and bind it to GridView
   2. Create a Login Module in which the student enter Username and Password and print a welcome message with the student name for a successful login.
   3. Create the Web page that accepts indexnumber, name,gender,username password ,age , email id, course and year.

i.          All the information entry is compulsory.

ii.         Password should be reconfirmed.

iii.        Age should be within 21 to 40.

iv.        Email id should be valid.

1. 1. Create an update button that will update the year
   2. Create a delete button to delete the details of the student

      Questions

   3. Create a Database StudentDB
   4. Create the table STUDENTS with the given fields

   5. ID	GUID
      INDEXNUMBER	VARCHAR	TEXTBOX
      NAME	VARCHAR	TEXTBOX
      GENDER	VARCHAR	RADIOBUTTON
      USERNAME	VARCHAR	TEXTBOX
      PASSWORD	VARCHAR	TEXTBOX
      AGE	NUMERIC	TEXTBOX
      EMAIL ID	VARCHAR	TEXTBOX
      COURSE	NCHAR	DROPDOWNLIST
      YEAR	NCHAR	DROPDOWNLIST

       

   6. Create a Web App that uses a web service
      1. to display all the details of students from the database and bind it to GridView
      2. Create a Login Module in which the student enter Username and Password and print a welcome message with the student name for a successful login.
      3. Create the Web page that accepts indexnumber, name,gender,username password ,age , email id, course and year.

   7. i.          All the information entry is compulsory.

      ii.         Password should be reconfirmed.

      iii.        Age should be within 21 to 40.

      iv.        Email id should be valid.

   8. 1. Create an update button that will update the year
      2. Create a delete button to delete the details of the student