Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/26

Click to flip

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