Difference between revisions of "DD Class13"

esse quam videri
Jump to: navigation, search
(Homework)
(Homework)
Line 51: Line 51:
  
 
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.
 
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.
 +
 +
 +
==LINQ==
 +
 +
c# 3.0 got some new features and key words
 +
 +
'''var'''
 +
:is a implicity typed local variable. it is strong typed you don't need to declare the type when you declare the variable.
 +
 +
''Anonymous Types'''
 +
:allows creation of structural types without declaring an name first http://msdn.microsoft.com/en-us/library/bb397696.aspx
 +
 +
'''Lambda Expressions''' =>
 +
: similar to anonymous methods. don't need to be declared first and don't need to specify return type http://msdn.microsoft.com/en-us/library/bb397687.aspx
 +
 +
new keywords http://msdn.microsoft.com/en-us/library/bb310804.aspx
 +
 +
http://iam.colum.edu/dd/classsource/LINQBlog/LINQTest.aspx
 +
 +
http://msdn.microsoft.com/en-us/library/bb397933.aspx

Revision as of 05:52, 24 November 2008


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


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.

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.


LINQ

c# 3.0 got some new features and key words

var

is a implicity typed local variable. it is strong typed you don't need to declare the type when you declare the variable.

Anonymous Types'

allows creation of structural types without declaring an name first http://msdn.microsoft.com/en-us/library/bb397696.aspx

Lambda Expressions =>

similar to anonymous methods. don't need to be declared first and don't need to specify return type http://msdn.microsoft.com/en-us/library/bb397687.aspx

new keywords http://msdn.microsoft.com/en-us/library/bb310804.aspx

http://iam.colum.edu/dd/classsource/LINQBlog/LINQTest.aspx

http://msdn.microsoft.com/en-us/library/bb397933.aspx