Sams Teach Yourself ADO.NET in 21 Days

2017-07-07 02:10:07

for RuBoard

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y]

maintainability of multi-tiered applications

managed classes (SQLXML), code 2nd

managed code

ASP.NET caching 2nd 3rd

connection pooling 2nd

data readers 2nd

definition

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

functions, creating 2nd

narrow providers 2nd

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

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

round trips to database servers, minimizing 2nd

Thread class 2nd 3rd

managers

BindingManagerBaseManager class

CurrencyManager class

CurrentyManager position notifications, code 2nd

NET [edit, period before] Framework Configuration Manager

GAC;(Global Assembly Cache)

ODBC Driver Manager

connection pooling

PropertyManager class

managing

connections

base classes

data

in VS .NET Professional edition

views

in DataView objects 2nd 3rd 4th

manifests

definition

manipulating

data

data readers

DataSet objects 2nd

manual binding 2nd 3rd

manually binding

data readers to ListView controls 2nd

many to many relationships

definition

mapping

data

to object models

Integer datatype

SqlTypes namespace types

tables

schema generation 2nd 3rd 4th 5th 6th 7th 8th

tables to XSD schemas, code 2nd

mapping files

XML

code for persistent Customer classes 2nd

creating for ObjectSpaces Framework 2nd 3rd

mapping rules

XSD to DataSets 2nd 3rd

mapping schemas. [See also XML Views]

mappings

columns

code to create 2nd

CTS (Common Type System) types enumeration, viewing

table

code 2nd

Table Mappings dialog box 2nd

tables

code to create 2nd

MappingType attribute

Hidden value

markup languages. [See also XML]2nd [See XML]

Max function

Max Pool Size attribute (SqlClient provider)

MaxLength property

DataColumn class 2nd

MCS (Microsoft Cluster Service)

MDAC

(Microsoft Data Access Components) 2nd 3rd

MDAC (Microsoft Data Access Components) SDK, downloading

measuring performance

DataFactory class 2nd

members

command classes (.NET Data Providers)

connection classes (.NET Data Providers)

Data Adapter component (.NET Data Providers) 2nd

data adapters (.NET Data Providers)

data reader (.NET Data Providers)

DataColumn class 2nd 3rd

DataColumn object

DataRow class 2nd 3rd 4th 5th

DataSet class

DataTable object

DataView class 2nd

parameters (.NET Data Providers)

public

data factory class

transaction classes (.NET Data Providers)

members of classes, manipulating

MemoryStream

Position property

MemoryStream object

data, buffering

merge errors

handling 2nd 3rd 4th 5th 6th

Merge method 2nd 3rd 4th 5th

DataSet class

MergeFailed event 2nd

DataSet class

event handlers

code to add 2nd

MergeFailedEventHandler delegate

merging

DataSet objects 2nd 3rd 4th 5th

code 2nd

merge errors, handling 2nd 3rd 4th 5th 6th

Message property

OleDbError object (.NET Data Providers)

SqlError object (.NET Data Providers)

metadata

adding for SQL Server (data retrieval) 2nd 3rd 4th 5th 6th 7th

metadata assembly. [See interop assembly]

methodds

CreateSQLFiles

createSQLFiles

ExtractLookups

TransformDs

WriteSqlSchema

methods

Abort

threads

AcceptChanges 2nd

DataRow class

DataSet class

DataTable class

rows

table rows 2nd

Add 2nd 3rd

DataRelationCollection class

DataSet class, populating

rows, adding to tables

AddCriteria

AddNew

DataView class

AddReviewsRow

AUTOREGISTER attribute

Begin

begin and end, exposing

BeginEdit

DataRow class

BeginGetTopSellers

BeginInvoke

BeginLoadData

DataTable class

BeginTransaction 2nd

connection classes (.NET Data Providers)

data factory class

Cancel

command classes (.NET Data Providers)

CancelEdit

DataRow class

rows

ChangeDatabase

connection classes (.NET Data Providers)

Clear

DataSet class

DataTable class

ClearErrors

DataRow class

Clone 2nd 3rd

DataSet class

DataTable class

cloneObject 2nd

Close 2nd

connection classes (.NET Data Providers)

data reader (.NET Data Providers)

data readers

SqlConnection class

command builders

Commit

transaction classes (.NET Data Providers)

Compute 2nd

DataTable class

ContainsKey

Copy 2nd

DataSet class

DataTable class

CopyTo

DataView class

CreateActivityReport

CreateCommand

connection classes (.NET Data Providers)

CreateDataAdapter

data factory class

CreateInstance

CreateParameter 2nd

command classes (.NET Data Providers)

createProviderTypes

createSqlCallback

CreateSqlFile

createSqlFile

CreateSqlFile

data factory class

CreateSqlFiles

data factory class

data access

building 2nd 3rd 4th

data factory class 2nd

DataBind

DataRow class 2nd 3rd

AcceptChanges

BeginEdit

CancelEdit

ClearErrors

Delete

EndEdit

GetChildRows

GetColumnError

GetColumnsInError

GetParentRow

GetParentRows

HasVersion

IsNull

RejectChanges

SetColumnError

SetParentRow

DataSet class 2nd 3rd

AcceptChanges

Clear

Clone

Copy

GetChanges

GetXml

GetXmlSchema

HasChanges

InferXmlSchema

Merge

ReadXML

ReadXMLSchema

RejectChanges

Reset

WriteXml

WriteXmlSchema 2nd

DataTable class

AcceptChanges

BeginLoadData

Clear

Clone

Compute

Copy

EndLoadData

GetChanges

ImportRow

LoadDataRow

NewRow

RejectChanges

Reset

Select

DataTable object 2nd 3rd

DataView class

AddNew

CopyTo

Delete

Find

FindRows

Delete

DataRow class

DataView class

DeleteTitle

Titles table rows, code to delete 2nd

End

EndEdit

DataRow class

rows

EndGetTopSellers

EndInvoke

EndLoadData

constraints

DataTable class

Eval

ExecuteDataReader

data factory class

ExecuteNonQuery 2nd 3rd

command classes (.NET Data Providers)

data factory class

ExecuteReader

command classes (.NET Data Providers)

CommandBehavior enumeration 2nd

data readers

data retrieval 2nd 3rd 4th 5th 6th

SingleRow value (CommandBehavior enumeration), passing to

ExecuteScalar

code 2nd

command classes (.NET Data Providers)

data factory class

data requests , appropriate

data retrieval 2nd 3rd

DataFactory class, code to implement 2nd 3rd

result sets, code to return 2nd

ExecuteSqlXmlReader

data factory class

ExecuteXmlReader

code 2nd

data retrieval 2nd 3rd 4th 5th 6th 7th 8th

XmlReader transformation, code 2nd

XSL stylesheet output, code 2nd

XSL stylesheet, code 2nd

exposing

in data services tier

Fill

columns, duplicate names

data adapters

data adapters (.NET Data Providers)

data, retrieving 2nd 3rd 4th 5th

DataSet class, code to populate 2nd

DataSet class, populating 2nd 3rd

protected signatures

rules 2nd

SelectCommand

table mapping names, passing

FillError

data adapters (.NET Data Providers)

FillSchema 2nd 3rd 4th 5th 6th

data adapters (.NET Data Providers)

find

Find

data, selecting

DataRowCollection object

DataView class

rows, finding

FindByReviewID

FindRows

DataView class

GetBoolean

data reader (.NET Data Providers)

GetByte

data reader (.NET Data Providers)

GetBytes

data reader (.NET Data Providers)

GetChanges 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th

DataSet class

DataSets

DataTable class

DataTable class, code to inspect 2nd 3rd 4th 5th

DataTable class, inspecting 2nd

n-tiered applications

rows, code to filter 2nd

GetChar

data reader (.NET Data Providers)

GetChars

data reader (.NET Data Providers)

GetChildRows

DataRow class

GetColumnError

DataRow class

GetColumnProperties

GetColumnsInError

DataRow class

GetData

getDataSet

GetDataSet

data factory class

GetDataTable

data factory class

GetDataTypeName

data reader (.NET Data Providers)

GetDateTime

data reader (.NET Data Providers)

GetDecimal

data reader (.NET Data Providers)

GetDouble

data reader (.NET Data Providers)

GetDtaSet

code 2nd

GetElementsByTagName

GetEnumerator

GetError

table rows

GetFieldType

data reader (.NET Data Providers)

GetFillParameters

data adapters (.NET Data Providers)

GetFloat

data reader (.NET Data Providers)

GetGuid

data reader (.NET Data Providers)

GetInt16

data reader (.NET Data Providers)

GetInt32

data reader (.NET Data Providers)

GetInt64

data reader (.NET Data Providers)

GetLookups

CloseConnection command

GetName

data reader (.NET Data Providers)

GetOrdinal

data reader (.NET Data Providers)

GetParentRow

DataRow class

GetParentRows

DataRow class

GetProviders

data factory class

GetRevenue

GetReviewsRows

GetRowFromElement

GetRows

data reader (.NET Data Providers)

GetSchemaTable

data reader (.NET Data Providers)

schema, retrieving 2nd 3rd

getStatement

IDbCommand object, returning

statements, pulling or creating

GetString

data reader (.NET Data Providers)

GetTimespan

data reader (.NET Data Providers)

getTitles 2nd

GetTitles

AddressOf keyword

calling

calling asynchronously

getTitles

DataFactory class, code 2nd

GetTitles

threads

GetTitlesDone

calling through delegates, code 2nd

GetTopSellers

code 2nd 3rd

GetValue

data reader (.NET Data Providers)

data, retrieving

GetValues 2nd

data reader (.NET Data Providers)

table columns, code to read multiple values 2nd

GetXml

GetXML

GetXml

DataSet class

GetXmlSchema

DataSet class

GetXsltResults

data factory class

HandleMergeErrors

HasChanges 2nd 3rd

DataSet class

HasVersion

DataRow class

ImportRow

DataTable class

InferXmlSchema 2nd 3rd

DataSet class

InitClass

classes, initializing

InitializeComponent 2nd 3rd

InitVars

variables , initializing

Interrupt

threads

IsDBNull

IsDbNull

data reader (.NET Data Providers)

IsNull

DataRow class

Join

threads

Load

XmlDataDocument class, loading XML (eXtensible Markup Language)

LoadDataRow 2nd 3rd

DataTable class

LoadDs 2nd 3rd

Merge 2nd 3rd 4th 5th

DataSet class

MoveNext

data readers

NewGuide

NewReviewsRow

NewRow 2nd

DataTable class

NextResult

data reader (.NET Data Providers)

of SqlCommand object

Open 2nd

connection classes (.NET Data Providers)

SqlConnection class

overloaded

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

Page Load

populateBooks

row states 2nd

row states, code

Prepare

command classes (.NET Data Providers)

Prepre

PrintEvents

private

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

Read

data reader (.NET Data Providers)

data readers, traversing 2nd

ReadBinaryData

code 2nd

ReadXml 2nd

ReadXML

DataSet class

ReadXml

XmlReadMode enumeration 2nd 3rd

ReadXmlSchema 2nd 3rd 4th

ReadXMLSchema

DataSet class

RejectChanges

DataRow class

DataSet class

DataTable class

rows

table rows 2nd 3rd

RemoveStatement

data factory class

Reset

DataSet class

DataTable class

table rows

ResetCommandTimeout

command classes (.NET Data Providers)

Resume

threads

RevByBook

ReviewsDataTable class

rows, finding

Rollback

transaction classes (.NET Data Providers)

RowUpdated

data adapters (.NET Data Providers)

RowUpdating

data adapters (.NET Data Providers)

SaveDs 2nd

SaveMyData 2nd

SaveTitles

Select

data, selecting

DataTable class

or parameters, when to use 2nd

or WHERE clause, when to use 2nd

SelectNodes

SetColumnError

DataRow class

SetParentRow

DataRow class

setupDataAdapter

showOriginal

Split

Start

threads 2nd

StoresRowChanging

Suspend

threads

SyncDataSet

data factory class

Synchronized

Hashtable class

ThrowComputeBookException

TitlesChanged

TitlesDataTable class

rows, finding

TopSellers

code 2nd

TraceRowError 2nd

Transform

UPdate

Update

data adapters (.NET Data Providers)

DataSets

Web

SoapRpcMethod attribute

Web services

SOAP

Write

Trace class

WriteLine

row information, code to manipulate 2nd

row information, manipulating 2nd

WriteSqlSchema

WriteXml 2nd

WriteXML 2nd

WriteXml

data readers, code for polymorphism 2nd

DataSet class

DiffGrams (XML), code to create 2nd 3rd

DiffGrams, code to create 2nd

DiffGrams, creating

XML DiffGrams, code to create 2nd 3rd

WriteXmlChanges 2nd

calling

output 2nd

output, code 2nd

WriteXmlSchema

DataSet class 2nd

XmlDataDocument class

Microsoft

Access

data access timeline

drivers

data provider supported

MDAC (Microsoft Data Access Components) SDK, downloading

newsgroups

drivers

ODBC .NET Provider, downloading

Web site

MMIT (Microsoft Mobile Internet Toolkit), downloading

Object Role Modeling[ colon ] An Overview [edit, place title in double quotes]

ODBC .NET Data Provider, downloading

XML tutorials and FAQs

Microsoft Cluster Service (MCS)

Microsoft Data Access Components (MDAC) SDK, downloading

Microsoft Data Access Components. [See MDAC]

Microsoft FxCop Web site

Microsoft Intermediate Language. [See MSIL]

Microsoft Mobile Internet Toolkit (MMIT)

Microsoft ObjectSpaces Framework. [See ObjectSpaces Framework]

Microsoft Transaction Server (MTS)

Microsoft Transaction Server. [See MTS]

Min function

Min Pool Size attribute (SqlClient provider)

MinimumCapacity property 2nd

DataTable class

MissingMappingAction enumeration

Error value

Ignore value

Passthrough value

values

MissingMappingAction property

data adapters (.NET Data Providers)

MissingMappingAction.Passthrough value

MissingSchemaAction enumeration

Add value

AddWithKey value 2nd

Error value 2nd

Ignore value 2nd

values

MissingSchemaAction property 2nd 3rd

data adapters (.NET Data Providers)

schema generation 2nd 3rd

MMIT (Microsoft Mobile Internet Toolkit)

downloading

Mobile Control binding

Mobile Forms

modeling

databases

ER (entity-relationship) modeling

models

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

disconnected update

data stores, updating 2nd 3rd 4th 5th 6th

DOM

(Document Object Model)

event-driven programming

ASP.NET

object

data, mapping to

programming

multi-tiered 2nd

unified programming

SQL Server .NET

modes

FOR XML statement 2nd

ReadCommitted

ReadUncommitted

XML AUTO (FOR XML statement)

XML EXPLICIT (FOR XML statement)

XML RAW (FOR XML statement)

Modified value (DataRowState enumeration)

ModifiedCurrent value (DataViewRowState enumeration)

ModifiedOriginal value (DataViewRowState enumeration)

modifying

data

modules

definition 2nd

modulus operators

money data type

and smallmoney data type, comparing

monitoring

connections in pools

MoveNext method

data readers

MS Description property

MSDASQL

msdata namespace 2nd

msdata namespace declaration

MSDataShape provider

code 2nd

MSIE (Internet Explorer)

MSIL

(Microsoft Intermediate Language)

PE (portable executable) file

MTS

(Microsoft Transaction Server)

MTS (Microsoft Transaction Server)

multi-function stored procedures, code 2nd

multi-record binding 2nd 3rd 4th

data readers

binding to DropDownList controls, code 2nd

definition

multi-tiered applications

abstract factory patterns

abstracted providers

definition

ADO.NET

architecture 2nd 3rd 4th 5th 6th

benefits

business services tier 2nd

data services tier 2nd

abstracted providers

custom objects, exposing

data readers, exposing

DataSet objects, exposing

direct approach

external view 2nd 3rd 4th 5th

internal data factory 2nd

internal view 2nd 3rd 4th 5th

methods, exposing

extensability

internal data factory

logical tiers

distributing 2nd

maintainability

NLB (Network Load Balancing)

definition

performance

physical tiers, relation to 2nd 3rd 4th 5th 6th 7th

presentation services tier

provider factory

rapid development

reusability

scalability

scale-out

scale-out, definition

scale-up , definition

server affinity

definition

specialization

Web services 2nd

multi-tiered programming models 2nd

multiple layers . [See tiers]

multiple values

of columns, code to read 2nd

of columns, retrieving 2nd 3rd 4th 5th 6th

multithreading queries

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

MustInherit class

My Profile command (Start Page menu)

My Services initiative

for RuBoard

Категории