C_Index

for RuBoard

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

C#
       code, test harness, creating   2nd   3rd  
       DataReader object
               database fields, retrieving   2nd   3rd   4th  
       DataSet object contents, viewing   2nd   3rd   4th  
       Microsoft Access databases, connecting to  
       Microsoft SQL Servers
               connecting  
       Oracle databases, connecting to   2nd  
       proxy classes
               compiling  
       SQL databases, code to add records   2nd   3rd   4th  
       SQL databases, code to delete records   2nd   3rd   4th  
       SQL databases, code to update records   2nd  
       strings
               (backslash)  
       Web services
               Northwind Database suppliers, returning   2nd  
       XML
               retrieving from SQL Server 2000   2nd   3rd   4th  
C# code
       DataReader object instances, getting   2nd  
       dtEmployees table
               rows, adding   2nd  
caching
       data   2nd   3rd  
               ASP.NET Cache object, code   2nd  
calling
       stored procedures
               code   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
canceling
       transactions  
capitalizing T-SQL keywords  
cascading style sheets.   [See CSS]
case sensitivity
       T-SQL  
Catch block
       error handling  
categories
       lists
               code to generate   2nd   3rd   4th  
               code to return data   2nd  
Categories_Get stored procedure  
characters.   [See also special characters ]
child columns
       foreign keys  
Choose Your Data Connection dialog box   2nd   3rd   4th   5th  
choosing
       data providers   2nd  
class browser application   2nd  
class hierarchies for data binding
       DataGrid controls  
       list controls  
       text box controls  
class library (Microsoft .NET Framework)  
classes
       adding to ADO24HRS.css file
               code   2nd  
       creating
               for assemblies   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       DataAdapter
               Windows Form Designer  
       DataSet
               ListBox control, binding   2nd  
       Main Header  
       MainHeader
               adding to ADO24HRS.css file  
               adding to ADO24HRS.css file, code   2nd  
       namespaces  
               definition  
       Product Details custom
               code   2nd  
       proxy
               compiling  
               creating  
       Suppliers
               instances, creating  
       System.Data.SqlDbType class  
       System.Web.UI.Control base class  
       System.Web.UI.WebControls namespace  
       System.Windows.Forms.Control base class  
classes.   [See also DataSet class]
client-side Windows Forms controls
       System.Windows.Forms.Control base class  
clients
       optimistic concurrency   2nd  
       pessimistic concurrency   2nd  
Close ( ) method
       Connection object   2nd  
Close( ) method
       (DataReader object)  
closing
       connections to connection pools  
       database connections  
CLR
       (Common Language Runtime)  
       Try/Catch/Finally statement
               ADO.NET error handling  
       Try/Catch/Finally structure
               ADO.NET error handling   2nd   3rd   4th   5th  
               code   2nd  
code
       ADO.NET
               commands, automatically generated  
               data providers, choosing   2nd  
               database connections, managing  
               DataReader and DataSet objects, comparing   2nd  
               optimizing  
               records, retrieving   2nd  
               SELECT * [edit, enclose SELECT * in double quotes] command  
               test harness creating   2nd   3rd   4th   5th   6th   7th   8th   9th  
       ADO24HRS.css file
               classes, adding   2nd  
       applications
               finding bottlenecks   2nd   3rd   4th  
       ASP.NET Cache object   2nd  
       Auto (XmlReadMode argument)  
       automatically generated
               refreshing   2nd  
       automatically generated commands
               displaying   2nd  
       Basic.NET
               dtEmployees table, adding rows   2nd  
       Button method  
       C#
               DataReader object instances, getting   2nd  
               DataReader object, retrieving database fields   2nd   3rd   4th  
               DataSet object contents, viewing   2nd   3rd   4th  
               dtEmployees table, adding rows   2nd  
               Microsoft Access databases, connecting to  
               Oracle databases, connecting to   2nd  
               SQL databases, adding records   2nd   3rd   4th  
               SQL databases, deleting records   2nd   3rd   4th  
               SQL databases, updating records   2nd  
               test harness creating   2nd   3rd  
               XML, retrieving from SQL Server 2000   2nd   3rd   4th  
       category lists, code to return data   2nd  
       category lists, generating   2nd   3rd   4th  
       Code Editor tab (Windows Form Designer)   2nd   3rd   4th  
       columns
               specifying in SQL statements   2nd  
               updating with UPDATE statement   2nd  
       Command object
               intantiating  
       Connection object
               intantiating  
       Connection object instances, creating  
       constructors
               overloading   2nd  
       Customer table
               DataSet XML, generating typed DataSet class   2nd  
       Customers Get stored procedure   2nd   3rd  
       Customers table
               timestamp column   2nd  
       Customers.VB  
       CustOrdDS.xsd XML Schema file   2nd   3rd  
       data values
               original and current, comparing   2nd   3rd   4th  
       DataAdapter object
               instantiating  
       database order lists   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
       database queries   2nd   3rd  
       database values
               retrieving with ExecuteScalar( ) method   2nd   3rd  
       DataGrid control example   2nd   3rd  
       DataGrid list control   2nd   3rd  
               paging   2nd   3rd   4th  
               stylesheets   2nd  
       DataList list control, formatting   2nd   3rd   4th   5th   6th  
       DataReader object, data binding to Web controls   2nd   3rd  
       DataSets
               contents, viewing   2nd  
               populating   2nd   3rd   4th  
       DataSets, creating from XML files   2nd  
       datasets, updating   2nd  
       datasets, updating with SqlCommandBuilder   2nd  
       DataTables objects
               relationships, adding   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       DiffGram (XmlReadMode argument)  
       DiffGram (XmlWriteMode object)  
       dtEmployees table
               rows, adding with Basic.NET   2nd  
               rows, adding with C#   2nd  
       Employee table
               rows, deleting   2nd   3rd   4th  
        employees • names
               changing with UPDATE statement   2nd  
       Fragment (XmlReadMode argument)  
       GetAllSuppliers( ) Web Service
               consuming   2nd  
       IgnoreSchema (XmlReadMode argument)  
       IgnoreSchema (XmlWriteMode object)  
       InferSchema (XmlReadMode argument)  
       Microsoft SQL Servers
               connecting to with C#  
               connecting to with Visual Basic .NET  
       Northwind Employees table, deleting records   2nd   3rd   4th   5th  
       Northwind.DataAccess ActiveX DLL
               legacy usage   2nd   3rd   4th  
       On Error construct   2nd  
       Product Add stored procedure   2nd   3rd  
       product data
               retrieving through assemblies   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
       Product Update stored procedure   2nd  
       ProductDetails custom class   2nd  
       productdetails.aspx, downloading  
       ProductEditor.aspx Web Form   2nd   3rd   4th   5th   6th  
       ProductEditor.aspx Web form   2nd   3rd   4th   5th   6th   7th  
       Products.aspx Web form
               Create New Product button   2nd  
               DataList, adding links  
       ProductsDB assembly
               product listings   2nd   3rd   4th  
       ReadSchema (XmlReadMode argument)  
       Repeater list control
               templates   2nd   3rd  
       Required Field control   2nd   3rd  
       RowError condition
               adding to Customers DataSet   2nd  
       sizes of
               constructors, overloading   2nd  
       SQL
               displaying in CommandBuilder object   2nd   3rd  
       SQL databases, deleting records   2nd   3rd  
       stored procedure with CustomerID parameter   2nd  
       stored procedures
               calling   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       stored procedures example   2nd  
       stored procedures, executing   2nd   3rd  
       testing in Web forms   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
       transactions
               rolling back   2nd   3rd   4th   5th   6th  
               rolling back to saved points   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
               starting   2nd  
       Try/Catch/Finally structure   2nd  
       two- tier development (data sources)  
       typed DataSet class
               populating   2nd  
       UpdateProducts middle-tier method   2nd   3rd  
       VB
               typed DataSets class   2nd  
       VB .NET
               DataReader object instances, getting   2nd  
               DataReader object, retrieving database fields   2nd   3rd   4th  
               SQL databases, adding records   2nd   3rd   4th   5th   6th  
               SQL databases, deleting records   2nd   3rd   4th   5th  
               SQL databases, updating records   2nd   3rd   4th  
       VB.NET
               DataSet object contents, viewing   2nd   3rd  
               test harness creating   2nd   3rd  
               Web forms   2nd   3rd  
       Visual Basic
               connection pooling   2nd   3rd   4th  
               connection strings, defining   2nd  
       Visual Basic .NET
               DataSet, serializing to XML files   2nd  
               Microsoft Access databases, connecting to   2nd  
               Oracle databases, connecting to  
       Visual Basic 6.0 legacy
               Northwind database, data access component   2nd   3rd   4th   5th   6th   7th   8th  
       Web services
               Northwind Database suppliers, returning in C#   2nd  
               Northwind Database suppliers, returning in Visual Basic   2nd  
       Windows Form Designer, VS .NET
               automatically generated commands   2nd   3rd   4th   5th  
       WriteSchema (XmlWriteMode object)  
       XML documents  
       XML Schema file
               Customers table typed DataSet   2nd   3rd   4th   5th  
               Orders table typed DataSet   2nd   3rd  
       XML Schema file definition   2nd  
Code Editor tab (Windows Form Designer)  
       generated code   2nd   3rd   4th  
code.   [See also syntax]
codes
       symbolx  
       syntax  
coding optimistic concurrency   2nd  
collections
       DataRelationCollection   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
               DataTables objects, relationships   2nd   3rd   4th  
       Parameters  
columms
       join operations  
columns
        appearances
               defining  
       BoundColumn control  
       child  
       DataColumn object  
       DataColumns object
               adding to DataTable object   2nd   3rd   4th  
       DataFormatString property  
       foreign key
               names, sharing  
       HyperLinkColumn  
       LastName  
       names
               sharing  
               special character  
       parent  
       primary key
               names, sharing  
       specifying
               code   2nd  
       timestamp
               ANSI-SQL 92  
               Customers table, code   2nd  
               optimistic concurrency   2nd   3rd   4th  
       updating with UPDATE statement
               code   2nd  
columns [edit, HTML brackets] section  
COM interoperability
       ADO recordsets, accessing from ADO.NET   2nd  
Command object  
       Connection object, using together   2nd   3rd  
       creating  
       data, retrieving   2nd   3rd   4th   5th  
               Connection objects   2nd   3rd  
               constructor overload   2nd  
       ExecuteNonQuery( ) method   2nd  
               data, deleting from databases   2nd   3rd   4th   5th   6th   7th   8th  
               data, inserting into databases   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
               data, modifying in databases   2nd   3rd   4th   5th   6th   7th  
       intantiating
               code  
CommandBuilder object  
       automatically generated commands   2nd   3rd  
               code to display   2nd  
               SELECT statement, changes in   2nd   3rd   4th  
               SQL code, displaying   2nd   3rd  
               Windows Form Designer, VS .NET code   2nd   3rd   4th   5th  
       SelectCommand  
commands
       automatically generated   2nd   3rd   4th   5th  
               code to display   2nd  
               CommandBuilder object   2nd   3rd  
               CommandBuilder object, changes in SELECT statement   2nd   3rd   4th  
               CommandBuilder object, displaying SQL code   2nd   3rd  
               CommandBuilder object, VS .NET code   2nd   3rd   4th   5th  
               criteria   2nd   3rd  
               optimistic concurrency model  
       Data menu
               Generate Dataset   2nd  
       DELETE   2nd  
       File menu
               New   2nd   3rd  
       INSERT   2nd  
       Project menu
               Add Existing Item  
       Query menu
               Display Estimated Execution Plan command  
               Index Tuning Wizard  
       Refresh  
       Schema menu
               Generate DataSet  
       SELECT * [edit, enclose SELECT * in double quotes]  
       SelectCommand
               CommandBuilder object  
       SqlCommandBuilder  
               datasets, code to update   2nd  
       UPDATE  
CommandType property
       stored procedures, executing   2nd   3rd   4th  
Commit( ) method
       transactions   2nd  
committing
       transactions  
Common Language Runtime.   [See CLR]
comparing
       ADO and ADO.NET data types   2nd   3rd   4th   5th  
       ADO.NET and ADO   2nd   3rd  
       data values, original and current
               code   2nd   3rd   4th  
       DataReader and DataAdapter objects   2nd   3rd   4th  
       DataReader and DataSet objects   2nd  
       DataSet values against databases for optimistic concurrency   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       optimistic and pessimistic concurrency   2nd   3rd   4th   5th   6th  
compiled assemblies
       bin folders  
compiling
       ADO24HRS namespace
               for assemblies   2nd   3rd  
       proxy classes  
       Visual Basic 6.0 components  
complex binding
       data to list controls  
complex data binding in Windows Forms  
       data adapters
               adding   2nd   3rd   4th  
       data connections
               adding   2nd   3rd   4th  
       DataGrid control
               adding   2nd   3rd   4th   5th  
       DataSets
               creating   2nd   3rd   4th   5th  
               populating, code   2nd  
       ListBox control
               adding   2nd   3rd   4th   5th  
       projects
               creating in VS .NET  
       testing   2nd  
complex DataGrid binding
       Get Customer Forms application   2nd  
components
       Visual Basic 6.0
               compiling  
concurrency
       definition  
       models
               isolation levels  
       optimistic  
               and pessmistic, comparing   2nd   3rd   4th   5th   6th  
               clients   2nd  
               coding   2nd  
               DataSet values, comparing against databases   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
               DiffGram XML format   2nd   3rd  
               multiusers   2nd  
               SqlRowUpdatedEventHandler handler  
               timestamp columns   2nd   3rd   4th  
               TSEQUAL update syntax  
               XML (eXtensible Markup Language)   2nd   3rd  
               ZERO records  
       pessimistic
               clients   2nd  
               multiusers   2nd  
concurrency violations (optimistic)
       DiffGram  
configuring
       data
               adapters  
               connections  
       Web sites   2nd  
connecting to
       Microsoft SQL Servers with C# code  
       Microsoft SQL Servers with Visual Basic .NET code  
connecting to data sources   2nd   3rd  
       Connection object   2nd  
               Close ( ) method   2nd  
               connection strings   2nd   3rd  
                methods  
               OLE DB data providers  
               Open ( ) method  
               properties  
                user information, specifying   2nd  
       connection pooling   2nd   3rd  
       ODBC (Open Database Connectivity)   2nd   3rd  
       OLE DB data sources   2nd  
               Microsoft Access databases  
               Microsoft Access databases in C#  
               Microsoft Access databases in Visual Basic .NET   2nd  
               Oracle databases in C#   2nd  
               Oracle databases in Visual Basic .NET  
       SQL servers   2nd  
connection counter levels
       connection pooling   2nd  
Connection Lifetime keyword  
Connection object  
       Command object, using together   2nd   3rd  
       data sources, connecting to   2nd  
               Close ( ) method   2nd  
               connection strings   2nd   3rd  
               methods  
               OLE DB data providers  
               Open ( ) method  
               properties  
               user information, specifying   2nd  
       instances, creating  
       intantiating
               code  
       transactions  
               BeginTransaction( ) method   2nd   3rd   4th  
               canceling  
               Commit( ) method   2nd  
               GetAndBindData( ) method   2nd  
               InvalidOperationException  
               Open( ) method  
               Rollback( ) method   2nd   3rd   4th   5th   6th   7th   8th  
               rolling back to saved points, code   2nd   3rd   4th   5th   6th   7th  
               Save( ) method   2nd   3rd   4th   5th   6th   7th   8th   9th  
               SqlTransaction object  
               Throw( ) method  
               Transaction property  
connection pooling  
       ADO.NET data provider  
       behavior
               in Performance Monitor  
       counters
               adding to Performance Monitor console  
       data sources   2nd   3rd  
       database connections, reusing  
       NET [edit, period before] data provider  
       NET [edit, period before] data providers  
       NET [edit, period before] Framework  
       OLE DB .NET data provider
               connection counter levels   2nd  
               MSSQL$NetSDK[ colon ]General Statistics performance objects  
               NET [edit, period before] CLR Data performance objects   2nd  
               Performance Monitor, connection pooling behavior  
               Visual Basic code   2nd   3rd   4th  
               Visual Basic code, executing at DOS prompt   2nd  
connection pools
       Connection Lifetime keyword  
       Connection Reset keyword  
       connection-string keywords   2nd  
       connections
               closing  
       Enlist keyword  
       entries
               creating   2nd  
       Max Pool Size keyword  
       Min Pool Size keyword  
       OLE DB .NET data provider   2nd  
               Performance Monitor   2nd  
               Profiler  
               security   2nd  
       Pooling keyword  
       pools  
       sizes  
Connection Reset keyword  
connection strings   2nd   3rd  
       defining
               code   2nd  
       global constants  
       Initial Catalog property  
       OLE DB
               Web site  
       OLE DB data providers  
       options  
       Password property  
       properties   2nd  
       Server property  
       User ID property  
       user information, specifying   2nd  
connection-string keywords   2nd  
connections
       data
               adding   2nd   3rd   4th   5th   6th   7th   8th  
               adding in VS .NET   2nd   3rd   4th  
               configuring  
       errors  
       ODBC (Open Database Connectivity
               to Microsoft Access databases  
       of databases
               managing  
       to connection pools
               closing  
       to databases
               closing  
               reusing  
ConnectionString property  
Connecton object
       ConnectionString property  
       Database property  
       OleDbConnection object  
       Provider property  
       SqlConnection object  
consoles
       IIS administrative console
               virtual directories, managing  
               Web sites, managing  
constants
       global
               connection strings  
constraints
       DataSet object   2nd  
       Northwind database
               Employees table  
constructors
       overloading   2nd  
               code   2nd  
constructs
       On Error
               ADO.NET error handling   2nd   3rd   4th  
               code   2nd  
consuming
       DataSets
               returned by GetAllSuppliers( ) Web service  
       DataSets from Web services   2nd   3rd   4th   5th   6th  
       GetAllSuppliers( ) Web Service
               code   2nd  
contact names
       valid
               retrieving from Customers table  
contents
       DataSets
               viewing   2nd   3rd  
controls
       ASP.NET servers
               System.Web.UI.Control base class  
       BoundColumn  
       DataGrid
               adding   2nd   3rd   4th   5th  
               bound to XML data  
               class hierarchies for data binding  
               code example   2nd   3rd  
               column appearance, defining  
               database order list, code   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
               definition  
               list controls   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  
               properties   2nd  
       DataGrid Web  
       DataList
               list controls   2nd   3rd   4th   5th   6th  
       label Web  
       list
               class hierarchies for data binding  
               definition  
               properties   2nd  
               System.Web.UI.WebControls namespace  
       ListBox
               adding   2nd   3rd   4th   5th  
               binding to DataSet classes   2nd  
               property specifications  
       ListBox Web
               Northwind Employees table, code to delete records   2nd   3rd   4th   5th  
       Repeater
               category lists, code to generate   2nd   3rd   4th  
               category lists, code to return data   2nd  
               list controls   2nd   3rd   4th   5th   6th   7th  
       Required Field
               code   2nd   3rd  
       System.Web.UI.Control base class  
       System.Windows.Forms.Control base class  
       text box
               class hierarchies for data binding  
               definition  
       typed DataSet class
               adding to display data   2nd  
       Windows Forms (client-side)System.Windows.Forms.Control base class  
controls.   [See also Web controls]2nd   [See also Web controls]3rd   [See also Web controls]4th   [See also list controls]5th   [See also Web controls]6th   [See also list controls]7th   [See also list controls]
Cos( expr ) function  
Count( ) SQL function  
counters
       adding to Performance Monitor console  
       connection counter levels
               connection pooling   2nd  
Create Database Diagram Wizard  
Create New Product button
       code   2nd  
Create Relationship screen  
creating
       assemblies   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st  
        buttons   2nd  
       classes
               for assemblies   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       Command objects  
       Connection object instances  
       connection pool entries   2nd  
       database tables  
       DataSet object schemas   2nd   3rd   4th   5th  
       DataSets   2nd   3rd   4th   5th  
               from XML files   2nd   3rd   4th   5th   6th  
       DSN (Data Source Name )
               for ODBC (Open Database Connectivity) data source   2nd   3rd   4th  
       labels   2nd  
       projects
               in VS .NET   2nd   3rd   4th  
       proxy classes  
       stored procedures
               with Enterprise Manager  
       Suppliers class instancees  
       table relationships   2nd   3rd   4th   5th  
       test harness
               for ADO.NET code   2nd   3rd   4th   5th   6th   7th   8th   9th  
       text boxes   2nd  
       Web forms  
       Web services  
       Web sites   2nd   3rd  
criteria
       automatically generated commands   2nd   3rd  
cross-platform style sheets
       reference guides
               Web site  
cs [edit, period before] file  
CSS
       (cascading style sheets)  
       ADO24HRS.css file
               classes;code to add   2nd  
               contents;modifying  
       ASP.NET list controls, formatting   2nd   3rd   4th   5th   6th   7th   8th  
       cross-platform style sheets
               reference guides, Web site  
       css [edit, period before] file extension  
       DataGrid list control
               code   2nd   3rd  
               stylesheets  
               stylesheets, code   2nd  
       MainHeader class
               adding to ADO24HRS.css file  
       stylesheets
               Web forms  
css [edit, period before] file extension  
CurrencyManager object
       data, binding to list controls   2nd  
custom classes
       ProductDetails
               code   2nd  
custom objects
       single rows of data, replacing   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
Customer Inquiry form  
       execution (successful)   2nd  
       Refresh Failed exception  
       SQL error message  
       validate exceptions  
       validation error-handling  
Customer table
       DataSet XML
               code to generate typed DataSet class   2nd  
Customer_GetByID stored procedure  
CustomerID parameter
       stored procedures
               code   2nd  
customers
       Get Customer Forms application
               complex DataGrid binding  
               simple binding  
customers and orders relationship
       XML Schema editor  
Customers DataSet
       RowError condition
               code to add   2nd  
Customers Get stored procedure
       code   2nd   3rd  
Customers table
       and Orders table, relationships  
       timestamp column
               code   2nd  
       typed Dataset
               XML Schema file, code   2nd   3rd   4th   5th  
       typed DataSet class  
       valid contact names, retrieving  
Customers.VB source code  
Customers.xsd file
       Visual Studio .NET Component Designer  
CustomersOrders relation
       Edit Relation dialog box  
CustOrdDS.xsd schema file   2nd  
CustOrdDS.xsd XML Schema file   2nd   3rd  

for RuBoard