Difference between revisions of "DD Class1"

esse quam videri
Jump to: navigation, search
Line 105: Line 105:
***Windows XP sp2 (in the msdnaa library)
***Windows XP sp2 (in the msdnaa library)
*Modify the
*Modify the http://iam.colum.edu/DD/gbrowser.php?file=/classsource/class1/XMLCheese.xml and the HelloData.aspx page to show some of your own data

Revision as of 05:03, 25 January 2007

Into and Data Design

Read Syllabus

DD Syllabus

C# Review

Important c# concepts

If you feel you need help with c# I strongly suggest getting and reading

Learning C# ,Jesse Liberty O'Reilly & Associates;
(September 2002), ISBN: 0596003765

History of Databases

Flat Files

Hierarchical Databases


Network Databases

Relational Databases


Object DataBases


Microsoft API's

MDAC Microsoft Data Access Components



Data access in c. Mature open protocol


Data access in c++. More abstract. Fast


Built on top of OLEDB to allow access from other Languages


.NET Data api. Based on XML


Part of ASP.NET 2
70% reduction in code

Data Servers

Client/Server Model

Older model with dedicated clients


OnLine Transaction Processing

ADO.NET used the Data Provider and Data Consumer model.

ASP.NET and ADO.NET Examples

XML File full of cheese


The New way. This example uses a flat file as a Data Source. If also has ZERO code.

HelloData.aspx Source

The Old way.

The old model usually involved

  • Connection
  • DataAdapter or DataReader
  • Command
  • DataSet
  • DataTable
  • Bindable Controls

HelloDataOld.aspx Source

In class

Make HelloData.aspx and HelloDataOld.aspx


  • Read Intro and Chapter 1 'Data Modeling Past and Present' in Beginning Database Design (BDD)
  • Read Intro and Chapter 1 'Introduction to ASP.NET 2.0 with ADO.NET' in Beginning ASP.NET 2.0 Databases (BAD)
  • Install Visual Studio Pro 2005
    • PC Requirements Windows XP sp2 or Vista
    • OS X requirements
      • Microsoft Virtual PC (in the msdnaa library)
      • Windows XP sp2 (in the msdnaa library)