Sams Teach Yourself ADO.NET in 21 Days

Packet Size attribute (SqlClient provider)  

page output (ASP.NET) caching  

Page_Load method  

PageIndexChanged event  

       code   2nd  

Paging tab

       DataGrid Properties dialog box  

paradigms

       relational and object-oriented, combining   2nd  

parallel transactions  

parameter objects

       Direction property, setting   2nd   3rd  

ParameterName property

       parameters (.NET Data Providers)  

parameters

       adding to collections  

       CbksParameter class

               code   2nd   3rd   4th   5th   6th   7th  

       CbksParameterCollection class

               code   2nd   3rd   4th   5th   6th   7th  

       encoding

               SoapDocumentService attribute  

       implementing

               code   2nd   3rd   4th   5th   6th   7th  

       input

               of command objects   2nd   3rd   4th   5th   6th  

       objects

               DataFactory class  

       OdbcParameter object  

       of command objects   2nd  

               code   2nd   3rd   4th   5th  

               input   2nd   3rd   4th   5th   6th  

               output   2nd   3rd  

               return values   2nd   3rd  

       or Select method, when to use   2nd  

       output

               code  

               favoring over DataSets   2nd  

               of command objects   2nd   3rd  

parameters (.NET Data Providers)   2nd   3rd   4th  

       DbType property  

       Direction property  

       IDataParameter interface   2nd  

       IDbDataParameter interface   2nd  

       IsNullable property  

        members  

       ParameterName property  

       Precision property  

       Scale property  

       Size property  

       SourceColumn property  

       SourceVersion property  

       Value property  

parameters classes

       ComputeBooks data provider   2nd   3rd   4th   5th   6th   7th   8th   9th  

Parameters property  

       command classes (.NET Data Providers)  

Parent and Child Relations (expression syntax rule)

       data, selecting  

parentheses ( )  

ParentRelations property

       DataTable class  

Parse event

       regular expressions  

parsing

       connection strings  

       statement files   2nd   3rd   4th   5th   6th  

               code   2nd   3rd  

Pascal case

       definition  

passing

       arguments

               to delegates  

               to threads  

       DataSets   2nd   3rd   4th   5th   6th  

               between AppDomains  

       SingleRow value (CommandBehavior enumeration) to the ExecuteReader method  

Passthrough value (MissingMappingAction enumeration)  

Password attribute (SqlClient provider)  

patterns

       abstract factory  

       adapter

               definition  

       object oriented designs  

PE (portable executable) file  

percent sign (%)

       wildcard character  

performance

       applications  

       data readers   2nd  

       measuring

               DataFactory class   2nd  

       SQL Server .NET  

       stored procedures  

performance counters

       viewing  

Performance Monitor utility  

performance of applications

       optimizing  

               databases, favoring output parameters over DataSets   2nd  

               databases, indexes   2nd  

               databases, stored procedures  

               managed code, ASP.NET caching   2nd   3rd  

               managed code, connection pooling   2nd  

               managed code, data readers   2nd  

               managed code, delegates   2nd   3rd   4th   5th   6th   7th  

               managed code, narrow providers   2nd  

               managed code, query multithreading   2nd   3rd   4th   5th   6th   7th   8th   9th  

               managed code, round trips to database servers   2nd  

               managed code, Thread class   2nd   3rd  

               queries, performing joins on servers   2nd  

               queries, requesting columns   2nd  

               queries, requesting rows   2nd  

performances

       stored procedures  

performing

       joins on servers   2nd  

PERMISSION SET attribute

       CAS (code access security) permission  

permissions

       CAS (code access security) permission  

permissions (.NET Data Providers)   2nd   3rd  

       assemblies   2nd  

       attributes, declaring  

       Code Access Security model   2nd   3rd   4th   5th   6th  

       editing  

       FullTrust permission set  

       imperative security  

       imperative security, code   2nd  

Persist Security Info attribute (SqlClient provider)  

persistence classes

       creating for ObjectSpaces Framework   2nd   3rd  

       Customer

               code for XML mapping file   2nd  

               code to create for ObjectSpaces Framework   2nd   3rd  

persisting to disks

       DataSet serialization   2nd   3rd   4th   5th   6th   7th   8th   9th  

pessimistic concurrency  

       code

               data stores, updating   2nd  

       configuring

               code   2nd   3rd  

physical tiers

       relation to   2nd   3rd   4th   5th   6th   7th  

PIA (primary interop assembly)

       definition  

pointers

       object-oriented functions.   [See delegates]

policies

       binding

               client applications  

polymorphism

       data readers   2nd  

               code   2nd  

       definition  

pooling

       connections   2nd  

               Connection Lifetime attribute (SqlClient provider)  

               Connection Reset attribute (SqlClient provider)  

               impersonation (trusted connection threads)  

               Max Pool Size attribute (SqlClient provider)  

               Min Pool Size attribute (SqlClient provider)  

               Pooling attribute (SqlClient provider)  

               session pooling  

               with OleDb provider   2nd   3rd  

               with SqlClient provider   2nd   3rd   4th   5th   6th   7th   8th  

       sessions  

Pooling attribute (SqlClient provider)  

pooling.   [See connection pooling]

pools

       connections in, monitoring  

populateBooks method

       row states   2nd  

               code  

populating

       columns

               in DataTables  

       DataSet class   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

               Aggregate Functions (expression syntax rule)  

               code   2nd   3rd   4th   5th  

               Column Names (expression syntax rule)  

               data, selecting   2nd   3rd   4th   5th   6th   7th   8th  

               expression syntax rules   2nd   3rd  

               Functions (expression syntax rule)  

               Literal Values (expression syntax rule)  

               Operators (expression syntax rule)  

               Parent and Child Relations (expression syntax rule)  

               traversing   2nd   3rd   4th   5th   6th   7th   8th  

               Wildcard Characters (expression syntax rule)  

       dsOrders extended property (DataSet object)

               code   2nd  

       objects

               code   2nd  

       strongly typed DataSet classes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

populatng

       TitlesDs DataSet  

               code   2nd  

portable executable (PE) file  

Position property (Memorystream)  

PositionChanged event

       CurrencyManager object position notifications, code   2nd  

pound sign(#)  

Precision property

       parameters (.NET Data Providers)  

Prefix attribute  

Prefix property

       DataColumn class  

       DataSet class  

       DataTable class  

prefixes

       _ ( underscore )  

       Hungarian notation  

Prepare method   2nd  

       command classes (.NET Data Providers)  

presentation applications

       definition  

presentation services tier   2nd  

presentation services tier (Web Forms applications)  

       CompareValidator control  

       controls

               validating   2nd   3rd   4th   5th   6th  

               validation process, customizing   2nd  

       CustomValidator control  

       data binding   2nd   3rd  

               data binding expression  

               Mobile Control binding  

               multi-record binding   2nd   3rd   4th   5th  

               single-value binding   2nd   3rd   4th   5th  

       object states, storing   2nd   3rd  

               ASP.NET State service storage   2nd  

               session states   2nd   3rd   4th   5th   6th  

               SQL Server storage   2nd   3rd  

               view states   2nd   3rd  

       RangeValidator control  

       RegularExpressionValidator control   2nd   3rd   4th   5th  

       RequiredFieldValidator control   2nd   3rd  

       ValidationSummary control   2nd   3rd  

presentation services tier (Windows Forms applications)  

       controls

               validating   2nd   3rd   4th   5th  

       data binding   2nd   3rd   4th   5th  

               architecture   2nd  

               complex binding   2nd   3rd   4th  

               manual binding   2nd   3rd  

               simple binding   2nd   3rd   4th   5th  

               simple binding formatting   2nd   3rd  

               simple binding navigation   2nd   3rd  

previewing

       data adapters  

primary interop assembly (PIA)  

primary keys

       SetDefault values  

       SetNull values  

       table constraints   2nd  

PrimaryKey property   2nd   3rd  

       DataTable class  

PrintEvents method  

Priority property

       threads  

private assembly  

private methods

       data access classes   2nd   3rd   4th   5th   6th   7th   8th   9th  

       getTitles   2nd  

private variables , initializing  

Procedure property

       SqlError object (.NET Data Providers)  

procedures

       stored

               and dynamic SQL, comparing   2nd   3rd  

procedures.   [See also stored procedurees]

product catalogs

       ComputeBooks  

       running  

Professional edition of VS .NET

       data, managing  

Profiler utility

       SQL Server  

programmatic data binding

       code   2nd  

programming

       event-driven models

               ASP.NET  

       interface-based   2nd  

       SQL Server .NET   2nd  

               CLR (Common Language Runtime)   2nd  

               CLR (Common Language Runtime), .NET language versatility  

               CLR (Common Language Runtime), performance  

               CLR (Common Language Runtime), tool leverage  

               CLR (Common Language Runtime), unified programming models  

               data, accessing   2nd   3rd   4th   5th  

               functions, code to create   2nd  

programming errors

       reducing in ADO.NET design   2nd   3rd  

programming models

       multi-tiered   2nd  

       unified

               SQL Server .NET  

projects

       VS .NET

               SqlServer namespace, referencing  

propertiees

       ExtendedProperties  

properties

       AcceptChangesDuringFill

               data adapters (.NET Data Providers)  

       AcceptRejectRule  

       AllowDBNull

               DataColumn class   2nd  

       AllowDelete

               DataView class  

       AllowEdit

               DataView class  

       AllowNew

               DataView class  

       ApplyDefaultSort  

               DataView class  

       AutoIncrement

               DataColumn class   2nd   [See d]3rd   4th   [See d]

       AutoIncrementStep

               DataColumn class   2nd  

       CacheFilePath

               data factory class  

       Caption

               columns  

               DataColumn class  

       CaseSensitive  

               DataSet class  

               DataTable class  

       ChildRelations

               DataTable class  

       Class

               SqlError object (.NET Data Providers)  

       ClientValidationFunction  

       ColumnMapping   2nd   3rd  

               DataColumn class  

       ColumnName

               DataColumn class   2nd  

       columns  

       Columns

               DataSet object   2nd   3rd  

               DataTable class  

       Command (event arguments)   2nd  

       command builders  

       CommandText   2nd   3rd  

               command classes (.NET Data Providers)  

       CommandTimeout  

               command classes (.NET Data Providers)  

       CommandType   2nd  

               command classes (.NET Data Providers)  

       Conflict  

       Connection   2nd  

               command classes (.NET Data Providers)  

               data factory class  

               transaction classes (.NET Data Providers)  

       ConnectionString   2nd   3rd  

               connection classes (.NET Data Providers)  

       ConnectionTimeout

               connection classes (.NET Data Providers)  

       Constraints  

               DataTable class  

       ContinueUpdateOnError   2nd   3rd  

               data adapters (.NET Data Providers)  

       Count

               DataView class  

       Current  

       CurrentPageIndex  

       data factory class  

       Database

               connection classes (.NET Data Providers)  

       DataColumn class   2nd   3rd  

               AllowDBNull   2nd  

               AutoIncrement   2nd   [See d]3rd   4th   [See d]

               AutoIncrementStep   2nd  

               Caption  

               ColumnMapping  

               ColumnName   2nd  

               DataType   2nd   3rd  

               DataType, CTS (Common Type System) types   2nd  

               DefaultValue  

               Expression   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

               Extended Properties  

               MaxLength   2nd  

               Namespace  

               Ordinal  

               Prefix  

               ReadOnly  

               Table  

               Unique   2nd  

       DataRow class   2nd  

               HasErrors  

               Item  

               ItemArray  

               RowError  

               RowState  

               Table  

       DataSet

               DataTable class  

       DataSet class   2nd  

               CaseSensitive  

               DataSetName  

               DefaultViewManager  

               EnforceConstraints  

               ExtendedProperties  

               HasErrors  

               Namespace  

               Prefix  

       DataSetIndex  

       DataSetName

               DataSet class  

       DataTable class

               CaseSensitive  

               ChildRelations  

               Columns  

               Constraints  

               DataSet  

               DefaultView  

               DisplayExpression  

               ExtendedProperties  

               HasErrors  

               MinimumCapacity  

               Namespace  

               ParentRelations  

               Prefix  

               PrimaryKey  

               Rows  

               TableName  

       DataTable object   2nd   3rd  

       DataType

               CTS (Common Type System) types   2nd  

               DataColumn class   2nd   3rd  

       DataView class   2nd   3rd  

               AllowDelete  

               AllowEdit  

               AllowNew  

               ApplyDefaultSort  

               Count  

               DataViewManager  

               Item  

               RowFilter  

               RowStateFilter  

               Sort  

               Table  

       DataViewManager

               DataView class  

       DbType

               parameters (.NET Data Providers)  

       DefaultValue  

               DataColumn class  

       DefaultView  

               DataTable class  

       DefaultViewManager  

               DataSet class  

       DeleteCommand  

               data adapters (.NET Data Providers)  

       DeleteRule  

       Depth

               data reader (.NET Data Providers)  

       Direction

               parameter objects   2nd   3rd  

               parameters (.NET Data Providers)  

       DisplayExpression

               DataTable class  

       dsOrders extended property (DataSet object)

               populating, code   2nd  

       EditItemIndex   2nd  

       EnforceConstraints

               DataSet class  

       Entry  

       ErrorMessage  

       Errors (event arguments)   2nd  

       event arguments   2nd  

       Expression

               aggregate functions   2nd   3rd  

               DataColumn class   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  

               exceptions, throwing  

               table relationships, navigating  

       extended   2nd   3rd   4th   5th  

               code to retrieve   2nd  

               populating, code   2nd  

       Extended Properties

               DataColumn class  

       ExtendedProperties   2nd   3rd   4th   5th  

               DataSet class  

               DataTable class  

       FieldCount

               data reader (.NET Data Providers)  

       HasErrors

               DataRow class  

               DataSet class  

               DataTable class  

       InsertCommand  

               data adapters (.NET Data Providers)  

       IsClosed

               data reader (.NET Data Providers)  

       IsNested   2nd  

       IsNullable

               parameters (.NET Data Providers)  

       IsolationLevel

               transaction classes (.NET Data Providers)  

       IsPostBack  

       IsPrimaryKey

               UniqueConstraint class  

       Item  

               data reader (.NET Data Providers)  

               DataRow class  

               DataRow object   2nd  

               DataView class  

       ItemArray   2nd  

               DataRow class  

       LineNumber

               SqlError object (.NET Data Providers)  

       ListChangedType   2nd   3rd   4th  

       MaxLength

               DataColumn class   2nd  

       Message

               OleDbError object (.NET Data Providers)  

               SqlError object (.NET Data Providers)  

       MinimumCapacity   2nd  

               DataTable class  

       MissingMappingAction

               data adapters (.NET Data Providers)  

       MissingSchemaAction   2nd   3rd  

               data adapters (.NET Data Providers)  

               schema generation   2nd   3rd  

       MS Description  

        Name

               threads  

       Namespace

               DataColumn class  

               DataSet class  

               DataTable class  

       NativeError

               OleDbError object (.NET Data Providers)  

       Nested   2nd   3rd  

       NewIndex   2nd  

       NewPageIndex  

       Number

               SqlError object (.NET Data Providers)  

       of SqlDataAdapter object

               setting  

       OldIndex  

       Ordinal

               DataColumn class  

       ParameterName

               parameters (.NET Data Providers)  

       Parameters  

               command classes (.NET Data Providers)  

       ParentRelations

               DataTable class  

       Position (MemoryStream)  

       Precision

               parameters (.NET Data Providers)  

       Prefix

               DataColumn class  

               DataSet class  

               DataTable class  

       PrimaryKey   2nd   3rd  

               DataTable class  

       Priority

               threads  

       Procedure

               SqlError object (.NET Data Providers)  

       Provider

               data factory class  

       Readonly  

       ReadOnly  

               DataColumn class  

       RecordsAffected   2nd  

               data reader (.NET Data Providers)  

       RecordsAffected (event arguments)  

       Row (event arguments)   2nd  

       RowError

               DataRow class  

       RowFilter   2nd  

               DataView class   2nd  

       Rows

               DataSet object   2nd   3rd   4th   5th   6th   7th   8th  

               DataTable class  

       RowState

               DataRow class  

               DataRow object   2nd  

       RowStateFilter   2nd   3rd   4th  

               DataView class  

               DataView object  

       Scale

               parameters (.NET Data Providers)  

       SelectCommand  

       Selectcommand  

       SelectCommand

               data adapters (.NET Data Providers)  

       Server

               SqlError object (.NET Data Providers)  

       Size

               parameters (.NET Data Providers)  

       Sort   2nd  

               DataView class  

       Source

               OleDbError object (.NET Data Providers)  

               SqlError object (.NET Data Providers)  

       SourceColumn

               parameters (.NET Data Providers)  

       SourceVersion  

               parameters (.NET Data Providers)  

       SqlError object  

       SQLState

               OleDbError object (.NET Data Providers)  

       State

               connection classes (.NET Data Providers)  

               SqlError object (.NET Data Providers)  

       StatementType (event arguments)   2nd  

       Status (event arguments)   2nd  

       Table  

               DataColumn class  

               DataRow class  

               DataView class  

       table columns   2nd   3rd   4th  

               code to set   2nd  

               exposing as   2nd  

               exposing as, code   2nd   3rd  

       TableMapping (event arguments)   2nd  

       TableMappings  

               data adapters (.NET Data Providers)  

       TableName

               DataTable class  

       Tables

               DataSet object   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  

       Text  

       Transaction

               command classes (.NET Data Providers)  

       Unique  

               DataColumn class   2nd  

               setting to True  

       UpdateCommand  

               data adapters (.NET Data Providers)  

       UpdatedRowSource  

               command classes (.NET Data Providers)  

       UpdateRule  

       UseCache

               data factory class  

       Value

               parameters (.NET Data Providers)  

       ViewState  

       yellow barrel icon  

Properties window

       simple binding   2nd  

       yellow barrel icon  

Property Builder dialog box  

PropertyCollection class  

PropertyManager class  

Proposed value (DataRowVersion enumeration)  

Proposed version

       rows  

proprietary data stores  

protected signatures  

protocols

       HTTP (Hypertext Transfer Protocol) context information

               Web services  

       SOAP

               (Simple Object Access Protocol)  

       SOAP (Simple Object Access Protocol)

               XML Web Services  

       TDS

               (Tabular Data Stream)  

       Web services  

       WSDL (Web Services Description Language)

               XML Web Services  

provider factory   2nd  

Provider property

       data factory class  

ProviderFactory class   2nd   3rd  

       code   2nd   3rd  

       command objects  

       data providers

               code to abstract   2nd   3rd   4th   5th  

providers

       abstracted

               definition  

       attributes for, determining  

       data

               definition  

       generic (.NET Data Providers)  

       generic versus specific   2nd   3rd  

       ODBC .NET Provider, downloading  

       OleDb

               connection strings, specifying   2nd   3rd   4th  

               connections, pooling   2nd   3rd  

               OLE DB 2.5 interfaces  

               transaction objects  

               transactions   2nd  

       specific (.NET Data Providers)  

       SQL Server OLE DB  

       SqlClient

               Application Name attribute  

               AttachDBFileName attribute  

               attributes  

               attributes, connection pooling   2nd  

               attributes, connections   2nd   3rd   4th   5th   6th  

               code, debugging  

               Connect Timeout attribute  

               Connection Lifetime attribute  

               connection objects, exceptions  

               Connection Reset attribute  

               connection strings, specifying   2nd   3rd   4th   5th   6th  

               connections, pooling   2nd   3rd   4th   5th   6th   7th   8th  

               Current Language attribute  

               Data Source attribute  

               Enlist attribute  

               Initial Catalog attribute  

               Integrated Security attribute  

               Max Pool Size attribute  

               Min Pool Size attribute  

               Network Library attribute   2nd  

               Packet Size attribute  

               Password attribute  

               performance counters, viewing  

               Persist Security Info attribute  

               Pooling attribute  

               SQL Profiler  

               transaction objects  

               transactions   2nd   3rd   4th   5th   6th  

               Use Procedure For Prepare attribute  

               User ID attribute  

               Workstation ID attribute  

       SqlClient .NET Data  

providers.   [See data providers]

proxy classes

       client

               begin and end methods, exposing  

       ComputeBooksCatalog  

PubDate column

       Caption properties  

public keys (strong names)

       definition  

public members

       data factory class  

pulling

       statements  

Pure Visual Basic [edit, italics)  

purposes

       strongly typed DataSet classes   2nd   3rd   4th