data enabled web sites classibooks com internet database technologies n.
Skip this Video
Loading SlideShow in 5 Seconds..
Data-Enabled Web Sites: & Internet Database Technologies PowerPoint Presentation
Download Presentation
Data-Enabled Web Sites: & Internet Database Technologies

Loading in 2 Seconds...

play fullscreen
1 / 28

Data-Enabled Web Sites: & Internet Database Technologies - PowerPoint PPT Presentation

  • Uploaded on

Data-Enabled Web Sites: & Internet Database Technologies. Colin Fukai April 4, 2000 Gonzaga University. Background. Education Gonzaga University: BBA (MIS, HR) - 2000 My “Internet Credentials” 4 years of web design/construction experience

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Data-Enabled Web Sites: & Internet Database Technologies' - suchi

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
data enabled web sites classibooks com internet database technologies

Data-Enabled Web & Internet Database Technologies

Colin Fukai

April 4, 2000Gonzaga University

  • Education
    • Gonzaga University: BBA (MIS, HR) - 2000
  • My “Internet Credentials”
    • 4 years of web design/construction experience
  • Contacting Me
  • Database connectivity and the web
    • The web is simply a new interface for structured data collections



Web Page

introduction cont
Introduction Cont.
  • Benefits
    • E-commerce $$$$$
    • Thin clients, dumb terminals, and centralized computing (web apps)
  • Drawbacks
    • Complexity
    • Time & Resources
    • Security
classibooks com
  • A “Meeting Place”.
  • Registered users (sellers) post their used textbooks.
  • Buyers browse the listings and then contact the seller.
  • does not sell anything, it just makes the connection between buyer and seller.
  • Database
    • MS Access
  • Web Server
    • NT Server 4, IIS 4
  • Server Side Scripting
    • ASP
  • Development Tools
    • Interdev, Visual Basic
  • Considerations
    • Size
    • Complexity
    • Separation of data and processes
  • Classibooks Database
    • Customer (seller)
    • Post (the book listings)
web server
Web Server
  • Microsoft NT Server 4
  • Internet Information Server 4 (IIS4)
  • Setting up a site with NT Server 4:
    • Internet Service Manager
    • Web directory (Inetpub/wwwroot/yoursite)
    • ODBC Connection (DSN)
server side scripting
Server Side Scripting
  • Code that is executed on the web server, as opposed to client side scripting that is run on the user’s web browser (e.g., JavaScript).
  • ASP = Active Server Pages
  • According to Microsoft:Active Server Pages is an open, compile-free application environment in which you can combine HTML, scripts, and reusable ActiveX server components to create dynamic and powerful Web-based business solutions.
server side scripting cont
Server Side Scripting Cont.
  • ASP is really just a way to “dynamically generate” web pages.
  • It is based on the Visual Basic language which is easy to use and familiar to many programmers.
  • Provides many powerful built-in capabilities, such as database connectivity.
server side scripting cont1
Server Side Scripting Cont.
  • How does an ASP page work?

ASP Page

<html><h1>My Site</h1><% Dim myVarmyVar = Time()Reponse.Write myVar%></html>

WEB Serverprocesses ASP page, returns results

USER (Internet Browser)

Static Web Page

a simple asp page example
A Simple ASP Page Example






<H1>My TEST ASP Page</H1>



Dim myVar

myVar = “Hello World”

Response.Write myVar




a closer look at the code




Tag indicates ASP code

A Closer Look at the Code


Dim myVar

myVar = “Hello World”

Response.Write myVar


a more complex example
A More “Complex” Example






Pass form values to this page


Submit the information




<title>Where Am I for sign-in sheets</title>



<h1>Type the information to make a sign-in sheet for the New Products seminar.</h1>


<form action=“Output.asp" method=post>

<p><input value="name of city" name ="City">

<p><input value="date of seminar" name ="Date">

<p><input type="submit" value="Click here to submit the information">





Get data from input box “City” and output it

Get data from input box “Date” and output it



<h1>Spokane Clothiers

Welcome to the New Products Seminar</h1>

Held In


Dim strCity

strCity = Request.Form("City")

Response.Write strCity




Dim strDate

strDate = Request.Form("Date")

Response.Write strDate


<p align="left">

Please sign in by printing your name at the front desk.



development tools
Development Tools
  • Microsoft Visual Interdev
    • Part of “Visual Studio”
    • Rapid Application Development for the web
  • Overview of the Interdev Integrated Development Environment
interdev ide
Interdev IDE

Project Explorer

Item Properties


Main Editing Window

interdev example
InterDev Example
  • What do we need to accomplish a simple page, connected to a database?
    • Win 9x or Win NT
    • IIS or Personal Web Server (PWS)
    • A database and working knowledge of how a simple DBMS like MS Access works.
    • Time and patience… the tools are more powerful and simple than ever, but that means more things can go wrong.
personal web server
Personal Web Server
  • Obtaining & installing
  • Good for workstation testing
  • Create a new site
  • Know what default page name is (default.asp, index.htm)
interdev example cont
Interdev Example Cont.
  • Create a new project
  • Create an ASP page
  • Create a database connection
  • Add a “recordset” to the page
  • Set that recordset’s source fields (SQL)
  • Connect form controls (e.g., listboxes) to the recordset or simply output it as text
  • View page
asp issues
ASP Issues
  • Connecting to the database
    • DSN = A file that contains commands for connecting to a database.
    • DSN or DSN-less?
  • ASP Components
    • Compiled modules of code that interact with your web site.
    • Separates business logic from the web pages themselves.
asp issues cont
ASP Issues Cont.
  • ASP Components Cont.
    • Components are written with fully featured languages like Visual Basic or Visual C++.
    • Modularity, Reusability.
    • How to use a component:
      • Compile component (.dll)
      • Register component on the web server
      • Create instance of component object in ASP code to access the component’s properties and methods.
asp issues cont1
ASP Issues Cont.
  • Sessions and maintaining state
    • The time a visitor is at your site, and all the actions they perform while there, is called a session.
    • Sometimes we want to maintain information (the state) about a user as they move from page to page. This is where ASP Session capabilities come in handy.
    • But, don’t use it. Use cookies or query strings to pass data between pages.
the alternatives
The Alternatives…
  • Chilisoft (
    • Run ASP on any web server, and not just NT
  • Cold Fusion (
    • Cold fusion markup language
  • PHPx (
    • It’s free!
asp resources
ASP Resources
    • Good starting point
  • Know what you want to accomplish BEFORE deciding how to construct it.
  • Do not invest in resources that you will not, practically, need, but do plan for the future – in other words, watch out for “chicken little” salesmen.
  • Put yourself in the user’s shoes.
  • Functionality and content above flashiness.
  • Data design as important as site design.