Interactive Site Development
This course provides an introduction to Web site development using Microsoft's Visual Studio .NET. The student will learn how to create and maintain a Web site as well as how to use and manipulate database information over the Web. Visual Studio will be used to design HTML pages and Active Server Pages (ASP using server-side VB-Script) for a real world project. The course is designed for students with advanced knowledge in Web site development who want to apply their skills to a real word project in a team. It involves analysis, design, programming as well as a professional presentation of the project results.
Download the syllabus of COAP 3110
Download presentation slides and other files for COAP 3110
2-4 Students form a project team that will be responsible for
conducting and finishing a project.
The project requires to analyze and implement a Web application which
makes use of all techniques learned in the Web development classes
(HTML, databases, Flash,...).
The topic of this term's project is to build a Webster Student Portal
The documentation has to follow these templates:
The deadlines are firm. You will lose the points
listed in the syllabus if you
fail to deliver the documents in time.
All documents have to be submitted by e-mail
as MS Word or pdf files.
- Analysis document: November 4 - 12 pm
- Design document: November 14 - 12 pm
- Final documentation: December 16 - 12 pm
- Presentations are on December 18 and 20 during class hours
Installing Web Matrix
- Install the dotNET Framework, Web Matrix and MSDE.
In order to use the built-in web server as a non-administrator user
you have to give every user the rights for the directory
"C:\WINNT\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files"
(use properties as administrator).
Also you have to start Web Matix once as administrator and run the built-in Web server.
After this you can start developing with you own user id.
Using the DB MSDE
- You have to grant rights to the user that wants to access the
osql -E -S "mycomputer\instance" -Q "sp_grantlogin 'mycomputer\ASPNET'"
osql -E -S "mycomputer\instance" -d dbname -Q "sp_grantdbaccess 'mycomputer\ASPNET'"
osql -E -S "mycomputer\instance" -d dbname -Q "sp_addrolemember 'db_owner', 'mycomputer\ASPNET'"
mycomputer is your workstation ID
instance is the name of the SQL Server
dbname is the name of the SQL database you would like access to
- Execution of sql statements with the MSDE Data base tool.
- Create a text file with the sql statements, e.g. the file
creator.sql with the contents:
create table my_table (tmp int primary key);
- Start the osql tool on the command line:
osql -E -d michael -i creator.sql
(michael is the db name)
- Copy a database to a different server.
1. copy the following files (normally found in C:\Program Files\Microsoft SQL Server\MSSQL\Data)
to the new server (same directory there):
2. attach the DB to the new SQL server
osql -E -S "localhost" -Q "sp_attach_db @dbname = N'portal',
@filename1 = N'F:\where you\copied the files\your_database.mdf',
@filename2 = N'F:\where you\copied the files\your_database.LDF'"
change your_database.mdf and your_database.LDF to you db name
For more information on osql try: osql --help