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 |