|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Hamilton B., Chipman M., Baron A. — ADO.NET Cookbook |
|
|
|
| Предметный указатель |
nullValue annotation
numbers, formatting
NWLink IPX/SPX network library
Objects
objects, ControlBindingsCollection
objects, DataColumnMapping
objects, DataSet
objects, DataSet, comparing data
objects, DataSet, merging
objects, DataTableMapping
objects, DataView
objects, DataView Manager
objects, RowUpdatedEventsArg
objects, XslTransform
ODBC (Open Database Connectivity)
ODBC .NET data provider, connecting Oracle databases
ODBC drivers, listing
ODBC, connecting
ODBC, connection pooling
ODBC, performance monitoring
OLE DB .NET data provider
OLE DB .NET data provider, connecting Oracle databases
OLE DB .NET data provider, connection pooling
OLE DB Jet provider, accessing text files
OLE DB providers, listing
OLE DB Service Component, displaying data Link Properties dialog box
OLE image header, stripping
OleDbConnection class
Open Database Connectivity [See ODBC]
Optimization
optimization, ASP.NET Cache class
optimization, bulk inserts
optimization, DataReader class
optimization, DataReader class with column ordinals
optimization, DataReader class with typed accessors
optimization, DataSet classes
optimization, paging
Oracle databases
Oracle databases, connecting
Oracle databases, connection pooling
Oracle databases, reading and writing binary data
Oracle databases, sequence values
Oracle packages, retrieving data
OracleType.Cursor data type
Outlook, connecting
overwriting existing data, preventing
paging, optimizing
Parameters
parameters, null values, passing to
parameters, output, returning
parameters, SQL statements, adding
parameters, stored procedures at runtime
parent records, navigating
Passing
passing, credentials
passing, null values to parameters
Passwords
passwords, connecting
passwords, user-level
Performance Monitor, connections
periods
Persist Security Info connection string attribute
pessimistic locking
pessimistic locking, rows
PIA (Primary Interop Assembly) 2nd
PictureBox control
plan, SQL Server queries
pooling connections 2nd
pooling connections, applications
pooling connections, customizing
pooling connections, monitoring
pooling connections, transactions
populating Windows Forms
Primary Interop Assembly [See PIA]
primary keys
primary keys, creating
primary keys, INFORMATION_SCHEMA
primary keys, records, adding
primary keys, updating
PrimaryKey property
programming DataSet classes
Properties
properties, AutoIncrementSeed
properties, AutoIncrementStep
properties, C#/Visual Basic and
properties, Column Mapping
properties, ComboBoxes
properties, complex data binding
properties, ContinueUpdateOnError
properties, DataBindings
properties, DataGridBoolColumn
properties, DataReader.HasRows
properties, DataRowCollection
properties, DataView class
properties, EnforceConstraints 2nd
properties, extended, refreshing DataSet class
properties, HasErrors
properties, MappingName
properties, PrimaryKey
properties, Relations
properties, RowError
properties, SourceVersion
properties, SqlXmlCommand class
properties, Text, binding
Queries
queries, arrays, exporting to
queries, ASP.NET Cache class
queries, asynchronously with Message Queuing
queries, canceling asynchronous
queries, COUNT(*)
queries, DataGrid controls, binding result sets
queries, single values, retrieving
queries, SQL Server
queries, SQL Server, plans
queries, SQL Server, processing
queries, strings, exporting as
queries, XML templates
queries, XPath
queuing
queuing, Message Queuing, updating
queuing, messages
radio buttons, binding
RAISERROR function
Read( ) method
reading XML from SQL Server
Records
records, adding
records, ASP.NET, binding
records, bulk inserts
records, counting 2nd
records, filtering
records, navigating
records, sorting
records, testing
Recordsets
recordsets, converting
recordsets, loading
REF CURSOR
references
references, Excel
references, Oracle
REFERENTIAL_CONSTRAINTS information schema view
refreshing DataSet classes
Relations property
relationships, creating 2nd
remoteable classes, creating
replacing null values
reports, combining data sources
resources, locking modes
Results
| results, DataGrid controls, binding to
results, DataList controls, binding to
retrieving
retrieving, column values
retrieving, constraints
retrieving, deleted rows
retrieving, hierarchical data 2nd
retrieving, lists of SQL Servers
retrieving, metadata
retrieving, schema information
retrieving, single values
returning
returning, output parameters
returning, scalar values
returning, stored procedures
RowError property
Rows
rows, copying
rows, deleting
rows, filtering
rows, iterating
rows, parent/child, adding
rows, pessimistic locking
rows, searching 2nd
rows, sorting 2nd
rows, transaction isolation levels
rows, updating
rows, values, viewing
rows, XPath
RowUpdated event handler
RowUpdatedEventArgs object
RowUpdating event
RowUpdating event handler
rowversion data type
runtime, stored procedure parameters
savepoints
Saving
saving, connection strings
saving, DataSet classes as XML
saving, DataSet structures
saving, XML to fields
schemas
schemas, ADO Recordset, converting
schemas, DataTable
schemas, DataTable, converting DataReader to DataSet
schemas, DataTable, creating tables
schemas, information views
schemas, retrieving information
schemas, XML, controlling null values
schemas, XSD
schemas, XSD, creating
schemas, XSD, creating typed DataSets
Searching
searching, forms
searching, rows
Security
security, connections 2nd
security, credentials
security, error handling
security, passwords, connecting to Access
security, user-level, connecting to Access
SelectNodes( ) method
SelectSingleNode( ) method
sending messages with MSMQ
sequence values
Serialization
Serialize( ) method
server-side controls, binding fields
Servers
servers, .NET remoting, updating
servers, Access, configuring
servers, applications
servers, SQL
servers, SQL, connecting to named instances
servers, SQL, connecting to using integrated security from ASP.NET
servers, SQL, connecting with IP addresses
servers, SQL, integrated security
servers, 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)
SQL Profiler, monitoring connections
SQL Server
SQL Server Distributed Management Objects (SQL-DMO)
SQL Server, bulk inserts
SQL Server, columns
SQL Server, columns, determining length of
SQL Server, columns, retrieving metadata
SQL Server, columns, retrieving values
SQL Server, constraints, retrieving
SQL Server, databases
SQL Server, databases, creating
SQL Server, databases, reading and writing binary data
SQL Server, databases, retrieving schema information
SQL Server, databases, updating
SQL Server, DBMS transactions
SQL Server, debugging
SQL Server, hierarchical data, retrieving
SQL Server, identity values
SQL Server, listing
SQL Server, pessimistic locking
SQL Server, queries, plans
SQL Server, stored procedures
SQL Server, user-defined scalar functions
SQL Server, XML, reading from
SQL, parameters
SQL, queries, processing
SQL, servers
SQL, servers, connecting to named instances
SQL, servers, connecting using integrated security from ASP.NET
SQL, servers, connecting with IP addresses
SQL, servers, connection pooling
SQL, servers, integrated security
SQL, statements, referencing Excel
SQL-DMO (SQL Server Distributed Management Objects)
SqlConnection.InfoMessage event
SQLXML Managed Classes
SqlXmlCommand class
STA (single-threaded apartment) model
statements
statements, COMPUTE BY
statements, CREATE DATABASE
statements, CREATE TABLE
statements, DELETE
statements, EXECUTE
statements, SET FMTONLY ON
statements, SET SHOWPLAN_TEXT
statements, SQL
statements, SQL, adding parameters
statements, SQL, processing
statements, SQL, referencing Excel
Stored procedures
stored procedures, DBMS transactions
stored procedures, debugging
stored procedures, DeleteOrderDetails
stored procedures, DeleteOrders
stored procedures, error handling
stored procedures, executing
stored procedures, GetOrderDetails
stored procedures, GetOrders
stored procedures, Insert OrderDetails
|
|
|
| Реклама |
|
|
|
|
|
|
|
|
О проекте