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]

sales data (ComputeBooks stores)

code 2nd 3rd

Sams Publishing Web site

data factory class, downloading code files

Sams Teach Yourself XML in 21 Days [edit, italics], Second Edition

Sams Teach Yourself XML in 21 Days, Second Edition [edit, italics]

save points

SaveDs method 2nd

SaveMyData method 2nd

SaveTitles method

saving

DataSet classes 2nd 3rd

code 2nd 3rd 4th

scalability 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

Scale property

parameters (.NET Data Providers)

scale-out

applications

definition

scale-up

definition

scalibility

applications

schemas

check constraints 2nd

constraints

DRI (declarative referential integrity)

table-level, definition

creating from databases, code 2nd

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

databases

3NF (Third Normal Form) 2nd

IDENTITY columns

default constraints 2nd 3rd

definition

foreign key constraints 2nd 3rd

generating

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

infering from documents

inference rules 2nd 3rd

mapping. [See also XML Views]

naming 2nd 3rd 4th 5th 6th

normalizing 2nd 3rd 4th 5th 6th

retrieving

GetSchemaTable method 2nd 3rd

rules

SQL Server databases

designing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

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

code 2nd

UDT ( user -defined data types) 2nd

XML

vieiwng

XML (eXtensible Markup Language), creating 2nd

XML Schema Designer 2nd 3rd

XML Schema Toolbox (XML Schema tab)

XSD documents, code 2nd 3rd

XML (eXtensible Markup Language), creating dynamically 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

importing into VS .NET

SchemaType.Mapped

scope

of transactions

SDKs

MDAC (Microsoft Data Access Components ), downloading

security

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

databases (SQL Server)

designing 2nd

FullTrust permission set

imperative

imperative, code 2nd

permissions

imperative

imperative, code 2nd

stored procedures 2nd

Select method

data, selecting

DataTable class

or parameters, when to use 2nd

or WHERE clause, when to use 2nd

SELECT statements

data requests , appropriate

WHERE clause

SelectCommand 2nd 3rd 4th

SelectCommand property 2nd

data adapters (.NET Data Providers)

selecting

data

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

incrementally, code 2nd

semicolon (

) 2nd

SequentialAccess command

SequentialAccess value (command objects)

Serializable attribute

Serializable attribute (ComputeBooksDAException class)

serialization

strongly typed DataSet classes

DataSets, passing 2nd 3rd 4th 5th 6th

disks, persisting to 2nd 3rd 4th 5th 6th 7th 8th 9th

server affinity

definition

Server Explorer window 2nd

Data Connections node 2nd 3rd 4th 5th

Data Link Properties dialog box 2nd

SQL Server OLE DB provider

XSD (XML Schema Definition), creating

Server property

SqlError object (.NET Data Providers)

server-side access. [See SQL Server .NET, CLR (Common Language Runtime)]

server-side cursors

code 2nd

data, accessing 2nd 3rd 4th

servers

cursors, definition

databases

round trips to, minimizing 2nd

for databases

assemblies, storing

joins

performing 2nd

keys

generating 2nd

MTS

(Microsoft Transaction Server)

MTS (Microsoft Transaction Server)

remote

referencing

SQL Server

Books Online

Profiler utility

ReadCommitted mode

ReadUncommitted mode

return values, specifying

save points

SQL Server 2000

stored procedures 2nd

SQL Server databases

inspecting

SQL Server OLE DB provider

service components

definition

serviced component base class

code 2nd 3rd 4th 5th

serviced components

connection strings

storing 2nd 3rd 4th 5th

transactions 2nd 3rd 4th 5th 6th

serviced components, handling 2nd 3rd 4th 5th 6th 7th

ServicedComponent class

services

COM+ (Component Services)

Component Services

Building Distributed Applications with Visual Basic .NET [edit, italics]

Web

building 2nd 3rd 4th 5th 6th

Catalog, referencing 2nd

data, updating 2nd

references, updating

testing 2nd

Services Framework

code

conforming to

services. [See also Web services]2nd [See also XML Web Services]

Session object

storage weaknesses in ASP 2nd

session pooling

session states

ASP.NET State service storage 2nd

Load events, code 2nd

SQL Server storage 2nd 3rd

turning off

Web Forms applications 2nd 3rd 4th 5th 6th

SET NO_BROWSETABLE ON statement

SET SHOWPLAN ON statement

SetColumnError method

DataRow class

SetDefault values

primary keys

SetNull values

primary keys

SetParentRow method

DataRow class

setupDataAdapter method

Shalloway, Design Patterns Explained

A New Perspective on Object-Oriented Design [edit, italics]

sharing

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

Shepherd, Dawn

Shepherd, Devan

Show All Files dialog box

Show All Files icon

showOriginal method

signatures

protected

simple binding 2nd 3rd 4th

Advanced dialog box 2nd

data, displaying

definition

formatting 2nd 3rd

navigation 2nd 3rd

Properties window 2nd

Simple Object Access Protocol (SOAP)

XML Web Services

Simple Object Access Protocol. [See SOAP]

simple validation

Validating and Validated events, code 2nd

simpleType icon (XML Schema tab of XML Schema Toolbox)

simplification

stored procedures

single quotation marks ( ” ”)

single values

of columns, retrieving 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

single-value binding 2nd 3rd 4th

DataBindings dialog box

definition

SingleResult value (command objects)

SingleRow command

behavior

SingleRow value (command objects)

SingleRow value (CommandBehavior enumeration), passing to the ExecuteReader method

Size property

parameters (.NET Data Providers)

skeleton classes

XSD.exe command-line utility

smalldatetime data type

and datetime data type, comparing

smallmoney data type

and money data type, comparing

SOAP

(Simple Object Access Protocol)

Catalog Web service

code to call 2nd

CLR

(Common Language Runtime)

Global XML Web Service Architecture

SQL Server

W3C (World Wide Web Consortium) Web site

Web service methods

SOAP (Simple Object Access Protocol)

XML Web Services

SoapDocumentService attribute

parameters, encoding

SoapRpcMethod attribute

Web method

software

databases

round-tripping

NLB (Network Load Balancing)

Solution Explorer

Add New Item dialog box

Add Web User Control dialog box

Class View

Show All Files dialog box

TitlesDs.xsd file

Generate DataSet option

Web References folder

Solution Explorer window

DataSet classes, viewing

Solution ExplorerAdd Web Reference command (context menu)

Sort property 2nd

DataView class

sorting

DataView objects 2nd

source code

TitlesDs.cs file

classes generated 2nd 3rd

Source property

OleDbError object (.NET Data Providers)

SqlError object (.NET Data Providers)

SourceColumn property

parameters (.NET Data Providers)

sources. [See also data sources]2nd [See also data, sources]

SourceVersion property

parameters (.NET Data Providers)

sp_executesql stored procedure

in SQL Server

special characters

column names

specialization of multi-tiered applications

specific data providers

specific providers (.NET Data Providers)

specific versus generic providers 2nd 3rd

Split method

SQL

(Structured Query Language)

DDL (Data Definition Language) statements

dynamic

and stored procedures, comparing 2nd 3rd

Transact -SQL EXISTS clause

SQL Profiler

code, debugging

SQL Server 2nd 3rd

adapter patterns

binary and varbinary data types, comparing

Books Online

char and varchar data types, comparing

client architecture

Data Access Application Block [edit, double quotes] article

data providers

data types

comparing 2nd 3rd 4th 5th 6th

System.Data.SqlTypes namespace

databases

3NF (Third Normal Form) 2nd

data access techniques

designing 2nd

IDENTITY columns

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

server-side cursors 2nd 3rd 4th

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

stored procedure layer design 2nd 3rd 4th 5th 6th 7th 8th

datetime and smalldatetime data types, comparing

decimal and numeric data types, comparing

float and real data types, comparing

INSTEAD OF triggers

metadata

adding for data retrieval 2nd 3rd 4th 5th 6th 7th

money and smallmoney data types, comparing

nchar and nvarchar data types, comparing

objects

default

ODBC

adapter patterns

OLE DB

adapter patterns

Profiler utility

ReadCommitted mode

ReadUncommitted mode

return values

specifying

save points

session data, storing 2nd 3rd

SOAP

sp_executesql stored procedure

specific data providers

SqlClient .NET Data Provider 2nd

Net-Library

relational database engines

TDS (Tabular Data Stream) 2nd 3rd

standardized SQL statements

targeted data providers

text and ntext data types, comparing

timestamp and uniqueidentifier data types, comparing

tinyint and bit data types, comparing

varbinary and image data types, comparing

varchar and nvarchar data types, comparing

SQL Server .NET

CLR (Common Language Runtime) 2nd

NET [edit, period before] language versatility

performance

tool leverage

unified programming models

data

accessing 2nd 3rd 4th 5th

functions

code to create 2nd

programming 2nd

SQL Server Work Bench

VS .NET extensions

SQL Server 2000

stored procedures 2nd

SQL Server databases

inspecting

SQL Server OLE DB provider

SQL Server Work Bench

SQL statements

standardized

in SQL Server

SqlClient

connection strings

specifying 2nd 3rd 4th 5th 6th

SQLClient

connections in pools, monitoring

SqlClient .NET Data provider

SqlClient .NET Data Provider 2nd

Net-Library

relational database engines

TDS (Tabular Data Stream) 2nd 3rd

SqlClient provider

Application Name attribute

AttachDBFileName attribute

attributes

connection pooling 2nd

connections 2nd 3rd 4th 5th 6th

code

debugging

Connect Timeout attribute

Connection Lifetime attribute

connection objects

exceptions

Connection Reset attribute

connections

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

Current Language attribute

data provider types, code 2nd

Data Source attribute

Enlist attribute

InfoMessage events

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

SqlCommand object

methods

SqlConnection class

Close method

Open method

sqlConnection1 object

SqlDataAdapter

connections

opening and closing

Fill method

protected signatures

TitlesDs DataSet

populating

populating, code 2nd

SqlDataAdapter object

properties, setting

sqlDataAdapter1 objects

SqlError object

properties

SqlError object (.NET Data Providers)

Class property

LineNumber property

Message property

Number property

Procedure property

Server property

Source property

State property

SqlFilesCreated event

data factory class

SqlObjectSpace class

SqlServer namespace

referencing

SQLState property

OleDbError object (.NET Data Providers)

SqlTypes namespace

types, mapping

sqlUpdateCommand1 object

SQLXML

data, accessing 2nd 3rd 4th 5th 6th 7th

managed classes

code 2nd

standardized SQL statements

in SQL Server

standards

XML (eXtensible Markup Language)

integrating into ADO.NET 2nd

Stare Page menu commands

My Profile

Start method

threads 2nd

State property

connection classes (.NET Data Providers)

SqlError object (.NET Data Providers)

StateBag class

StateChange event

code 2nd 3rd

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

AddressOf

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

caching

code 2nd 3rd 4th

creating

code 2nd 3rd 4th

creating dynamically

data modification 2nd 3rd

data providers

code to set 2nd

DDL (Data Definition Language)

definition

files

code 2nd

creating 2nd 3rd 4th 5th 6th

creating, code 2nd 3rd 4th

parsing 2nd 3rd 4th 5th 6th

parsing, code 2nd 3rd

FOR XML

modes 2nd

XML output, code

getStatement method

New MergeFailedEventHandler(AddressOf HandleMergeErrors)

Option Strict

strongly typed DataSet classes

pulling

RAISERROR

returning

ROLLBACK TRANSACTION

SELECT

data requests, appropriate

WHERE clause

SET NO_BROWSETABLE ON

SET SHOWPLAN ON

SQL Server

Profiler utility

using ComputeBooks.Data[semicolon here at end]

StatementType property (event arguments) 2nd

states

of rows 2nd 3rd 4th 5th 6th 7th

code

session

ASP.NET State service storage 2nd

Load events, code 2nd

SQL Server storage 2nd 3rd

turning off

Web Forms applications 2nd 3rd 4th 5th 6th

view

Load events, code 2nd

Web Forms applications 2nd 3rd

states of objects

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

Status property (event arguments) 2nd

StDev function

sticky IP

storage

Session object

weaknesses in ASP 2nd

stored procedures

abstractions

Advanced Options button

application-specific

arguments, handling

ComputeBooks

data requests, appropriate

layer design 2nd 3rd 4th 5th 6th 7th 8th

multi-function , code 2nd

naming

with Data Adapter Configuration Wizard

performance optimization

performances

security

sp_executesql

in SQL Server

SQL Server 2000 2nd

Update

code 2nd 3rd

usp GetTitles 2nd

usp GetTitles stored

calling, code 2nd

usp_ActivityReport

usp_DeleteTitle stored

usp_GetTitles

calling, code 2nd

code 2nd

usp_GetTitles stored

calling

usp_GetTitlesLookups stored

usp_GetTitlesReview

TitlesDs DataSet, code to populate 2nd

TitlesDs DataSet, populating

usp_GetTitlesReviews

tables, code to retrieve data 2nd

tables, retrieving data

stores. [See also data stores]2nd [See data stores]

StoresRowChanging method

storing

assemblies

connection strings

code 2nd

time

with ExtendedProperties collection

storing object states

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

strategies

UDA

(Universal Data Access) strategy

stream classes

System.IO namespace

strings

connections

Application Name attribute (SqlClient provider)

AttachDBFileName attribute (SqlClient provider)

attributes, adding

code to accept 2nd

code to store 2nd

Connect Timeout attribute (SqlClient provider)

Current Language attribute (SqlClient provider)

Data Source attribute (SqlClient provider)

Enlist attribute (SqlClient provider)

Initial Catalog attribute (SqlClient provider)

Integrated Security attribute (SqlClient provider)

Network Library attribute (SqlClient provider) 2nd

object construction 2nd 3rd 4th

object construction, code 2nd

Packet Size attribute (SqlClient provider)

parsing

Password attribute (SqlClient provider)

Persist Security Info attribute (SqlClient provider)

specifying 2nd

specifying with OleDb provider 2nd 3rd 4th

specifying with SqlClient 2nd 3rd 4th 5th 6th

storing

storing for ASP.NET applications 2nd 3rd 4th 5th

storing for serviced components 2nd 3rd 4th 5th

Use Procedure For Prepare attribute (SqlClient provider)

User ID attribute (SqlClient provider)

Workstation ID attribute (SqlClient provider)

Literal Values (expression syntax rule)

data, selecting

strong names. [See public keys]

strongly typed

data readers 2nd

strongly typed DataSet classes

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

DataSets, passing 2nd 3rd 4th 5th 6th

disks, persisting to 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)

strongly typed values

of columns, code to retrieve 2nd

strored procedures

abstraction

functions

performance

security

simplification

views

Structured Query Language. [See SQL]

structures

DataSet class

loading at runtime, code 2nd

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

columns 2nd 3rd

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

style sheets

XSLT

(eXtensible Stylesheet Language Transformation)

styles

capitalization

NET [edit, period in front] Framework classes

stylesheets

XSL

code 2nd

output, code 2nd

SUBSTRING function

Sum function

summarized data for applications

Suspend method

threads

switch objects

switches

BooleanSwitch class

DataFactory class

SyncDataSet method

data factory class

Synchronized method

Hashtable class

synonyms

rowversion for timestamp data type

syntax

Aggregate Functions (expression syntax rule)

data, selecting

Column Names (expression syntax rule)

data, selecting

expression syntax rules

data, selecting 2nd 3rd

Functions (expression syntax rule)

data, selecting

Literal Values (expression syntax rule)

data, selecting

object-oriented

data, accessing

OPath

Operators (expression syntax rule)

data, selecting

Parent and Child Relations (expression syntax rule)

data, selecting

Wildcard Characters (expression syntax rule)

data, selecting

system DSN

connections, opening

System.Collections.IList interface

System.Collections.Specialized namespace

System.ComponentModel.IComponent interface

System.ComponentModel.MarshalByValueComponent class

DataSet class

System.Data namespace

DataSet class

System.Data namespaces 2nd 3rd 4th 5th

interface-based programming 2nd

providers (generic versus specific) 2nd 3rd

System.Data.Common

System.Data.OleDb

System.Data.SqlClient

System.Data.SqlTypes

System.Data.Common namespace

System.Data.dll

System.Data.OleDb namespace

System.Data.SqlClient namespace

System.Data.SqlTypes namespace

data types (SQL Server)

System.Diagnostics namespace

classes

Trace class

System.EnterpriseServices namespace

System.IO namespace

stream classes

System.IO namespaces

System.Object

CTS (Common Type System)

managed code

System.Web.Caching.Cache object

System.Windows.Forms namespace

System.Xml classes

stream classes

System.Xml namespace

XmlDataDocument class 2nd

XmlTextReader class

XmlTextWriter class

System.Xml.Serialization.SerializableAttribute attribute

for RuBoard

Категории