Difference between revisions of "DD Class13"
esse quam videri
Line 9: | Line 9: | ||
:replace regionID, milkID in details view with dropdowns and real names | :replace regionID, milkID in details view with dropdowns and real names | ||
− | ==DataView | + | ==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 | ||
Revision as of 04:32, 26 April 2007
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
Work on final project