Sams Teach Yourself ADO.NET in 24 Hours

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] [Z]

code, test harness, creating 2nd 3rd

DataReader object

database fields, retrieving 2nd 3rd 4th

DataSet object contents, viewing 2nd 3rd 4th

Microsoft Access databases, connecting to

Microsoft SQL Servers

connecting

Oracle databases, connecting to 2nd

proxy classes

compiling

SQL databases, code to add records 2nd 3rd 4th

SQL databases, code to delete records 2nd 3rd 4th

SQL databases, code to update records 2nd

strings

(backslash)

Web services

Northwind Database suppliers, returning 2nd

XML

retrieving from SQL Server 2000 2nd 3rd 4th

C# code

DataReader object instances, getting 2nd

dtEmployees table

rows, adding 2nd

caching

data 2nd 3rd

ASP.NET Cache object, code 2nd

calling

stored procedures

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

canceling

transactions

capitalizing T-SQL keywords

cascading style sheets. [See CSS]

case sensitivity

T-SQL

Catch block

error handling

categories

lists

code to generate 2nd 3rd 4th

code to return data 2nd

Categories_Get stored procedure

characters. [See also special characters ]

child columns

foreign keys

Choose Your Data Connection dialog box 2nd 3rd 4th 5th

choosing

data providers 2nd

class browser application 2nd

class hierarchies for data binding

DataGrid controls

list controls

text box controls

class library (Microsoft .NET Framework)

classes

adding to ADO24HRS.css file

code 2nd

creating

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

DataAdapter

Windows Form Designer

DataSet

ListBox control, binding 2nd

Main Header

MainHeader

adding to ADO24HRS.css file

adding to ADO24HRS.css file, code 2nd

namespaces

definition

Product Details custom

code 2nd

proxy

compiling

creating

Suppliers

instances, creating

System.Data.SqlDbType class

System.Web.UI.Control base class

System.Web.UI.WebControls namespace

System.Windows.Forms.Control base class

classes. [See also DataSet class]

client-side Windows Forms controls

System.Windows.Forms.Control base class

clients

optimistic concurrency 2nd

pessimistic concurrency 2nd

Close ( ) method

Connection object 2nd

Close( ) method

(DataReader object)

closing

connections to connection pools

database connections

CLR

(Common Language Runtime)

Try/Catch/Finally statement

ADO.NET error handling

Try/Catch/Finally structure

ADO.NET error handling 2nd 3rd 4th 5th

code 2nd

code

ADO.NET

commands, automatically generated

data providers, choosing 2nd

database connections, managing

DataReader and DataSet objects, comparing 2nd

optimizing

records, retrieving 2nd

SELECT * [edit, enclose SELECT * in double quotes] command

test harness creating 2nd 3rd 4th 5th 6th 7th 8th 9th

ADO24HRS.css file

classes, adding 2nd

applications

finding bottlenecks 2nd 3rd 4th

ASP.NET Cache object 2nd

Auto (XmlReadMode argument)

automatically generated

refreshing 2nd

automatically generated commands

displaying 2nd

Basic.NET

dtEmployees table, adding rows 2nd

Button method

DataReader object instances, getting 2nd

DataReader object, retrieving database fields 2nd 3rd 4th

DataSet object contents, viewing 2nd 3rd 4th

dtEmployees table, adding rows 2nd

Microsoft Access databases, connecting to

Oracle databases, connecting to 2nd

SQL databases, adding records 2nd 3rd 4th

SQL databases, deleting records 2nd 3rd 4th

SQL databases, updating records 2nd

test harness creating 2nd 3rd

XML, retrieving from SQL Server 2000 2nd 3rd 4th

category lists, code to return data 2nd

category lists, generating 2nd 3rd 4th

Code Editor tab (Windows Form Designer) 2nd 3rd 4th

columns

specifying in SQL statements 2nd

updating with UPDATE statement 2nd

Command object

intantiating

Connection object

intantiating

Connection object instances, creating

constructors

overloading 2nd

Customer table

DataSet XML, generating typed DataSet class 2nd

Customers Get stored procedure 2nd 3rd

Customers table

timestamp column 2nd

Customers.VB

CustOrdDS.xsd XML Schema file 2nd 3rd

data values

original and current, comparing 2nd 3rd 4th

DataAdapter object

instantiating

database order lists 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th

database queries 2nd 3rd

database values

retrieving with ExecuteScalar( ) method 2nd 3rd

DataGrid control example 2nd 3rd

DataGrid list control 2nd 3rd

paging 2nd 3rd 4th

stylesheets 2nd

DataList list control, formatting 2nd 3rd 4th 5th 6th

DataReader object, data binding to Web controls 2nd 3rd

DataSets

contents, viewing 2nd

populating 2nd 3rd 4th

DataSets, creating from XML files 2nd

datasets, updating 2nd

datasets, updating with SqlCommandBuilder 2nd

DataTables objects

relationships, adding 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

DiffGram (XmlReadMode argument)

DiffGram (XmlWriteMode object)

dtEmployees table

rows, adding with Basic.NET 2nd

rows, adding with C# 2nd

Employee table

rows, deleting 2nd 3rd 4th

employees • names

changing with UPDATE statement 2nd

Fragment (XmlReadMode argument)

GetAllSuppliers( ) Web Service

consuming 2nd

IgnoreSchema (XmlReadMode argument)

IgnoreSchema (XmlWriteMode object)

InferSchema (XmlReadMode argument)

Microsoft SQL Servers

connecting to with C#

connecting to with Visual Basic .NET

Northwind Employees table, deleting records 2nd 3rd 4th 5th

Northwind.DataAccess ActiveX DLL

legacy usage 2nd 3rd 4th

On Error construct 2nd

Product Add stored procedure 2nd 3rd

product data

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

Product Update stored procedure 2nd

ProductDetails custom class 2nd

productdetails.aspx, downloading

ProductEditor.aspx Web Form 2nd 3rd 4th 5th 6th

ProductEditor.aspx Web form 2nd 3rd 4th 5th 6th 7th

Products.aspx Web form

Create New Product button 2nd

DataList, adding links

ProductsDB assembly

product listings 2nd 3rd 4th

ReadSchema (XmlReadMode argument)

Repeater list control

templates 2nd 3rd

Required Field control 2nd 3rd

RowError condition

adding to Customers DataSet 2nd

sizes of

constructors, overloading 2nd

SQL

displaying in CommandBuilder object 2nd 3rd

SQL databases, deleting records 2nd 3rd

stored procedure with CustomerID parameter 2nd

stored procedures

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

stored procedures example 2nd

stored procedures, executing 2nd 3rd

testing in Web forms 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

transactions

rolling back 2nd 3rd 4th 5th 6th

rolling back to saved points 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

starting 2nd

Try/Catch/Finally structure 2nd

two- tier development (data sources)

typed DataSet class

populating 2nd

UpdateProducts middle-tier method 2nd 3rd

typed DataSets class 2nd

VB .NET

DataReader object instances, getting 2nd

DataReader object, retrieving database fields 2nd 3rd 4th

SQL databases, adding records 2nd 3rd 4th 5th 6th

SQL databases, deleting records 2nd 3rd 4th 5th

SQL databases, updating records 2nd 3rd 4th

VB.NET

DataSet object contents, viewing 2nd 3rd

test harness creating 2nd 3rd

Web forms 2nd 3rd

Visual Basic

connection pooling 2nd 3rd 4th

connection strings, defining 2nd

Visual Basic .NET

DataSet, serializing to XML files 2nd

Microsoft Access databases, connecting to 2nd

Oracle databases, connecting to

Visual Basic 6.0 legacy

Northwind database, data access component 2nd 3rd 4th 5th 6th 7th 8th

Web services

Northwind Database suppliers, returning in C# 2nd

Northwind Database suppliers, returning in Visual Basic 2nd

Windows Form Designer, VS .NET

automatically generated commands 2nd 3rd 4th 5th

WriteSchema (XmlWriteMode object)

XML documents

XML Schema file

Customers table typed DataSet 2nd 3rd 4th 5th

Orders table typed DataSet 2nd 3rd

XML Schema file definition 2nd

Code Editor tab (Windows Form Designer)

generated code 2nd 3rd 4th

code. [See also syntax]

codes

symbolx

syntax

coding optimistic concurrency 2nd

collections

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

DataTables objects, relationships 2nd 3rd 4th

Parameters

columms

join operations

columns

appearances

defining

BoundColumn control

child

DataColumn object

DataColumns object

adding to DataTable object 2nd 3rd 4th

DataFormatString property

foreign key

names, sharing

HyperLinkColumn

LastName

names

sharing

special character

parent

primary key

names, sharing

specifying

code 2nd

timestamp

ANSI-SQL 92

Customers table, code 2nd

optimistic concurrency 2nd 3rd 4th

updating with UPDATE statement

code 2nd

columns [edit, HTML brackets] section

COM interoperability

ADO recordsets, accessing from ADO.NET 2nd

Command object

Connection object, using together 2nd 3rd

creating

data, retrieving 2nd 3rd 4th 5th

Connection objects 2nd 3rd

constructor overload 2nd

ExecuteNonQuery( ) method 2nd

data, deleting from databases 2nd 3rd 4th 5th 6th 7th 8th

data, inserting into databases 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

data, modifying in databases 2nd 3rd 4th 5th 6th 7th

intantiating

code

CommandBuilder object

automatically generated commands 2nd 3rd

code to display 2nd

SELECT statement, changes in 2nd 3rd 4th

SQL code, displaying 2nd 3rd

Windows Form Designer, VS .NET code 2nd 3rd 4th 5th

SelectCommand

commands

automatically generated 2nd 3rd 4th 5th

code to display 2nd

CommandBuilder object 2nd 3rd

CommandBuilder object, changes in SELECT statement 2nd 3rd 4th

CommandBuilder object, displaying SQL code 2nd 3rd

CommandBuilder object, VS .NET code 2nd 3rd 4th 5th

criteria 2nd 3rd

optimistic concurrency model

Data menu

Generate Dataset 2nd

DELETE 2nd

File menu

New 2nd 3rd

INSERT 2nd

Project menu

Add Existing Item

Query menu

Display Estimated Execution Plan command

Index Tuning Wizard

Refresh

Schema menu

Generate DataSet

SELECT * [edit, enclose SELECT * in double quotes]

SelectCommand

CommandBuilder object

SqlCommandBuilder

datasets, code to update 2nd

UPDATE

CommandType property

stored procedures, executing 2nd 3rd 4th

Commit( ) method

transactions 2nd

committing

transactions

Common Language Runtime. [See CLR]

comparing

ADO and ADO.NET data types 2nd 3rd 4th 5th

ADO.NET and ADO 2nd 3rd

data values, original and current

code 2nd 3rd 4th

DataReader and DataAdapter objects 2nd 3rd 4th

DataReader and DataSet objects 2nd

DataSet values against databases for optimistic concurrency 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

optimistic and pessimistic concurrency 2nd 3rd 4th 5th 6th

compiled assemblies

bin folders

compiling

ADO24HRS namespace

for assemblies 2nd 3rd

proxy classes

Visual Basic 6.0 components

complex binding

data to list controls

complex data binding in Windows Forms

data adapters

adding 2nd 3rd 4th

data connections

adding 2nd 3rd 4th

DataGrid control

adding 2nd 3rd 4th 5th

DataSets

creating 2nd 3rd 4th 5th

populating, code 2nd

ListBox control

adding 2nd 3rd 4th 5th

projects

creating in VS .NET

testing 2nd

complex DataGrid binding

Get Customer Forms application 2nd

components

Visual Basic 6.0

compiling

concurrency

definition

models

isolation levels

optimistic

and pessmistic, comparing 2nd 3rd 4th 5th 6th

clients 2nd

coding 2nd

DataSet values, comparing against databases 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

DiffGram XML format 2nd 3rd

multiusers 2nd

SqlRowUpdatedEventHandler handler

timestamp columns 2nd 3rd 4th

TSEQUAL update syntax

XML (eXtensible Markup Language) 2nd 3rd

ZERO records

pessimistic

clients 2nd

multiusers 2nd

concurrency violations (optimistic)

DiffGram

configuring

data

adapters

connections

Web sites 2nd

connecting to

Microsoft SQL Servers with C# code

Microsoft SQL Servers with Visual Basic .NET code

connecting to data sources 2nd 3rd

Connection object 2nd

Close ( ) method 2nd

connection strings 2nd 3rd

methods

OLE DB data providers

Open ( ) method

properties

user information, specifying 2nd

connection pooling 2nd 3rd

ODBC (Open Database Connectivity) 2nd 3rd

OLE DB data sources 2nd

Microsoft Access databases

Microsoft Access databases in C#

Microsoft Access databases in Visual Basic .NET 2nd

Oracle databases in C# 2nd

Oracle databases in Visual Basic .NET

SQL servers 2nd

connection counter levels

connection pooling 2nd

Connection Lifetime keyword

Connection object

Command object, using together 2nd 3rd

data sources, connecting to 2nd

Close ( ) method 2nd

connection strings 2nd 3rd

methods

OLE DB data providers

Open ( ) method

properties

user information, specifying 2nd

instances, creating

intantiating

code

transactions

BeginTransaction( ) method 2nd 3rd 4th

canceling

Commit( ) method 2nd

GetAndBindData( ) method 2nd

InvalidOperationException

Open( ) method

Rollback( ) method 2nd 3rd 4th 5th 6th 7th 8th

rolling back to saved points, code 2nd 3rd 4th 5th 6th 7th

Save( ) method 2nd 3rd 4th 5th 6th 7th 8th 9th

SqlTransaction object

Throw( ) method

Transaction property

connection pooling

ADO.NET data provider

behavior

in Performance Monitor

counters

adding to Performance Monitor console

data sources 2nd 3rd

database connections, reusing

NET [edit, period before] data provider

NET [edit, period before] data providers

NET [edit, period before] Framework

OLE DB .NET data provider

connection counter levels 2nd

MSSQL$NetSDK[ colon ]General Statistics performance objects

NET [edit, period before] CLR Data performance objects 2nd

Performance Monitor, connection pooling behavior

Visual Basic code 2nd 3rd 4th

Visual Basic code, executing at DOS prompt 2nd

connection pools

Connection Lifetime keyword

Connection Reset keyword

connection-string keywords 2nd

connections

closing

Enlist keyword

entries

creating 2nd

Max Pool Size keyword

Min Pool Size keyword

OLE DB .NET data provider 2nd

Performance Monitor 2nd

Profiler

security 2nd

Pooling keyword

pools

sizes

Connection Reset keyword

connection strings 2nd 3rd

defining

code 2nd

global constants

Initial Catalog property

OLE DB

Web site

OLE DB data providers

options

Password property

properties 2nd

Server property

User ID property

user information, specifying 2nd

connection-string keywords 2nd

connections

data

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

adding in VS .NET 2nd 3rd 4th

configuring

errors

ODBC (Open Database Connectivity

to Microsoft Access databases

of databases

managing

to connection pools

closing

to databases

closing

reusing

ConnectionString property

Connecton object

ConnectionString property

Database property

OleDbConnection object

Provider property

SqlConnection object

consoles

IIS administrative console

virtual directories, managing

Web sites, managing

constants

global

connection strings

constraints

DataSet object 2nd

Northwind database

Employees table

constructors

overloading 2nd

code 2nd

constructs

On Error

ADO.NET error handling 2nd 3rd 4th

code 2nd

consuming

DataSets

returned by GetAllSuppliers( ) Web service

DataSets from Web services 2nd 3rd 4th 5th 6th

GetAllSuppliers( ) Web Service

code 2nd

contact names

valid

retrieving from Customers table

contents

DataSets

viewing 2nd 3rd

controls

ASP.NET servers

System.Web.UI.Control base class

BoundColumn

DataGrid

adding 2nd 3rd 4th 5th

bound to XML data

class hierarchies for data binding

code example 2nd 3rd

column appearance, defining

database order list, code 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th

definition

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

properties 2nd

DataGrid Web

DataList

list controls 2nd 3rd 4th 5th 6th

label Web

list

class hierarchies for data binding

definition

properties 2nd

System.Web.UI.WebControls namespace

ListBox

adding 2nd 3rd 4th 5th

binding to DataSet classes 2nd

property specifications

ListBox Web

Northwind Employees table, code to delete records 2nd 3rd 4th 5th

Repeater

category lists, code to generate 2nd 3rd 4th

category lists, code to return data 2nd

list controls 2nd 3rd 4th 5th 6th 7th

Required Field

code 2nd 3rd

System.Web.UI.Control base class

System.Windows.Forms.Control base class

text box

class hierarchies for data binding

definition

typed DataSet class

adding to display data 2nd

Windows Forms (client-side)System.Windows.Forms.Control base class

controls. [See also Web controls]2nd [See also Web controls]3rd [See also Web controls]4th [See also list controls]5th [See also Web controls]6th [See also list controls]7th [See also list controls]

Cos( expr ) function

Count( ) SQL function

counters

adding to Performance Monitor console

connection counter levels

connection pooling 2nd

Create Database Diagram Wizard

Create New Product button

code 2nd

Create Relationship screen

creating

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

buttons 2nd

classes

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

Command objects

Connection object instances

connection pool entries 2nd

database tables

DataSet object schemas 2nd 3rd 4th 5th

DataSets 2nd 3rd 4th 5th

from XML files 2nd 3rd 4th 5th 6th

DSN (Data Source Name )

for ODBC (Open Database Connectivity) data source 2nd 3rd 4th

labels 2nd

projects

in VS .NET 2nd 3rd 4th

proxy classes

stored procedures

with Enterprise Manager

Suppliers class instancees

table relationships 2nd 3rd 4th 5th

test harness

for ADO.NET code 2nd 3rd 4th 5th 6th 7th 8th 9th

text boxes 2nd

Web forms

Web services

Web sites 2nd 3rd

criteria

automatically generated commands 2nd 3rd

cross-platform style sheets

reference guides

Web site

cs [edit, period before] file

CSS

(cascading style sheets)

ADO24HRS.css file

classes;code to add 2nd

contents;modifying

ASP.NET list controls, formatting 2nd 3rd 4th 5th 6th 7th 8th

cross-platform style sheets

reference guides, Web site

css [edit, period before] file extension

DataGrid list control

code 2nd 3rd

stylesheets

stylesheets, code 2nd

MainHeader class

adding to ADO24HRS.css file

stylesheets

Web forms

css [edit, period before] file extension

CurrencyManager object

data, binding to list controls 2nd

custom classes

ProductDetails

code 2nd

custom objects

single rows of data, replacing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

Customer Inquiry form

execution (successful) 2nd

Refresh Failed exception

SQL error message

validate exceptions

validation error-handling

Customer table

DataSet XML

code to generate typed DataSet class 2nd

Customer_GetByID stored procedure

CustomerID parameter

stored procedures

code 2nd

customers

Get Customer Forms application

complex DataGrid binding

simple binding

customers and orders relationship

XML Schema editor

Customers DataSet

RowError condition

code to add 2nd

Customers Get stored procedure

code 2nd 3rd

Customers table

and Orders table, relationships

timestamp column

code 2nd

typed Dataset

XML Schema file, code 2nd 3rd 4th 5th

typed DataSet class

valid contact names, retrieving

Customers.VB source code

Customers.xsd file

Visual Studio .NET Component Designer

CustomersOrders relation

Edit Relation dialog box

CustOrdDS.xsd schema file 2nd

CustOrdDS.xsd XML Schema file 2nd 3rd

for RuBoard

Категории