[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
savepoints
saving
connection strings
DataSet classes as XML
DataSet structures
XML to fields
schemas
ADO Recordset, converting
DataTable
converting DataReader to DataSet
creating tables
information views
retrieving information
XML, controlling null values
XSD
creating
creating typed DataSets
searching
forms
rows
security
connections
2nd
credentials
error handling
passwords, connecting to Access
user-level, connecting to Access
SelectNodes( ) method
SelectSingleNode( ) method
sending messages with MSMQ
sequence values
serialization
Serialize( ) method
server-side controls, binding fields
servers
Access, configuring
applications
.NET remoting, updating
SQL
connecting to named instances
connecting to using integrated security from ASP.NET
connecting with IP addresses
integrated security
web services, updating
services, web
[See web services]
Set Database command
SET FMTONLY ON statement
SET SHOWPLAN_TEXT statement
Shape language
single values, retrieving
single-threaded apartment (STA) model
singles sign-on
sorting
SourceVersion property
sp_helpconstraint system stored procedure
SQL (Structured Query Language)
parameters
queries, processing
servers
connecting to named instances
connecting using integrated security from ASP.NET
connecting with IP addresses
connection pooling
integrated security
statements, referencing Excel
SQL Profiler, monitoring connections
SQL Server
bulk inserts
columns
determining length of
retrieving metadata
retrieving values
constraints, retrieving
databases
creating
reading and writing binary data
retrieving schema information
updating
DBMS transactions
debugging
hierarchical data, retrieving
identity values
listing
pessimistic locking
queries, plans
stored procedures
user-defined scalar functions
XML, reading from
SQL Server Distributed Management Objects (SQL-DMO)
SQL-DMO (SQL Server Distributed Management Objects)
SqlConnection.InfoMessage event
SQLXML Managed Classes
SqlXmlCommand class
STA (single-threaded apartment) model
statements
COMPUTE BY
CREATE DATABASE
CREATE TABLE
DELETE
EXECUTE
SET FMTONLY ON
SET SHOWPLAN_TEXT
SQL
adding parameters
processing
referencing Excel
stored procedures
DBMS transactions
debugging
DeleteOrderDetails
DeleteOrders
error handling
executing
GetOrderDetails
GetOrders
Insert OrderDetails
many-to-many relationships
pessimistic locking
referential integrity, avoiding
runtime parameters
sequence values
single values, retrieving
sp_helpcontsraint
SQL Server
UpdateOrderDetails
UpdateOrders
values, returning
storing connection strings
strings
connection
storing
queries, exporting as
Structured Query Language
[See SQL]
structures, C#/Visual Basic and
support, ADO.NET
symmetric key algorithms
synchronization
DataGrid controls
DataSet classes with XML
identity values
system stored procedure sp_helplstored procedures
System.Data.Constraint class
System.DbNull.Value static field
System.MarshalByRefObject
System.Runtime.Serialization.Formatter class
System.Text.Encoding class
System.Web.Caching.Cache class
|