CSE686 - Internet Programming

Lecture #8 - ADO and Ajax

Revised: 09 July 2009
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. Project Demonstrations:
  3. Note about Lab #8:
    I've discovered how to fix the session issue with Lab #8. The most important ingredient after setting Asp.Net compatibility mode, as we did in class, is to set the ServiceBehavior for PerSession host object instantiation. That's done on line 18 of FileService.cs. You'll find my solution here.
  4. Starting Windows Services Programmatically by Supreeth Murthy
  5. System Stored Procedures - DatabaseProject
  6. Asp.Net using SQL and Linq Demos:
    BooksView, BooksView folder
    BooksView is a small site managing a books database with Tables for Books, Authors, AuthosBooks details, and Publishers. The site was built with Asp.Net and ADO, which entails a couple of limitations, as we will discuss.

  7. ADO Tutorials
  8. Asp.Net Topics
  9. Simple File Service (for Lab starter)
  10. File Streaming Service hosted in IIS
  11. Ajax Topics: