O



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]

Object Browser
     class diagrams, creating
Object Explorer
     CLR executables, viewing
     compared to Visual Studio Server Explorer
objects [See also classes, BindingNavigator; controls, BindingNavigator.]
     addressing in SQL Server
     AsyncCallback
     DataColumn
     DataRow 2nd
    DataSet
         Load method
         overview of 2nd
         populating
         strongly typed DataSets
    DataTable
         DataColumns
         DataRows
         joins
         Load method
         overview of 2nd
         populating DataSets with
         populating from SqlDataReader
     Delegate
     DeleteCommand
     disposing of
     duplicating
     InsertCommand
    instantiating
         constructors
         overview of
         scope
         Using block
     ownership
    populating [See populating data structures, DataSet Load method.]
     SelectCommand
    SqlCommand [See SqlCommand objects.]
     SqlConnection
    SqlDataReader
         best practice designs
         fetching all columns
         fetching individual rows
         fetching metadata
         Get functions
         GetSchemaTable method
         HasRows function
         overview of
         testing stream for data 2nd
     TableAdapter 2nd 3rd
         adding parameters to queries
         binding to
         configuring
         defined
         generated parameters, managing
         intertable relationships, managing in Data Source designer
         limitations of
         overview of 2nd
         parameters, configuring with Visual Studio
         selecting Query methods
         single-table TableAdapters
         stored procedures 2nd 3rd
         updating tables with
     UpdateCommand
     WaitHandle 2nd
ODBC (Open Database Connectivity)
OLEDB
OnNullCall setting (SqlMethodAttribute property)
Open Database Connectivity (ODBC)
Open method
Open Table Definition dialog
opening connections
     automatically
     SQL Server connections 2nd
operations, canceling
operators
     BETWEEN
     FETCH
     IN
     JOIN
     LIKE
     TRUNCATE TABLE
     Using
optimizing performance [See performance, CLR executable performance, evaluating.]
Options command (Tools menu)
Options dialog (Visual Studio)
ORDER BY clause
order of columns, changing
OriginalParametersToDrillthrough property (LocalReport class)
outer joins
OUTPUT parameters
overflow (connection pools)
OverwriteChanges setting (ConflictOption property)
ownership 2nd
Ozzie, Ray




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