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