Sams Teach Yourself ADO.NET in 21 Days
| for RuBoard |
• ”(single quotation marks)
objecs
DataGridPageChanged
object construction 2nd 3rd 4th
code 2nd
object models
data
mapping to
Object Role Modeling. [See ORM]
Object Role Modeling[ colon ] An Overview [edit, place title in double quotes]
object states
storing in Web Forms presentation services tier 2nd 3rd
ASP.NET State service storage 2nd
session states 2nd 3rd 4th 5th 6th
SQL Server storage 2nd 3rd
view states 2nd 3rd
object-oriented and relational paradigms , combining 2nd
object-oriented design patterns
object-oriented function pointers. [See delegates]
object-oriented syntax
data, accessing
objects
ADO Recordset
COM Interop functionality
data, reading 2nd 3rd 4th 5th 6th 7th 8th 9th
AsyncResult
Binding
Format event, code 2nd
BindingCollection
BindingContext 2nd
CbksCommand
CbksParameter
cmSave SqlCommand
COM
RCW (runtime callable wrapper) 2nd
command
CloseConnection value 2nd
CommandText property 2nd
CommandType property 2nd
constructors
controlling 2nd 3rd
data modification 2nd 3rd
data readers, code to execute 2nd
data retrieval
data retrieval, ExecuteReader method 2nd 3rd 4th 5th 6th
data retrieval, ExecuteScalar method 2nd 3rd
data retrieval, ExecuteXmlReader method 2nd 3rd 4th 5th 6th 7th 8th
Default value
ExecuteReader method, CommandBehavior enumeration 2nd
IDbCommand interface
input parameters 2nd 3rd 4th 5th 6th
KeyInfo value
OleDbCommand 2nd
OleDbCommand, arguments
output parameters 2nd 3rd
output parameters, code
parameters 2nd
parameters, code 2nd 3rd 4th 5th
ProviderFactory class
return values 2nd 3rd
SequentialAccess value
SingleResult value
SingleRow value
stored procedures and dynamic SQL, comparing 2nd 3rd
command (.NET Data Providers)
connection
data readers
connection (.NET Data Providers)
connections
exceptions 2nd
ConvertEventArgs
CurrencyManager
position notifications, code 2nd
custom
exposing in data services tier
returning for data access classes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
daCategories
DAO
(Data Access Objects)
DataColumn
members
DataColumnMapping
DataGrid
relationships, navigating
DataRelation
foreign keys 2nd 3rd 4th
DataRow
Item property 2nd
RowState property;DataRow 2nd
DataRowChangeEventArgs
DataRowCollection
Find method
DataSet
cloning 2nd 3rd 4th 5th 6th
Columns property 2nd 3rd
columns, auto-incrementing 2nd 3rd 4th 5th 6th
columns, auto-incrementing (code to define tables) 2nd
columns, code to set properties 2nd
columns, expressions 2nd 3rd 4th 5th 6th 7th 8th 9th
columns, properties 2nd 3rd 4th 5th
copying 2nd 3rd 4th 5th 6th
copying, code 2nd
DataTable objects 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
dsOrders extended property, code to populate 2nd
exposing in data services tier
manipulating 2nd
merge errors, handling 2nd 3rd 4th 5th 6th
merging 2nd 3rd 4th 5th
merging, code 2nd
properties, extended 2nd 3rd 4th 5th
properties, extended (code to populate) 2nd
Rows property 2nd 3rd 4th 5th 6th 7th 8th
Tables property 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
tables, cascading changes 2nd 3rd 4th
tables, constraints
tables, foreign key constraints 2nd 3rd 4th
tables, foreign key relations 2nd 3rd 4th
tables, primary key constraints 2nd
tables, unique constraints 2nd
DataTable 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
child collections
columns 2nd
events 2nd
loading, code 2nd
members
methods 2nd 3rd
properties 2nd 3rd
rows 2nd 3rd 4th 5th 6th 7th 8th
DataTableCollection
Add method
DataView 2nd 3rd 4th 5th
and relational databases, comparing
binding to controls, code 2nd
changes, capturing 2nd 3rd 4th 5th 6th
creating
data displays, simple and complex binding
DataTable objects
filtering 2nd
rows, finding 2nd
RowStateFilter property 2nd
sorting 2nd
views, managing 2nd 3rd 4th
DataViewSetting
default
SQL Server support
DOM
(Document Object Model)
dragging and dropping
dvsOrder
creating
dvsOrderDet
creating
hierarchies
DataViewManager class
HttpContext
IDbCommand
returning
IEnumerable interface
ListChangedEventArgs
listeners
custom
definition
MemoryStream
data, buffering
NET [edit, period before] Data Providers
OdbcCommand 2nd
OdbcConnection
ConnectionString property
OdbcParameter
OleDbCommand 2nd
arguments
OleDbError (.NET Data Providers)
Message property
NativeError property
Source property
SQLState property
parameter
Direction property, setting 2nd 3rd
parameters
DataFactory class
populating
code 2nd
RDO
(Remote Data Objects)
rdoResultset
Recordset 2nd
disconnected
Session
storage weaknesses in ASP 2nd
SqlCommand
methods
sqlConnection1
sqlDataAdapter1
SqlError
properties
SqlError (.NET Data Providers)
Class property
LineNumber property
Message property
Number property
Procedure property
Server property
Source property
State property
sqlUpdateCommand1
switch
SwlDataAdapter
properties, setting
System.Web.Caching.Cache
transaction
OleDb provider
SqlClient provider
Type
provider-specific, code to create 2nd 3rd 4th
UniqueConstraint
objects. [See also DataSet object]2nd [See also DataSet object]
ObjectSpaces Framework
and EJB (Enterprise Java Beans), comparing
customers
new, code to create 2nd
querying 2nd 3rd
updating 2nd 3rd
data
abstracting 2nd
OPath queries
persistence classes, creating 2nd 3rd
Customer classes, code 2nd 3rd
XML mapping files
persistent Customer classes, code 2nd
XML mapping files, creating 2nd 3rd
ODBC
( Open Database Connectivity) 2nd 3rd 4th
adapter patterns
architecture
data sources, accessing 2nd 3rd 4th 5th
commands, creating 2nd 3rd
connection pooling 2nd 3rd
connections, opening 2nd 3rd
Odbc provider 2nd 3rd 4th 5th
Driver Manager
connection pooling
drivers
NET [edit, period before] Data Provider
downloading
installing
WOSA
(Windows Open Services Architecture)
ODBC .NET Provider, downloading
Odbc data provider
architecture
Odbc provider
data
accessing
ODBC data sources 2nd 3rd 4th 5th
OdbcCommand object 2nd
OdbcConnection object
ConnectionString property
OdbcParameter object
OldIndex property
OLE DB 2nd 3rd 4th
adapter patterns
SQL Server OLE DB provider
OLE DB 2.5 interfaces
OleDb .NET Data Provider
transactons
OleDb provider
connection strings
specifying 2nd 3rd 4th
connections
pooling 2nd 3rd
OLE DB 2.5 interfaces
transaction objects
transactions 2nd
OleDbCommand object 2nd
arguments
OleDbDataAdapter
Fill method
protected signatures
OleDbError object (.NET Data Providers)
Message property
NativeError property
Source property
SQLState property
online resources
SQL Server Books Online
OPath
ObjectSpaces Framework
syntax
Open Database Connectivity. [See ODBC]
Open method 2nd
connection classes (.NET Data Providers)
SqlConnection class
opening
connections
for ODBC data sources 2nd 3rd
connections to data stores 2nd 3rd
Data Adapter Configuration Wizard
data readers
code 2nd
xsd [edit, period before] files
operations.
methods [See also Web services]
operators
AndAlso
Finally block
modulus
this [edit, ’ this “ is OK]
Operators (expression syntax rule)
data, selecting
optimistic concurrency
optimizing
application performance
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
application scalability
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
Option Strict statement
strongly typed DataSet classes
Orders and Customers tables, mapping to XSD schemas
code 2nd
Orders table
rows
traversing
Ordinal property
DataColumn class
Original value (DataRowVersion enumeration)
Original version
rows 2nd
OriginalRows value (DataViewRowState enumeration)
ORM
(Object Role Modeling)
definition
Object Role Modeling[colon] An Overview [edit, place title in double quotes]
output
ASP.NET pages, caching
WriteXmlChanges method 2nd
code 2nd
XML (FOR XML statement), code
output parameters
code
favoring over DataSets 2nd
of command objects 2nd 3rd
overloaded methods
data access classes 2nd 3rd 4th 5th 6th 7th 8th 9th
Overloads keyword
overviews
NET [edit, period before] Remoting
| for RuBoard |