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]