Advanced Data Presentation Techniques via the Internet

1
Advanced Data Presentation Techniques via the
Internet

• Session IIA
• Active Server Pages
• Henry Weigel
• May 24, 2000
• Bangladesh Ministry of Energy and Mineral
  Resources

2
The Intranet Approach

• The use of scripting and coding
• Allaires Cold Fusion
• Microsofts Active Server Pages (ASP)

3
The Basic Idea

• Interactive with user
• Dynamic data (information) retrieval
• The use of a database
• Using queries to define data be requested or sent
• Using Structured Query Language (SQL)

4
Example 1 The Office Intranet

• Initially developed by a manager
• To be extended to the Agency
• Uses ASP
• Linked to password-controlled database

5
Example 2 The Monthly Energy Review

• Using scripting and code
• Selection lists for predefined data tables
• Data retrieved from database
• Demo using a Personal Web Server
• ..\Session3\MER_Demo\default.htm

6
Active Server Pages (ASP)

• A Microsoft product announced July 1996, shipped
  December 1996
• ASP is a technology for building dynamic and
  interactive web pages
• Runs on Internet Information Server
• Runs on Personal Web Server
• Two-way communication between user and web server
  (database)

7
ASP How It Works

• Used with html generates html pages
• Read request from browser (ditto html)
• Finds the page on the server (ditto html)
• Performs any instructions provided by ASP to
  modify the page (not in html)
• Send the page back across the Internet to the
  browser (ditto html)

8
ASP Advantages Over HTML

• HTML is interpreted by the browser, not executed
  on the server
• Can edit database rather than web page code
• Customize pages
• Communicate with database from the browser

9
Microsofts FrontPage

• Tool for developing web pages using wizards
• Manage a Personal Web
• Graphical user interface for HTML and ASP page
  development
• FP98 and FT2000 server extensions

10
The Use of HTML and Active Server Pages

• The Offices Intranet
• ..\Session3\EMEU_Intranet\emeusafe\default.asp

11
Home Page
12
Products Page
13
Performance Statistics
14
Performance Statistics 2
15
Posting News/Notes
16
Using MS Front Page
17
Themes Feature
18
Navigation Bar Properties
19
Shared Borders
20
Hyperlinks Schematic
21
Navigation Through Pages
22
Drag and Drop Pages
23
The Use of Input Forms
24
ASP Connecting to Database
25
ASP to Query the Monthly Energy Review

• An Example of writing code to invoke ASP
  functionality

26
MER Title Page
27
MER Second-Level Page
28
MER Second-Level Page, Contd.
29
MER Third-Level Page
30
Back to Second-Level
31
Another Third-Level
32
MER Title Page Consumption
33
MER Energy Consumption
34
MER Consumption 2
35
MER consumption 3
36
Title Page Code 1
37
Title Page Code 2
38
Title Page Code 3
39
FrontPage 2000 and ASP Major Steps in Development

• Open FrontPage, (web server must be running)
  Select File, New Web, Personal Web
• Theme and Shared Borders
• Identify External info for inclusion
• Develop HTM Pages
• Develop ASP Pages
• Hook Pages together
• Define other hyperlinks

40
Open New Web in FrontPage2000
41
FP2000 Theme Selection
42
FP2000 Banner Properties
43
FP2000 Shared Borders
44
Navigation Bar Properties
45
FP2000 Page Properties
46
Page Navigation
47
Home (Default) Page
48
Database Connection

• Establish ODBC Database connection in Start,
  Settings, Control Panel, ODBC, System DSN, Add
  mdb driver and select Database
• Insert Menu Database, Results
• Use new DB connection Create
• Select Database, Add, Select System data source
  on web server, Browse, Verify. Use existing DB
  Connection
• Make selections from Wizard
• Select Record and edit fields

49
ODBC Connection
50
DB Wizard Make a DB Connection
51
DB Wizard Select Record Source
52
Edit the Field List
53
DB insert Table Structure
54
Coal Database Connection
55
Electricity Database Connection