Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)

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]

validation

     CLR UDTs (user-defined types)

     overview of

     sample application

Value property (SqlParameter class)

ValueMember property

varchar data type 2nd

variables, @@IDENTITY 2nd

VIA (Virtual Interface Adaptor)

View menu commands, Server Explorer

views

     creating

     Database Snapshots

     indexes

     managing with Query Designer

     T-SQL views

Virtual Interface Adaptor (VIA)

Visual Basic

Visual Basic .NET

     CLR executables

     Imports statement

     NULL values, testing for

     Using block

Visual Studio

     beta software

     building ConnectionStrings

     class diagrams

     CLR executables

     code generation

     configuring parameters with

    controls [See classes, BindingNavigator; controls, BindingNavigator.]

     CTP (community tech preview) releases

    custom configurations

         creating with Options dialog

         custom project templates

         online or local help

         saving and loading

     database connections

    Database Diagrams

         creating

         definition of

    databases

         creating in code

         creating with Server Explorer

    installing

         image library

         MSDN documentation

         Setup program

     launching

     Object Browser

     overview of

    Query Designer

         criteria pane

         Delete Query type

         derived tables

         diagram pane

         Insert Results Query type

         Insert Values Query type

         JOIN behavior 2nd

         Make Table Query type

         managing database views with

         overview of

         Select Query type

         SQL pane

         Update Query type

     Report Designer

     Report Items toolbox

    Report Viewer

         configuring

         events

         methods

         overview of

         properties

    Server Explorer [See Server Explorer, assemblies, managing.]

     SKUs (stock-keeping units)

     SQLEv (SQL Server Everywhere Edition), support for

     TableAdapter objects

     tables, editing with Server Explorer

     Toolbox [See also controls, BindingNavigator.]

         BindingNavigator class

         BindingSource class

         DataGridView control

         DataSet element

         deprecated data access controls

         finding controls in

         ProgressBar control

         Tool Tray

     versions

Visual Studio Toolbox [See also controls, BindingNavigator.]

     BindingNavigator class

     BindingSource class

         events

         methods

         properties

         typical data binding scenarios

     DataGridView control

     DataSet element

     deprecated data access controls

     finding controls in

     ProgressBar control

     Tool Tray