D



Index


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

D&D (drag-and-drop) data binding 2nd
DAAB (Data Access Application Block)
DACW (DataAdapter Configuration Wizard)
     dependency on CommandBuilder
     installing
DAO (Data Access Objects)
     history of
     performance
Data Access Application Block (DAAB)
data access architectures
     ASP browser-based architectures
     DAAB (Data Access Application Block)
     data access providers
     database-agnostic applications
     deprecated data access controls
     multi-tiered designs
     overview of
     stand-alone (client/server) applications
         advantages/disadvantages
         client/server connection management
         client/server data binding 2nd
         client/server data entry paradigms
         client/server data retrieval
         client/server data validation
         data storage limits
         hybrid architectures
         server-side cursors
         stored procedures
         temporary tables
     XMLWeb Service architectures
data access interfaces
     choosing
     creating
         adding parameters to queries
         configuring TableAdapters
         selecting Query methods
         single-table TableAdapters
         stored procedures
    data access providers
         building ConnectionStrings for
         choosing 2nd
     need for
     SNC (SQL Server Native Client)
    SQLEv (SQL Server Everywhere Edition)
         implementation
         overview of
         programming and maintenance
         security
         sharing and replication
         SQL Server tools
         SQLEngine
         Visual Studio support
Data Access Objects (DAO)
     history of
     performance
data access providers
     building ConnectionStrings for
     choosing 2nd
data binding
     BindingNavigator control
     BindingSource class
         events
         methods
         properties
         typical data binding scenarios
     complex data binding
     control properties
     to custom controls
     DataBindings collection
     DataGridView control
     definition of
     drag-and-drop (D&D) data binding
     example of
     IBindableComponent interface
     overview of
     ProgressBar control
     rules to columns
     simple data binding
    to TableAdapter
         with drag and drop
         without drag and drop
Data Binding with Windows Forms 2.0: Programming Smart Client Data Applications with .NET
Data Connections [See connections, client/server connection management.]
data restoration [See restoring data, backup and deployment issues.]
data retrieval
Data Source Configuration Wizard 2nd 3rd
     consuming and testing Web Services
     single-table TableAdapters, building
    TableAdapters
         adding parameters to queries
         configuring
         selecting Query methods
         stored procedures
Data Source XSD designer 2nd 3rd
Data Sources [See also TableAdapter objects.]
     creating 2nd
         adding parameters to queries
         configuring TableAdapters
         selecting Query methods
         single-table TableAdapters
         stored procedures
     definition of
     importing
     overview of
     SqlClient
     vulnerabilities of
    Web Services
         building
         consuming and testing
         exposing in the UI
data structures, strongly typed [See also TableAdapter objects.]
     building Web Services
     consuming and testing Web Services
     exposing Web Services Data Sources in the UI
     need for
data types
     ANSI 2nd
     barbinary
     bigint
     binary
     bit
     char 2nd
     CLR UDTs (user-defined types)
         AddLoan
         challenges of
         debugging
         instantiating UDT variables
         IsNull property
         methods
         Null property
         NULL values
         Parse function
         performance tuning
         public properties 2nd
         public structure declaration
         referencing
         referencing and updating values
         SELECT queries
         SqlUserDefinedTypeAttribute
         stepping through code
         templates
         ToString function
         typICurrencyV2 UDT
         user-defined serialization
         validating data
         when to use
     cursor
     datetime
     decimal
     doubleprecision
     exact numerics
     float
     image
     imprecise numbers
     int
     money
     nchar
     ntext
     numeric
     nvarchar
     real
     smalldatetime
     smallint
     smallmoney
     sql_variant 2nd
     sysname
     table
     text
     timestamp
     tinyint
     UDTs (user-defined types) 2nd
     Unicode 2nd
     uniqueidentifier
     varchar 2nd
     xml
data validation
DataAccess setting (SqlMethodAttribute property)
DataAdapter Configuration Wizard [See DACW (DataAdapter Configuration Wizard), dependency on CommandBuilder.]
database connections [See connections, client/server connection management.]
Database Diagrams
     creating
     definition of
Database Snapshots
database-agnostic applications
databases [See relational databases, administrative functions, Auto Close option.]
DataBindings collection
DataColumn objects
DataError event
DataGridView controls
DataMember property (BindingSource class)
DataMemberChanged event
DataRow objects 2nd
DataSet controls 2nd [See also populating data structures, DataSet Load method.]
     Load method
     overview of 2nd
     populating
     typed DataSets 2nd
     untyped DataSets
DataSets block (RDLC files)
DataSource property 2nd
DataSourceChanged event
DataSources property (LocalReport class)
DataTable objects
     DataColumns
     DataRows
     joins
     Load method
     overview of 2nd
    populating [See populating data structures, DataSet Load method.]
     populating DataSets with
     properties
DataTableMappingCollection property (SqlDataAdapter class)
DataView class
DataWorks team
dates
     data types
     inqueries
datetime data type
db_datareader role
db_datawriter role
db_owner role
db_public role
DBCC
DBMSs (database management systems)
     client considerations
     maintenance and administration
     multi-user issues
     overview of
    performance
         .NET Framework
         acceptable speed
         ADO
         DAO
         developer performance
         JET
         MDAC stack, sharing
         overview of
         performance metrics
         shareable and reusable components
         shared code
         SQL Server
         team development
     scalability
     server considerations
     SQL Server costs
     SQL Server security
     transactions-per-second limits
DDL triggers
debugging
     CLR executables
     SQL Server connections
     stored procedures
         against local instances
         with breakpoints
         from code
         on remote instances
     UDTs (user-defined types)
decimal data type
DECLARE statement
Default CommandBehavior (ExecuteReader function)
default instances (SQL Server Express Edition)
default parameter values
DEFAULT values (INSERT statement)
DefaultValue property (DataColumn objects)
Delaney, Karen
Delegate objects
Delete Query type (Query Designer)
DELETE statements
DeleteCommand object
DeleteCommand property (SqlDataAdapter class)
DELETED pseudo table
denying permissions
DenyPermissionsOnTo stored procedure
dependencies (CLR executables)
deployment
     CLR executables
         executable dependencies
         functions
         profiling deployment process
     data restoration
     SQL Server Express Edition
deprecated controls
     reinstalling
derived tables
design [See application design, application settings.]
destroying connection pools
Developer Edition (SQL Server)
developers
     keeping skills up to date
     optimizing performance of
diagram pane (Query Designer)
diagrams
     class diagrams
    Database Diagrams
         creating
         definition of
dialogs [See specific dialogs.]
disabling connection pools
DisplayMember property
DisplayName property 2nd
Dispose method 2nd 3rd 4th
Disposed event (connections)
distribution database
DML triggers
documentation
     MSDN documentation
     weaknesses of
DocumentMapCollapsed property (Report Viewer class)
DocumentmapNavigation event
DocumentMapWidt property (Report Viewer class)
domains
doubleprecision data type
DoWork event handler
drag-and-drop (D&D) data binding 2nd
drill-through reports
Drillthrough event handler 2nd
DSCW [See Data Source Configuration Wizard.]
duplicate parameter names
duplicating SqlCommand objects
DVD contents
     aliases, creating
     chapter-specific configuration issues
     example applications, installing
    example databases
         attaching
         installing
dynamic cursors
dynamic ports
dynamic SQL




Hitchhiker's Guide to Visual Studio and SQL Server(c) Best Practice Architectures and Examples
Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)
ISBN: 0321243625
EAN: 2147483647
Year: 2006
Pages: 227

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net