CSE686 - Internet Programming

Lecture #8 - Active Data Objects

Revised: 13 July 2008
Home Courses Code Handouts CoreTech Books Articles Math Research Masters Projects SWDev WebDev News OtherLinks SiteDesign Graduates AllPages Office Hours Notices Contents

CSE681-SWMAA CSE686-IP CSE687-OOD CSE775-DO CSE776-DP CSE778-AWP CSE784-SWS

Lecture #01 Lecture #02 Lecture #03 Lecture #04 Lecture #05
Lecture #06 Lecture #07 Lecture #08 Lecture #09 Lecture #10

Lab #01 Lab #02 Lab #03 Lab #04 Lab #05 Lab #06 Lab #07 Lab #08

Contents Syllabus

Web Resources:

Color Lab Color Codes HTML tags Everything HTML XML, HTML, Scripting Win32, COM, MFC webdeveloper.earthweb devx... W3Schools Web Developer's Virtual Library World-Wide Web Consortium WebReference devCentral

Office Hours:

Instructor & TAs

Content:

This lecture is concerned with Relational Databases and Active Data Objects and focuses on Examples relevant to the Final Project.
  1. Syllabus describes topics to be covered, reading material for you to digest before coming to class, and due dates for the assigned projects.
  2. Final Project #1, Final Project #2, Final Project #3, Final Project #4
  3. Final Project Demos Schedule,
  4. SQL Tutorials

    Introduction to SQL
    w3schools - SQL
    Programming with SQL
    SQL Tutorial
    firstsql

    Relational DB Tutorials

    The Relational Model
    Cal State Class Notes

    ADO Tutorials

    ADO QuickStart
    Overview of ADO Operations
    Asp QuickStart
    ADO articles
    Single Table Commands

    ASP.Net Tutorials

    Asp.Net videos - Recommended!

    Lecture Topics
  5. Revised Page Derivation Demo, Page Derivation files
  6. ADO Presentation
  7. Building Asp.Net Applications with Data Wizards
  8. Data Wizard Demos - Connections page
    Data Wizard Demos - Connections folder
  9. Data Wizard Demos - Commands page
    Data Wizard Demos - Commands folder
  10. Data Wizard Demos - DataAdapters and DataSets page
    Data Wizard Demos - DataAdapters and DataSets folder
  11. Test Connections page - Uses Forms Authentication
    Test Connections, Create SQL Scripts and Stored Procedures
  12. System Stored Procedures - DatabaseProject
  13. Update SQL Logs page
    Update SQL Logs folder
  14. Ajax Demo
    Ajax Demo folder
    Ajax Tutorials
    Microsoft implementation of Ajax
  15. SVG Experiment
  16. Silverlight Demo
  17. Asp.Net and Ajax
  18. Asp.Net Security Presentation
  19. .Net Security Models
  20. Demonstrate Windows Security Coding
  21. Lecture #8 folder contains a page of links to presentations and code discussed in this class. The Lecture folders will occasionally hold physical files of interest as well. Usually, however, all the materials of interest to the class are in the presentations and code folders. The contents of these folders will grow as you progress through the course.