DD Class13

esse quam videri
Revision as of 15:59, 23 November 2008 by Jeff (talk | contribs) (→‎Final Requirements)
Jump to: navigation, search


Master Pages

Master Page with ConentPlaceholders

Master Page

http://iam.colum.edu/dd/gbrowser.php?file=/classsource/class11/MasterPageClass11.master

Real Page with user controls

http://iam.colum.edu/dd/classsource/class11/UserControls/TemplateMasterPagesUserControls.aspx - source

Review Data Diagram for final

  • are they normal?
  • can the design acomplish your goals?
  • are they over engineered?

Final Requirements

  • Fully normal database
  • An aspx page must Insert, Update and Delete(or update to set but inactive)
  • ASPX databinding to datacontrols either SQLDatasource or ADO(dal) or both
  • Proper validation of webforms

Relational Controls

http://iam.colum.edu/dd/classsource/class13/cheeseGridViewMasterDetails.aspx http://iam.colum.edu/dd/classsource/class13/cheeseGridViewMasterDetails2.aspx

todo

replace regionID, milkID in details view with dropdowns and real names

DataView RowFilter and DataTable Select

data in a DataTable can be filtered by using DataTable.Select. DataTable.Select return an array of matching DataRows

You can also filter data by using a DataView. DataViews are similar to view in SQL they can be filtered by calling

DataRow.RowFilter. 

In both situation the string expression in the Rowfilter or passed in to the Select funtion should be a WHERE clause.


http://iam.colum.edu/dd/classsource/class13/DataView.aspx


Homework

Post image of your diagram. Be sure it is properly documented. Show your name and the course semester and name.

Work on final project

Retrieved from "http://imamp.colum.edu/mediawiki/index.php?title=DD_Class13&oldid=13240"