<last updated
PREREQUISITE: CSC1220-1(Intro to DataBase)
TEXT: Beginning ASP.NET 1.0 with C#
AUTHOR: Goode,Kauffman
, etal;
PUBLISHER: Wrox Press Ltd. ISBN:
1-86100-734-5
SOFTWARE: Windows 2000 Pro/Windows XP Pro; IIS; .NET
FRAMEWORK; MS Acesss 97/SQL Server 2000;
GRADING: Quizzes;Labs; Lab/Project; possible
final exam.
READ ch 1, 2, 6
& 8
HIGHLIGHTS: (ch 1) Installation
of ASP.NET on home computer;
(ch 2) anatomy of ASP.NET
(ch 6) C# Control Structures
(ch 8)
review of Object Oriented Programming (OOP)
LAB : lab1
READ ch 3, 7
HIGHLIGHTS: (ch 3) ASP.NET Server Controls – dropdownlist,
listbox, label, etc.
(ch 7) Event-driven programming and Postback
LECTURE DATASET
search; databinding; redirect; anchor.
LAB : lab2
READ ch 12 & 4
HIGHLIGHTS: (ch 12)Connecting to a database
(ch 4) Storing information in C#
LECTURE: updating a dataset/database
LAB : finish lab 2; start lab 3
READ ch 13 pp
500-529
HIGHLIGHTS: (ch 13) Manipulating
data –SQL; Stored Procedures,
LECTURE: lab 5 prep –
using component for rental fee and days out. (see packet 4)
LAB : lab 4; start lab 5
WEEK7 (
READ ch. 10
HIGHLIGHTS: Session variables
LECTURE: Session
variables; using
component
LAB finish :lab 5; Start lab 6
WEEK 8 (
READ ch. 5 Introducing XML;ch
13 pp. 529(XML)-536; xml_primer1.doc in packet 6
LECTURE: Dataset write & read XML; & DOM (Document
Object Model)
LAB lab 6
WEEK 9 (
NO CLASS –Spring Break
WEEK 10 (
READ ch 18 (web services)
LECTURE: Web Services; SQL
LAB finish lab 6 ; start lab 7
WEEK 11 (
READ)
LECTURE: EXCEL ado
LAB: continue lab
7
READ
LECTURE:
LAB : finish lab 7; start lab 8
I will be absent
READ
LECTURE:
LAB:
finish lab 8
READ
LECTURE:
LAB : start lab
9
READ
LECTURE:
LAB
READ
LECTURE:
LAB :
<return to top
LAB#2
General: Expand the login page as follows:
-Check for a valid ID;
-Check for a valid Password.
Directions:
1. Create an event-driven function that is triggered by clicking a button
server control.
2. The function will:
establish a connection to the video
database;
use the dataset select
method to search the employee table for
the employee id;
if a correct id is found, then
the password will be checked;
if an incorrect id is found, a
message indicating the condition will be placed in a text
box reserved for error messages;
if a correct id but wrong
password is found, a message indicating the condition will be
placed in a text box
reserved for error messages.
3. If a correct id and
password are found, then postaway (redirect)
to a main.aspx page
4. Create the main.aspx page..
LAB#3
General:
Create a page for adding new customers..
.
Directions:
1. Create text boxes for the data – use required field validators.
2. Add each new customer record to the database.
LAB#4
General:
Create a page for rentals.
Directions:
1. Create dropdown lists for customers and movies
2. Databind each dropdown. – use the PageLoad function
3. Create text boxes for the following:
copy id
date rented
date due
rental price
message box
4. Create a button.
LAB 5
General:.Write the script to process
rentals.
.
Directions:
Phase I (fill in all the text boxes)
1. Using the selected customer id and movie id, find an available copy
id.
2. Place the copy id in the copy id text box.
3. Place the current date in the date rented text box
4. Use the provided business component, to determine the date due and rental
price – place the data in their respective text boxes. (see
packet 6)
Phase II (update rental table)
Add a rental record to the rental table.
LAB 6
General:
Create the return page. .
Directions:
I Set up the server controls on the
page.
II Databind the
SELECT RENTAL ID dropdown box; place current
date in DATE RETURNED text box.
III Add rental record to archive table;
IV Delete the rental record.
V Determine the late fee using the business
component.
VI Update the moviecopies
table indicating the returned copy is not rented.
LAB 7
General:: Create an excel worksheet (using a C# script) that contains a sales summary of rentals. .
Directions:
1. Use
the following SQL statement against the
ARCHIVE table to create a dataset table.
SELECT STOREID, EMPID, COUNT(*) AS NUMRENTALS, SUM(RENTALPRICE) AS TOTRENTAL
FROM ARCHIVE
GROUP BY STOREID, EMPID;
2. Use the dataset table above to supply the data for the creation of an excel worksheet using a C# script..
3. More details will be furnished in class.
LAB 8
General: Create an alternative login.aspx
whereby the employee id and password validation is performed by a client-side
script that uses XML (see packet6(XML) and packet6b)
.
Directions:
LAB9
General: Upload Regional Sales to Corporate Database
using Web Service.
.
Directions:
LAB 10
General:
Miscellaneous
1. Manual refresh for return page: test 2 work stations performing
rentals and returns.
2. Automatic refresh to login page.
3. Full use of videorentalLib (see
packet 6).
4. Dynamic e-mail (Scripted e-mail).
.
Directions: