ISC 361
Database for Info Systems
Fall 2008

Section 101 

Syllabus

Introduction 
.Net
ASP.Net
.Net Questions (doc)

Claytor's Cottages
Database (zip)
Step-by-Steps for attaching database (doc)
Code snippets for best-practices (txt)

Videos from class
UserProfile I (avi), II (avi), III (avi)
Database connection (avi)
Validate Guest I (avi), II (avi), III (avi)
Navigation Check (avi)
Role-based security (the end of the discussion) (avi)
Implementing the drop down box for 1:M (avi)
Step-by-Step for creating n-tier architecture in VS (doc)
Creating the call and respond path (avi), (avi)
Guest list:
  Bind to gridview (avi)
  Command button in gridview (avi)
  Find button for gridview (avi)
  Exception handling (avi)
Reservation list:
  Bind to gridview (avi)
  Edit Reservation button (avi)
  Delete Reservation button (avi)
  Get Reservation Info (avi)
Edit Reservation
  Add a drop down list for RoomID (avi)
  Update reservation (avi)
  Insert reservation (avi)

Web Services
 Create Business facade with WS project (avi)
 Expose method ValidateUser as a web service (avi)
 CRUD operations for EditReservation as web services (avi)

Code snippets
SQL for data tier (sql) (remove the .txt extension when using "save as.")
Code for index.aspx (txt)

Scripts for Architecture Overview Demonstration (Jan 30)
Presentation Tier (Vb.Net)
BusinessLogic Tier (C#)
DataAccess Tier (C#)
ApplicationBlock Tier (Remove the .txt extension before downloading with "Save Target As...")

AJAX
  Clay Davidson article (doc)
  ASP.NET AJAX Download Center (http://www.asp.net/ajax/downloads/default.aspx)
  ASP.NET AJAX Control ToolKit samples (http://www.asp.net/ajax/ajaxcontroltoolkit/samples)
  Toolkit "How Do I?" videos can be found here: http://www.asp.net/learn/videos/default.aspx

  AJAX, ADO.NET and XML (ppt)

[home]