ASP Examples

The Following Are ASP examples on how to connect and manipulate the students database:

Create this table:
CREATE TABLE   students
            (    StudentID                     Int                       Identity    Primary Key,
                 FirstName         Varchar(20)        Not Null ,
                 LastName         Varchar(30)        Not Null,
                 DateOfBirth      Varchar(30)        Not Null,
                 Email                Varchar(30)        Not Null)

Insert the following values: 
INSERT INTO students( StudentID, FirstName, LastName, DateOfBirth, Email)
VALUES ( 95000, 'Mary', 'Smith', 'Jan-4-1984' , 'mary@uncg.edu')
INSERT INTO students( StudentID, FirstName, LastName, DateOfBirth, Email)
VALUES ( 95220, 'Lindsay', 'Stewart', 'Feb-10-181' , 'lindsay@uncg.edu')
INSERT INTO students( StudentID, FirstName, LastName, DateOfBirth, Email)
VALUES ( 95345, 'John', 'Adams', 'Mar-1-1970' , 'john@uncg.edu')

N.B: To run these scripts you have to use the university's network
1) Setting up a connection using DSN (ODBC) and Retrieving Data
2) Creating an HTML Page to take User Input
3) Deleting Records
4) Updating Records