DD Class13

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. The website should by able to host classified posts by category by location. The posts should be readable by everyone but only people with accounts should be able to post. The the most current x number of posts should show in a location/category. A user should be able to edit their own posts but not others posts. Admins can edit everyone posts. Admins can also edit categories and location.

Optional (extra credit) posts have pictures. Posts use a rich text editor.

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

Admin\Edit posts

edit posts

UserName PostTitle PostDetail PostCategory CityName RecCreationDate

People

---

PeopleID

UserName

Password

Email

IsAdmin

Post

---

PeopleID

PostTitle

PostDesc

PostCategoryID

RecCreationDate

PostCatetgories

---

PostCatID

PostCategotyID

PostCategoryName

City

---

CityID

CityName