DD Class13
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
- 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
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 - source
Homework
Post image of your diagram. Be sure it is properly documented. Show your name and the course semester and name.
Large format up to 700 px wide and thumbnail that is 175px wide
Fill out skeleton files for you final project. All the aspx pages that make up you project should be created. They don't all have to work but they should all be linked, names and have notes on how the page is going to work.
Have questions ready for next week. If there is anything you need help with or somehting you need ot learn to accomplish you project be ready to ask.
Final
Classified site.
UserName PostTitle PostDetail PostCategory CityName RecCreationDate
People
PeopleID
UserName
Password
IsAdmin
Post
PeopleID
PostTitle
PostDesc
PostCategoryID
RecCreationDate
PostCatetgories
PostCatID
PostCategotyID
PostCategoryName
City
CityID
CityName
Site Skeleton
Default Page
- Show Cities and Categories
Posts Page
- Shows Posts by City or Category
New User
- Add a new User to the
Logon
- Check user name and password
Protected Pages New Post
- People post new posts in a city and a category
Admin\Categories
- Create Update Delete Categories
Admin\Cities
- Create Update Delete Cities