Derrick Awayevoo

Derrick Awayevoo

  • 2.2k
  • 5
  • 280

visual studio midsem exams. urgent m

Sep 12 2021 10:22 AM

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. 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.

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

Answers (1)