ISC 361
Database for Info Systems
Fall 2007

Section 101
 

 

Syllabus

Scope document (doc)
Evaluation of existing interface (doc)

UsaTube SQL scripts
  Template for table creation (sql)
  CRUD sproc in-class demo (sql) (updated 09/24/2007
  Sprocs and tables for Role-Based security (sql )
  sql DDL for Triggers (sql) (link article on audit tables)

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

n-tier architecture and Call-and-Respond path (AVI files)
Architecture setup (avi)
HelperClass setup (Application Block) (avi)
Presentation Tier setup (avi)
Web Config setup (avi)
Login call-and-respond path
   Presentation tier (avi)
   Data Access tier (avi)
   Business Logic tier (avi)
   Call and Respond path (avi)
   Edit User Info (avi)
   Insert User Info (avi)
   File upload Part I  (avi), Part II (avi)
   Insert Video Data Access (avi), Presentation tier (avi)
   Display list of videos in GridView Part I  (avi), Part II (avi), Part III (avi)

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)

AJAX demo
Files and walkthrough avi files for installing and configuring AJAX
  Extensions (msi)
  Getting stated with AJAX (avi) (try this avi file)
  Adding AJAX to an existing project (avi)
  Installing and intro to AJAX toolkit (avi)

Tab container  (avi)

 code for Index.aspx (zip)


MS Patterns and Practices
Application Architecture for .NET: Designing Applications and Services
       Introduction (http://msdn2.microsoft.com/en-us/library/ms978340.aspx)
       Designing the Components of an Application or Service (http://msdn2.microsoft.com/en-us/library/ms978348.aspx
)
Design and Implementation Guidelines for Web Clients
       Managing State in Web Applications (http://msdn2.microsoft.com/en-us/library/ms978622.aspx
)
.NET Data Access Architecture Guide (http://msdn2.microsoft.com/en-us/library/ms978510.aspx
)

Link to materials from last year

[home]