Sams Teach Yourself ADO.NET in 21 Days
| for RuBoard |
daCategories object
DAO
(Data Access Objects)
data
abstracting
with ObjectSpaces Framework 2nd
access methods , building 2nd 3rd 4th
access techniques for databases (SQL Server)
server-side cursors 2nd 3rd 4th
SQLXML 2nd 3rd 4th 5th 6th 7th
accessing
functions, code to create 2nd
object-oriented syntax
relationally
with Data Adapter Configuration Wizard
with SQL Server .NET 2nd 3rd 4th 5th
adapters
configuring 2nd 3rd 4th
creating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
previewing
table mappings, code 2nd
update command, code to configure 2nd 3rd
update command, configuring 2nd
aggregation
binary
code to read 2nd
binding
code 2nd
buffering
in MemoryStream object
caches
disconnected (DataSet objects)
changing 2nd
connections
code 2nd
consuming in XML Web Services 2nd 3rd 4th
data, updating through Web services 2nd
VB .NET 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
data adapters
DataRowState enumeration
values 2nd
DataRowVersion enumeration
values
DataSet class
GetChanges method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
DataSets
creating 2nd 3rd
DataTable class
GetChanges method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
DataView object 2nd 3rd 4th
RowStateFilter property
DataViewRowState enumeration
values
deleting
DiffGrams 2nd 3rd 4th
displaying
simple and complex binding
exposing through XML Web Services
data access method, building 2nd 3rd 4th
data services tier 2nd 3rd 4th
technology 2nd 3rd 4th
Web services, building 2nd 3rd 4th 5th 6th
formatting
code 2nd
from DataSets
returning over WWW (World Wide Web)
in rows
changing 2nd
changing, code 2nd
internal data factory
locking
managing
in VS .NET Professional edition
manipulation
data readers
mapping
to object models
modification statements 2nd 3rd
modifying 2nd 3rd 4th 5th 6th
code 2nd
Odbc provider
of ADO Recordset objects
reading 2nd 3rd 4th 5th 6th 7th 8th 9th
read-only
caching
retrieving 2nd 3rd 4th 5th 6th
ExecuteReader method 2nd 3rd 4th 5th 6th
ExecuteScalar method 2nd 3rd
ExecuteXmlReader method 2nd 3rd 4th 5th 6th 7th 8th
Fill method 2nd 3rd 4th 5th
Fill method, rules 2nd
metadata, adding for SQL Server 2nd 3rd 4th 5th 6th 7th
result sets, retrieving 2nd 3rd 4th 5th 6th
retrieving from tables
code 2nd
retrieving incrementally, code 2nd
retrieving without strong-typing
row states 2nd 3rd 4th 5th 6th
row versions 2nd 3rd 4th 5th 6th 7th 8th 9th
sales (ComputeBooks stores)
code 2nd 3rd
selecting
Aggregate Functions (expression syntax rule)
Column Names (expression syntax rule)
expression syntax rules 2nd 3rd
Functions (expression syntax rule)
in DataSet class 2nd 3rd 4th 5th 6th 7th 8th
Literal Values (expression syntax rule)
Operators (expression syntax rule)
Parent and Child Relations (expression syntax rule)
Wildcard Characters (expression syntax rule)
selecting incrementally, code 2nd
sources
data readers
summarized for applications
tables
columns 2nd 3rd
rows 2nd 3rd 4th 5th 6th 7th 8th
structures 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
tables in DataSets
relationships, editing
TDS
(Tabular Data Stream) 2nd 3rd
Net-Library
relational database engines
updates
data readers
updating
through DataSets
updating through Web services 2nd
writing as XML (eXtensible Markup Language) 2nd 3rd 4th 5th 6th 7th 8th 9th
XML formats 2nd 3rd 4th 5th
Data Access Application Block [edit, double quotes] article
data access base class
code 2nd 3rd 4th
data access class
code 2nd 3rd 4th 5th
data access classes
designing
constructors 2nd 3rd 4th 5th 6th
custom objects, returning 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
data providers, abstracting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
data-centric or application-centric , comparing 2nd
design issues
naming conventions 2nd 3rd 4th
overloaded methods 2nd 3rd 4th 5th 6th 7th 8th 9th
private methods 2nd 3rd 4th 5th 6th 7th 8th 9th
data access events (Microsoft) timeline
Data Access Objects. [See DAO]
data access technologies
ADO.NET 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
SOAP (Simple Object Access Protocol)
W3C (World Wide Web Consortium) 2nd
XML (eXtensible Markup Language) 2nd 3rd 4th
MDAC
(Microsoft Data Access Components ) 2nd 3rd
ODBC
( Open Database Connectivity) 2nd 3rd 4th
OLE DB 2nd 3rd 4th
Recordset objects 2nd
Web improvements 2nd 3rd 4th 5th
data adapter class
ComputeBooks data provider 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
Data Adapter component (.NET Data Providers)
members 2nd
Data Adapter Configuration Wizard 2nd
concurrncy
data, accessing
opening
stored procedures, naming
data adapters 2nd
CbksDataAdapter class
code 2nd 3rd 4th 5th 6th
code 2nd
column mappings
code to create 2nd
command builders
methods
properties
concurrency
optimistic
pessimistic
data
code to modify 2nd
retrieving incrementally, code 2nd
selecting incrementally, code 2nd
data stores, updating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
command builders 2nd 3rd
concurrency 2nd 3rd 4th 5th 6th 7th 8th 9th
disconnected update models 2nd 3rd 4th 5th 6th
disconnected updates, code to implement 2nd 3rd 4th 5th
events 2nd 3rd 4th 5th
isolation 2nd 3rd 4th
pessimistic concurrency, code 2nd
pessimistic concurrency, code to configure 2nd 3rd
rows, refreshing 2nd
RowUpdated event 2nd 3rd 4th 5th
RowUpdating event 2nd 3rd 4th 5th
data, retrieving 2nd 3rd 4th 5th
Fill method 2nd 3rd 4th 5th
metadata, adding for SQL Server 2nd 3rd 4th 5th 6th 7th
result sets, retrieving 2nd 3rd 4th 5th 6th
DataSets
GetChanges method
Update method
Fill method 2nd 3rd 4th 5th 6th
protected signatures
rules 2nd
table mapping names, passing
implementing
code 2nd 3rd 4th 5th 6th
MissingMappingAction enumeration values
MissingSchemaAction enumeration values
MissingSchemaAction property 2nd 3rd
OleDbDataAdapter
Fill method
Fill method, protected signatures
properties
extended, code to retrieve 2nd
schema generation
Add value (MissingSchemaAction enumeration)
AddWithKey value (MissingSchemaAction enumeration) 2nd
Error value (MissingMappingAction enumeration)
Error value (MissingSchemaAction enumeration) 2nd
Ignore value (MissingMappingAction enumeration)
Ignore value (MissingSchemaAction enumeration) 2nd
MissingMappingAction enumeration values
MissingSchemaAction enumeration values
MissingSchemaAction property 2nd 3rd
Passthrough value (MissingMappingAction enumeration)
table mappings 2nd 3rd 4th 5th 6th 7th 8th
SelectCommand 2nd
SET NO_BROWSETABLE ON statement
SqlDataAdapter
connections, opening and closing
Fill method, protected signatures
stored procedures
multi-function , code 2nd
table columns
names
table mappings 2nd 3rd 4th 5th 6th 7th 8th
code to create 2nd
table rows
Both value (UpdateRowSource enumeration)
None value (UpdateRowSource enumeration)
OutputParameters value (UpdateRowSource enumeration)
UpdateRowSource enumeration, values
updating, Command property (event arguments) 2nd
updating, Errors property (event arguments) 2nd
updating, event argument properties 2nd
updating, RecordsAffected property (event arguments)
updating, Row property (event arguments) 2nd
updating, StatementType property (event arguments) 2nd
updating, Status property (event arguments) 2nd
updating, TableMapping property (event arguments) 2nd
transactions
data adapters (.NET Data Providers) 2nd
AcceptChangesDuringFill property
ContinueUpdateOnError property
DeleteCommand property
Fill method
FillError method
FillSchema method
GetFillParameters method
InsertCommand property
members
MissingMappingAction property
MissingSchemaAction property
RowUpdated method
RowUpdating method
SelectCommand property
TableMappings property
Update method
UpdateCommand property
data adaptes
Fill method
columns, duplicate names
data binding
programmatic code 2nd
Web Forms presentation services tier 2nd 3rd
data binding expression
Mobile Control binding
multi-record binding 2nd 3rd 4th 5th
single-value binding 2nd 3rd 4th 5th
Windows Forms presentation services tier 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
data binding expression
definition
data binding expressions
%# % [edit, HTML brackets) tags
templated controls
Data Connections node (Server Explorer window) 2nd 3rd 4th 5th
Data Definition Language (DDL) statements
data factory class
BeginTransaction method
building
CacheFilePath property
caching 2nd
code files, downloading
Connection property
CreateDataAdapter method
CreateSqlFile method
CreateSqlFiles method
creating
data providers
abstracting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
data types 2nd 3rd
code to reference 2nd
database independence
DataFactory class 2nd 3rd 4th 5th 6th 7th
code 2nd 3rd 4th
configuring, code 2nd
implementing, code 2nd 3rd
performance measurements 2nd
DataSet class
code to return 2nd
definition
events
ExecuteDataReader method
ExecuteNonQuery method
ExecuteScalar method
ExecuteSqlXmlReader method
GetDataSet method
GetDataTable method
GetProviders method
GetXsltResults method
methods 2nd
properties
Provider property
public members
RemoveStatement method
SqlFilesCreated event
statements
abstracting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th
caches 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
caching, code 2nd 3rd 4th
creating, code 2nd 3rd 4th
data providers, code to set 2nd
files, code 2nd
files, code to create 2nd 3rd 4th
files, code to parse 2nd 3rd
files, creating 2nd 3rd 4th 5th 6th
files, parsing 2nd 3rd 4th 5th 6th
returning
SyncDataSet method
Type objects (provider-specific), code to create 2nd 3rd 4th
UseCache property
Data Link Properties dialog box 2nd
data providers
abstracting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
for data access classes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
abstracting, code 2nd 3rd 4th 5th
ComputeBooks
architecture
command class 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
connection class 2nd 3rd 4th 5th 6th 7th 8th
data adapter class 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
exception class 2nd
implementing 2nd 3rd
parameters classes 2nd 3rd 4th 5th 6th 7th 8th 9th
VB code
data aggregation
data types 2nd 3rd
code to reference 2nd
definition
drivers
supporting
full providers
IDataAdapter interface
IDataParameter interface
IDataParameterCollection interface
IDataReader interface
IDbCommand interface
IDbConnection interface
IDbDataAdapter interface
IDbDataAdapterParameter interface
IDbTransaction interface
lightweight providers
MSDataShape
code 2nd
narrow
managed code 2nd
NET [edit, period before]
command object
Odbc
architecture
data, accessing
ODBC data sources 2nd 3rd 4th 5th
OleDb .NET Data Provider
transactons
proprietary data stores
setting
code 2nd
specific
SqlClient
InfoMessage events
SqlClient .NET Data Provider 2nd
Net-Library
relational database engines
TDS (Tabular Data Stream) 2nd 3rd
SqlClient types
code 2nd
targeted
Type objects (provider-specific), code to create 2nd 3rd 4th
data providers. [See also .NET Data Providers;]
data reader (.NET Data Providers) 2nd 3rd 4th
Close method
Depth property
FieldCount property
GetBoolean method
GetByte method
GetBytes method
GetChar method
GetChars method
GetDataTypeName method
GetDateTime method
GetDecimal method
GetDouble method
GetFieldType method
GetFloat method
GetGuid method
GetInt16 method
GetInt32 method
GetInt64 method
GetName method
GetOrdinal method
GetRows method
GetSchemaTable method
GetString method
GetTimespan method
GetValue method
GetValues method
IDataReader interface
IDataRecord interface
IsClosed property
IsDbNull method
Item property
members
NextResult method
Read method
RecordsAffected property
data readers 2nd
and DataSets, comparing 2nd
architecture
arrays
code to write 2nd
binary data
code to read 2nd
binding to DropDownList controls, code 2nd
Close method
CloseConnection command
connection objects
exceptions
connections
data manipulation
data modification statements 2nd 3rd
data providers
;SQL Client types, code 2nd
data sources
data updates
DbType enumeration values
definitions
ExecuteReader method
executing
code 2nd
exposing
in data services tier
managed code 2nd
manually binding to ListView controls, code 2nd
MoveNext method
MSDataShape provider 2nd
NET [edit, period before] Remoting 2nd
objects
populating, code 2nd
opening
code 2nd
performance 2nd
polymorphism 2nd
code 2nd
result sets, code to retrieve 2nd
result sets, returning 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
returning
schema retrieval
GetSchema Table method 2nd 3rd
strong-typing 2nd
traversing 2nd
column multiple values, code to read 2nd
column multiple values, retrieving 2nd 3rd 4th 5th 6th
column single values, retrieving 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
column strongly typed values, code to retrieve 2nd
Read method 2nd
data services applications
definition
data services tier 2nd 3rd 4th
abstract base classes 2nd
abstracted providers
base classes
conditional tracing 2nd 3rd 4th 5th
connection management
creating 2nd 3rd 4th 5th 6th 7th 8th
custom exceptions 2nd 3rd
exception handling
tracing
custom objects, exposing
data access classes, designing
constructors 2nd 3rd 4th 5th 6th
custom objects, returning 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
data providers, abstracting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
data-centric or application-centric, comparing 2nd
design issues
naming conventions 2nd 3rd 4th
overloaded methods 2nd 3rd 4th 5th 6th 7th 8th 9th
private methods 2nd 3rd 4th 5th 6th 7th 8th 9th
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
serviced components, handling 2nd 3rd 4th 5th 6th 7th
XML Web Services
data, exposing 2nd 3rd 4th
Data Source attribute (SqlClient provider)
data sources
connections
creating 2nd 3rd 4th 5th
IBindingList interface
IEditableObject interface
IList interface
IListSource interface
SQL Server OLE DB provider
data sources (ODBC), accessing 2nd 3rd 4th 5th
commands
creating 2nd 3rd 4th 5th 6th 7th 8th
connection pooling 2nd 3rd
connections, opening 2nd 3rd
data stores
connection classes 2nd
connections
opening 2nd 3rd
data, locking
OleDb .NET Data Provider
transactons
updating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
command builders 2nd 3rd
concurrency 2nd 3rd 4th 5th 6th 7th 8th 9th
disconnected update models 2nd 3rd 4th 5th 6th
disconnected updates, code to implement 2nd 3rd 4th 5th
events 2nd 3rd 4th 5th
isolation 2nd 3rd 4th
pessimistic concurrency, code 2nd
pessimistic concurrency, code to configure 2nd 3rd
rows, refreshing 2nd
RowUpdated event 2nd 3rd 4th 5th
RowUpdating event 2nd 3rd 4th 5th
data types
data factory class 2nd 3rd
Integer
mapping
referencing
code 2nd
schemas 2nd 3rd 4th 5th 6th
timestamp
rowversion synonym
UDTs
( user -defined data types) 2nd
data types (SQL Server)
binary and varbinary, comparing
char and varchar, comparing
comparing 2nd 3rd 4th 5th 6th
datetime and smalldatetime, comparing
decimal and numeric, comparing
float and real, comparing
money and smallmoney, comparing
nchar and nvarchar, comparing
System.Data.SqlTypes namespace
text and ntext, comparing
timestamp and uniqueidentifier, comparing
tinyint and bit, comparing
varbinary and image, comparing
varchar and nvarchar, comparing
data-centric or application-centric (designing data access classes), comparing 2nd
database administrator. [See DBA]
Database property
connection classes (.NET Data Providers)
databases
changing
with DataSet object
ComputeBooks
;Titles table
Categories table
connecting to
entity relationship diagram
stored procedures
connections
pooling through ADO
data
DataRowState enumeration, values 2nd
DataRowVersion enumeration, values
DataSet class, GetChanges method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
DataTable class, GetChanges method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
DataView object 2nd 3rd 4th
DataView object, RowStateFilter property
DataViewRowState enumeration, values
DiffGrams 2nd 3rd 4th
in rows, changing 2nd
in rows, code to change 2nd
mapping to object models
modifying 2nd 3rd
row states 2nd 3rd 4th 5th 6th
row versions 2nd 3rd 4th 5th 6th 7th 8th 9th
summarized for applications
data adapters
DBA
(database administrator)
ER
(entity-relationship) modeling
ERD
(entity relationship diagram) modeling
attributes, definition
entity, cardinality
entity, definition
entity, relationships
identifiers, definition
independence
for data factory class
indexes
performance optimization 2nd
ODBC
(Open Database Connectivity) 2nd 3rd 4th
output parameters
favoring over DataSets 2nd
queries
covered
VaryByParam attribute
RDS
(Remote Data Services
references
relational
Access
and DataView objects, comparing
relational database engines
TDS (Tabular Data Stream)
round-tripping
definition
schemas
3NF (Third Normal Form) 2nd
definition
IDENTITY columns
schmeas
code to create 2nd
servers
assemblies, storing
round trips to, minimizing 2nd
SQL Server
inspecting
stored procedures
performance optimization
UDA
(Universal Data Access) strategy
XML Schema, creating dynamically 2nd 3rd 4th 5th 6th
databases (SQL Server)
data access techniques
designing 2nd
index design 2nd 3rd
schema design 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
schemas
check constraints 2nd
constraints
data types 2nd 3rd 4th 5th 6th
default constraints 2nd 3rd
foreign key constraints 2nd 3rd
naming 2nd 3rd 4th 5th 6th
normalizing 2nd 3rd 4th 5th 6th
rules
triggers 2nd 3rd 4th 5th 6th 7th
UDT (user-defined data types) 2nd
security 2nd
server-side cursors 2nd 3rd 4th
SQLXML 2nd 3rd 4th 5th 6th 7th
stored procedures
layer design 2nd 3rd 4th 5th 6th 7th 8th
databases. [See also ComputeBooks, database]2nd [See also ComputeBooks database]
DataBind events
DataBind method
DataBinder class
Eval method
DataBinding events 2nd
DataBindings dialog box
single-value binding
yellow barrel icon
DataColumn class
AllowDBNull property 2nd
AutoIncrement [See d property]2nd [See d property]
AutoIncrement property 2nd
AutoIncrementStep property 2nd
Caption property
ColumnMapping property
ColumnName property 2nd
DataType property 2nd 3rd
CTS (Common Type System) types 2nd
DefaultValue property
Expression property 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
Extended Properties property
MaxLength property 2nd
members 2nd 3rd 4th
Namespace property
Ordinal property
Prefix property
properties 2nd 3rd
ReadOnly property
Table property
Unique property 2nd
DataColumnMapping object
DataFactory class 2nd 3rd 4th 5th 6th 7th 8th
ASP.NET caching
BooleanSwitch class
code 2nd
configuring
code 2nd
data providers, abstracting
df variable
ExecuteScalar method
code 2nd 3rd
implementing
code 2nd 3rd
parameter objects
performance measurements 2nd
titles
retrieving, code 2nd
DataGrid
controls
adding to caches
relationships
navigating
DataGrid control
event binding
code 2nd
event editing
code 2nd 3rd 4th
format
DataGrid object
relationships
navigating
DataGrid Properties dialog box
Columns tab 2nd
General tab
Paging tab
DataGridPageChanged object
DataRelation object
foreign keys 2nd 3rd 4th
DataRelationCollection class
Add method
DataRow class
AcceptChanges method
BeginEdit method
CancelEdit method
ClearErrors method
Delete method
EndEdit method
GetChildRows method
GetColumnError method
GetColumnsInError method
GetParentRow method
GetParentRows method
HasErrors property
HasVersion method
IsNull method
Item property
ItemArray property
members 2nd 3rd 4th 5th
methods 2nd 3rd
properties 2nd
RejectChanges method
RowError property
RowState property
SetColumnError method
SetParentRow method
Table property
DataRow object
Item property 2nd
RowState property 2nd
DataRowChangeEventArgs object
DataRowCollection object
Find method
DataRowState enumeration
values 2nd
DataRowVersion enumeration
values
DataSet class 2nd 3rd
AcceptChanges method
Aggregate Functions (expression syntax rule)
CaseSensitive property
Clear method
Clone method
collections
Column Names (expression syntax rule)
Copy method
data
selecting 2nd 3rd 4th 5th 6th 7th 8th
DataSetName property
DefaultViewManager property
Detached rows
DiffGrams 2nd 3rd 4th
EnforceConstraints property
events
expression syntax rules 2nd 3rd
ExtendedProperties property
Functions (expression syntax rule)
GetChanges method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th
GetXml method
GetXmlSchema method
HasChanges method
HasErrors property
IListSource interface
InferXmlSchema method
Literal Values (expression syntax rule)
members
Merge method
MergeFailed event
methods 2nd 3rd
Namespace property
NET [edit, period before] Framework
Operators (expression syntax rule)
Parent and Child Relations (expression syntax rule)
populating 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, selecing 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)
Prefix property
properties 2nd
ReadXML method
ReadXMLSchema method
RejectChanges method
Relations collection
Reset method 2nd
returning
code 2nd
structures
loading at runtime, code 2nd
System.ComponentModel.MarshalByValueComponent class
Tables collection
traversing 2nd 3rd 4th 5th 6th
code 2nd 3rd
Unchanged rows
Wildcard Characters (expression syntax rule)
WriteXml method
WriteXmlSchema method 2nd
DataSet classes
CLR (Common Language Runtime)
inheritance
ExtendedProperties collection
time, storing
Generate DataSet option
loading 2nd 3rd
code 2nd 3rd 4th
passing 2nd 3rd 4th 5th 6th
saving 2nd 3rd
code 2nd 3rd 4th
strongly typed
Add New Item dialog box 2nd
building 2nd
creating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd
defining 2nd 3rd
goals 2nd 3rd 4th
implementation inheritance 2nd 3rd
interface inheritance 2nd
Option Strict statement
populating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
purpose 2nd 3rd 4th
serialization
serialization, passing DataSets 2nd 3rd 4th 5th 6th
serialization, persisting to disks 2nd 3rd 4th 5th 6th 7th 8th 9th
sharing 2nd 3rd 4th 5th 6th 7th
type checkers
VC# .NET console application project
versioning 2nd 3rd 4th 5th 6th 7th
Xml Schemas/DataTypes utility (XSD.exe)
TitleDs DataSet
TitlesDs.cs file
source code, classes generated 2nd 3rd
viewing
DataSet object
data
modifying 2nd 3rd
row states 2nd 3rd 4th 5th 6th
row versions 2nd 3rd 4th 5th 6th 7th 8th 9th
data adapters
databases
changing
DataView object 2nd 3rd 4th
RowStateFilter property
row versions
tracking 2nd 3rd
tracking, code 2nd
WriteXml method
DiffGrams, creating
DataSet objects
cloning 2nd 3rd 4th 5th 6th
columns
auto-incrementing 2nd 3rd 4th 5th 6th
auto-incrementing, code to define tables 2nd
expressions 2nd 3rd 4th 5th 6th 7th 8th 9th
properties 2nd 3rd 4th 5th
properties, code to set 2nd
Columns property 2nd 3rd
consuming
in XML Web Services
copying 2nd 3rd 4th 5th 6th
code 2nd
data cache, disconnected
DataTable objects 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
dsOrders extended propertycode to populate 2nd
exposing
in data services tier
through XML Web Services
manipulating 2nd
merge errors, handling 2nd 3rd 4th 5th 6th
merging 2nd 3rd 4th 5th
code 2nd
properties
extended 2nd 3rd 4th 5th
extended, code to populate 2nd
Rows property 2nd 3rd 4th 5th 6th 7th 8th
tables
constraints
constraints, cascading changes 2nd 3rd 4th
constraints, foreign key relations 2nd 3rd 4th
constraints, foreign keys 2nd 3rd 4th
constraints, primary keys 2nd
constraints, unique 2nd
Tables property 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
Web services
DataSet property
DataTable class
DataSetIndex property
DataSetName property
DataSet class
DataSets
;XML
(eXtensible Markup Language) 2nd 3rd 4th 5th 6th 7th 8th
and data readers, comparing 2nd
Datasets
and data tables
relationships, editing
DataSets
AppDomains, passing between
columns
copying from
code 2nd
creating 2nd 3rd
data
returning over WWW (World Wide Web)
updating
writing as XML (eXtensible Markup Language) 2nd 3rd 4th 5th 6th 7th 8th 9th
XML (eXtensible Markup Language) formats 2nd 3rd 4th 5th
data adapters
code 2nd
DiffGram
XML (eXtensible Markup Language)
GetChanges method
Load event
code 2nd
manipulating as XML (eXtensible Markup Language), code 2nd
output parameters, favoring over DataSets 2nd
remoted
NET [edit, period before] Remoting
schemas
creating from databases, code 2nd
infering from documents, inference rules 2nd 3rd
table names, case sensitivity
tables
updating
TitlesDs DataSet
populating
populating, code 2nd
transforming
code 2nd
Update method
WriteTitleXml function
rows, code to copy 2nd
Datasets
writing as XML (eXtensible Markup Language)
code 2nd
DataSets
XML
(eXtensible Markup Language) 2nd 3rd
reformatted, code 2nd
XmlDataDocument class
nodes, adding
XML, loading
XmlReadMode enumeration
ReadXml method 2nd 3rd
XSD
code to modify 2nd
XSD mapping rules 2nd 3rd
DataTable
columns
populating
schemas
generating with MissingSchemaAction property
DataTable class
AcceptChanges method
BeginLoadData method
CaseSensitive property
ChildRelations property
Clear method
Clone method
ColumnChanged event
ColumnChanging event
Columns property
Compute method
Constraints property
Copy method
DataSet property
DefaultView property
DiffGrams 2nd 3rd 4th
DisplayExpression property
EndLoadData method
ExtendedProperties property
GetChanges method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th
HasErrors property
IListSource interface
ImportRow method
inspecting 2nd
code 2nd 3rd 4th 5th
LoadDataRow method
MinimumCapacity property
Namespace property
NewRow method
ParentRelations property
Prefix property
PrimaryKey property
RejectChanges method
Reset method 2nd
RowChanged event
RowChanging event
RowDeleted event
RowDeleting event
rows
AcceptChanges methods 2nd
committing to tables
RejectChanges methods 2nd 3rd
Rows property
rows, committing to tables 2nd
Select method
TableName property
DataTable classes
columns
DataTable object
child collections
events 2nd
members
methods 2nd 3rd
properties 2nd 3rd
DataTable objects 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
columns 2nd
loading
code 2nd
rows 2nd 3rd 4th 5th 6th 7th 8th
DataTableCollection object
Add method
DataType property
CTS (Common Type System) types 2nd
DataColumn class 2nd 3rd
DataView class
AddNew method
AllowDelete property
AllowEdit property
AllowNew property
ApplyDefaultSort property
CopyTo method
Count property
DataViewManager property
Delete method
events
Find method
FindRows method
Item property
ListChanged event
members 2nd
methods
properties 2nd 3rd
RowFilter property 2nd
RowStateFilter property
Sort property
Table property
DataView object 2nd 3rd 4th
RowStateFilter property 2nd
DataView objects
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
sorting 2nd
views
managing 2nd 3rd 4th
DataViewManager class
object hierarchy
DataViewManager property
DataView class
DataViewRowState enumeration
values
DataViewSetting object
datetime data type
and smalldatetime data type, comparing
DBA
(database administrator)
DbType enumeration values
definitions
DbType property
parameters (.NET Data Providers)
DDL (Data Definition Language) statements
debugging
code
with SQL Profiler
with SqlClient provider
SQL Server
Profiler utility
decimal data type
and numeric data type, comparing
declarations
msdata namespace
of arrays
in C#
in VB
declarative referential integrity. [See DEI]
default constraints
schemas 2nd 3rd
default objects
SQL Server support
Default value (command objects)
Default value (DataRowVersion enumeration)
Default version
rows
DefaultValue property
DataColumn class
DefaultView property
DataTable class
DefaultViewManager property
DataSet class
defining
strongly typed DataSet classes 2nd 3rd
tables
code 2nd
definitions
3NF (Third Normal Form)
abstracted providers
adapter patterns
AppDomains (Application Domains)
assembly 2nd
attributes
business services applications
camel case
cardinality
clustered indexes 2nd
code-behind files
complex binding
concurrency
constructors
covered queries
data binding expression
data factory class
data providers
data services applications
DbType enumeration values
DRI (declarative referential integrity)
entity
ER (entity-relationship) modeling
ERD (entity relationship diagram) modeling
functions
identifiers
initializer list
interface inheritance
listeners
man to many relationships
managed code
manifests
modules 2nd
multi-record binding
NLB (Network Load Balancing)
nonclustered indexes 2nd
normalization
ORM (Object Role Modeling)
Pascal case
PIA (primary interop assembly)
polymorphism
presentation applications
public keys (strong names)
reference types
relationships
remotable types
round-tripping databases
scale-out
scale-up
schemas
server affinity
server cursors
service components
simple binding
single-value binding
statement
table scans
table-level constraints
two-tier applications
UDDI (Universal Description, Discovery and Integration)
UDTs (user-defined data types)
uppercase
value types
views
Web User Control
XML Bulkload
XML UpdateGram
XML Views
delegates
arguments
passing to
asynchronous
GetTitlesDone method
calling through, code 2nd
managed code 2nd 3rd 4th 5th 6th 7th
MergeFailedEventHandler
NET [edit, period before]
Delete method
DataRow class
DataView class
DeleteCommand property
data adapters (.NET Data Providers)
deleted
rows 2nd
Deleted value (DataRowState enumeration)
Deleted value (DataViewRowState enumeration)
DeletedRowInaccessibleException
throwing
DeleteRule property
DeleteTitle method
Titles table rows
code to delete 2nd
deleting
data
Title table rows, code 2nd
Depth property
data reader (.NET Data Providers)
design goals of ADO.NET
ADO knowledge, leveraging 2nd
multi-tiered programming models 2nd
programming errors, reducing 2nd 3rd
relational and object-oriented paradigms , combining 2nd
XML (eXtensible Markup Language) standards, integrating 2nd
Design Guidelines for Class Library Developers [edit, title in double quotes]
design patterns
object oriented
Design Patterns Explained
A New Perspective on Object-Oriented Design [edit, italics]
DesignerAttribute type
designers
NET [edit, period before] Framework
VS .NET 2nd
objects
dragging and dropping
XML Schema Designer
Reviews element 2nd
designing
data access classes
constructors 2nd 3rd 4th 5th 6th
custom objects, returning 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
data providers, abstracting 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
data-centric or application-centric, comparing 2nd
design issues
naming conventions 2nd 3rd 4th
overloaded methods 2nd 3rd 4th 5th 6th 7th 8th 9th
private methods 2nd 3rd 4th 5th 6th 7th 8th 9th
databases (SQL Server) 2nd
index design 2nd 3rd
schema design 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
schemas, check constraints 2nd
schemas, constraints
schemas, data types 2nd 3rd 4th 5th 6th
schemas, default constraints 2nd 3rd
schemas, foreign key constraints 2nd 3rd
schemas, naming 2nd 3rd 4th 5th 6th
schemas, normalizing 2nd 3rd 4th 5th 6th
schemas, rules
schemas, triggers 2nd 3rd 4th 5th 6th 7th
schemas, UDT (user-defined data types) 2nd
security 2nd
stored procedure layer design 2nd 3rd 4th 5th 6th 7th 8th
indexes 2nd 3rd
designs
stored procedure layers 2nd 3rd 4th 5th 6th 7th 8th
Detatached rows
DataSet class
detatched
rows 2nd
Detatched value (DataRowState enumeration)
developers
SQL Server 2000
stored procedures 2nd
df variable
diagrams
databases
ERD (entity relationship diagram) modeling
entity relationships
ComputeBooks database
dialog boxes
Add New Item
strongly typed DataSet classes 2nd
Add Reference
Add Web References 2nd
Add Web User Control
Advanced
simple binding 2nd
Data Link Properties 2nd
DataBindings
single-value binding
yellow barrel icon
DataGrid Properties
Columns tab 2nd
General tab
Paging tab
Edit Relation
New Project
Windows Forms applications, creating
Property Builder
Show All Files
Table Mappings 2nd
dictionaries
HybridDictionary class
DiffGram
XML (eXtensible Markup Language)
DiffGram value (XmlReadMode enumeration) 2nd
DiffGrams
creating
code 2nd
with WriteXml method
table changes 2nd 3rd 4th
XML
creating, code 2nd 3rd
direct approach
in data services tier
Direction property
parameter objects 2nd 3rd
parameters (.NET Data Providers)
directives
VaryByParam attribute
disabling
connection pooling
validation
disconnected data caches (DataSet objects)
disconnected Recordset objects
disconnected update models
data stores, updating 2nd 3rd 4th 5th 6th
disconnected updates
code to implement 2nd 3rd 4th 5th
disks
persisting to
DataSet serialization 2nd 3rd 4th 5th 6th 7th 8th 9th
DisplayExpression property
DataTable class
displaying
data
simple and complex binding
distributed transactions
code 2nd
distributing
logical tiers 2nd
dlls
System.Data.dll
Document Object Model. [See DOM]
documents
DOM
(Document Object Model)
schemas, infering from
inference rules 2nd 3rd
XML
accessing
XML schema, creating dynamically 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
XSD
code 2nd 3rd
DOM
(Document Object Model)
domains
AppDomains (Application Domains)
definition
NET [edit, period before] Remoting
data readers 2nd
downloading
data factory class code files
MDAC (Microsoft Data Access Components) SDK
MMIT (Microsoft Mobile Internet Toolkit)
ODBC .NET Data Provider
ODBC .NET Provider
dragging and dropping
objects
Title table 2nd
DRI
(declarative referential integrity)
definition
Driver Manager (ODBC)
connection pooling
drivers
data provider supported
Microsoft newsgroup
ODBC
DropDownList controls
data readers
binding, code 2nd
dropping
dragging and dropping
objects
Title table 2nd
DSN
DSN-less
connections, opening 2nd
system
connections, opening
user
connections, opening
DSN-less connection
connections, opening 2nd
dsOrders extended property (DataSet object)
populating, code 2nd
dvsOrder object
creating
dvsOrderDet object
creating
dynamic SQL
and stored procedures, comparing 2nd 3rd
dynamically creating
XML (eXtensible Markup Language) schema 2nd
databases, filling from 2nd 3rd 4th 5th 6th
documents, loading from 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
schemas, loading from 2nd 3rd 4th 5th 6th 7th
XSD
| for RuBoard |