Difference between revisions of "DD Class13"
(→Review Data Diagram for final) |
|||
Line 22: | Line 22: | ||
*can the design acomplish your goals? | *can the design acomplish your goals? | ||
*are they over engineered? | *are they over engineered? | ||
+ | |||
+ | ==Final Requirements== | ||
+ | An aspx page must Insert, Update and Delete(or update to set but inactive) | ||
+ | |||
+ | |||
==Relational Controls== | ==Relational Controls== | ||
Line 46: | Line 51: | ||
==Homework== | ==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 | Work on final project |
Revision as of 15:51, 23 November 2008
Contents
Master Pages
- http://iam.colum.edu/dd/gbrowser.php?file=/classsource/class11/UserControls/TemplateIncludes.aspx
- http://iam.colum.edu/dd/gbrowser.php?file=/classsource/class11/UserControls/TemplateNoControls.aspx
- http://iam.colum.edu/dd/gbrowser.php?file=/classsource/class11/UserControls/TemplateUserControls.aspx
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
An aspx page must Insert, Update and Delete(or update to set but inactive)
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