Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
26 Cards in this Set
- Front
- Back
|
Ch 11
5 data source controls |
1) SQLDataSource Control
2) ObjectDataSource Control 3) XMLDataSource Control 4) SiteMapDataSource Control |
|
|
Ch 11
Where are the data source controls derived from? |
The DataSourceControl class
|
|
|
Ch 11
DataSourceControl Class |
-Derived from Control Class
-Implements IDataSource and IListSource interfaces |
|
|
Ch 11
SQLDataSource Control |
The control to use if your data is in SQL or Oracle, OLE DB datasource, or WinCE datasource
|
|
|
Ch 11
Where does the list of providers come from? |
the DbProviderFactory node of machine.config file
|
|
|
Ch 11
DataSourceMode property of the SQLDataSource control? |
tell the control to use DataSet or DataReader internally
|
|
|
Ch 11
Firehose mode? |
The mode used when choosing DataReader mode
Forward Only, Read Only Cursor |
|
|
Ch 11
DataReader vs DataSet |
DataReader is fastest since doesn't have memory and processing overhead of DataSet
DataSet enables built in caching, and full CRUD functionality |
|
|
Ch 11
SelectParameters collection |
a collection used to filter out the exact values to pull from a data set
|
|
|
Ch 11
6 parameters of SelectParameters collection |
1) ControlParameter
2) CookieParameter 3) FormParameter 4) QueryStringParameter 5) ProfileParameter 6) SessionParameter |
|
|
Ch 11
3 properties of the parameter controls |
1) Type
2) ConvertEmptyToNull 3) DefaultValue |
|
|
Ch 11
Type (and props of parameter control) |
Allows strong typing of parameter
|
|
|
Ch 11
ConvertEmptyNull (and props of parameter control) |
Indicates control should convert the value assigned to it to Null if equal to System.String.Empty
|
|
|
Ch 11
DefaultValue (and props of parameter control) |
Allows to specify a default value for parameter if it is evaluated as Null
|
|
|
Ch 11
ConflictDetection property? |
Tells SQLDataSourceControl what type of conflict detection to use when updating data.
|
|
|
Ch 11
Types of ConflictDetection 1) OverwriteChanges 2) CompareAllValues |
1) Last in Wins - any changes made since reading will overwrite what's in db
2) good when multi users are updating. prevents conflicts |
|
|
Ch 11
How do you detect concurrency errors? |
Test AffectedRows property in SQLDataSource Updated event.
|
|
|
Ch 11
XMLDataSourceControl |
simple way to bind XML docs in memory or located on physical drive
specify XML, XSLT, XPATH |
|
|
Ch 11
ObjectDataSource Control? |
MOST ANTICIPATED CONTROL!
bind data controls to middle layer business objects generated from O/R mappers etc |
|
|
Ch 11
SiteMapDataSource Control? |
work with data stored in sitemap config file
useful if changing sitemap data at runtime (based on user privilege or status) |
|
|
Ch 11
2 caveats about SiteMapDataSource control? |
1) does not support caching
2) no configurtion wizards |
|
|
Ch 11
Cache duration and unit of measure |
Can set to specific time or INFINITE!
Time measured in seconds |
|
|
Ch 11
EnableCaching? |
enables caching
|
|
|
Ch 11
Storing Connection information |
web.config file
|
|
|
ConnectionStringSettings class?
|
collection of all connection strings used by application
|
|
|
Ch 11
ConfigurationManager class? |
Used to edit Web.config
|
