Sams Teach Yourself ADO.NET in 24 Hours

T-SQL  

       ( Transact -SQL)  

       case sensitivity  

       DELETE statement

               data, deleting   2nd   3rd   4th   5th  

               rows, code to delete from Employee table   2nd   3rd   4th  

       INSERT statement

               data, adding   2nd  

       keywords

               capitalizing  

       Microsoft SQL Server

               white spaces  

       Northwind database, downloading   2nd  

       SELECT statement

               data, filtering  

               data, retrieving   2nd   3rd   4th   5th   6th  

               syntax   2nd  

       SQL functions (built-in)  

               dates   2nd   3rd  

               mathematical   2nd  

               strings   2nd  

       statements

                columns , code to specify   2nd  

       strings

               ' (single quotation marks)  

       UPDATE statement

               columns, code to update   2nd  

               data, updating   2nd   3rd   4th   5th  

                employees • names , changing  

               employees • names, code to change   2nd  

               syntax   2nd  

t[ colon ]library [edit, fwd slash ifo t] directive  

TABLE [edit, HTML brackets] tag  

tables

       automatically generated commands

               criteria  

       columns

                appearances , defining  

               BoundColumn control  

               child  

               code to specify   2nd  

               DataFormatString property  

               HyperLinkColumn  

               join operations  

               names, sharing  

               names, special character  

               parent  

       Custome

               DataSet XML;code to generate typed DataSet class   2nd  

       Customers

               timestamp column, code   2nd  

               typed DataSet class  

               typed Dataset, XML Schema file (code)   2nd   3rd   4th   5th  

               valid contact names, retrieving  

       Customers and Orders, relationships  

       database schemas   2nd  

       DataColumns object

               adding to DataTable object   2nd   3rd   4th  

       DataRows object

               dtEmployees table, adding rows   2nd  

       DataSet object   2nd  

               DataTable object, adding   2nd   3rd  

               instantiating   2nd  

               schemas, creating   2nd   3rd   4th   5th  

       DataTable object  

               adding to DataSet object   2nd   3rd  

               data, adding or deleting   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  

               DataColumns object, adding   2nd   3rd   4th  

               dtEmployees table, adding rows   2nd  

       DataTables objects

               relationships   2nd   3rd   4th  

               relationships, code to add   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  

       dtEmployees

               rows, adding   2nd  

               rows, adding with Basic.NET code   2nd  

               rows, adding with C# code   2nd  

       Employee

               rows, code to delete   2nd   3rd   4th  

       Employees

               constraints  

               records, retrieving  

       Employees (Northwind database)

               employees, adding   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  

       foreign key columns

               names, sharing  

       in databases, creating  

       indexes

               analyzing   2nd   3rd  

       LastName column  

       names

               special character  

       Northwind Employees

               records, code to delete   2nd   3rd   4th   5th  

       Orders

               typed Dataset, XML Schema file (code)   2nd   3rd  

       primary key columns

               names, sharing  

       primary keys   2nd  

       queries

               executing  

       relationships  

                  (infinity symbol)  

               creating   2nd   3rd   4th   5th  

       schema.owner.table

               special characters  

       single rows of data

               replacing with custom objects   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

       timestamp columns

               ANSI-SQL 92 and higher  

               Customers table, code   2nd  

               optimistic concurrency   2nd   3rd   4th  

tables.   [See also DataTable object]

Tabor, Robert  

tags

       head [edit, HTML brackets]  

       TABLE [edit, HTML brackets]  

       TD [edit, HTML brackets]  

       XML   2nd  

Tan( expr ) function  

TD [edit, HTML brackets] tag  

TemplateColumn property

       DataGrid list control  

templates

       AlternatingItemTemplate  

       FooterTemplate  

       HeaderTemplate  

       ItemTemplate   2nd  

       Repeater list control

               code   2nd   3rd  

       SeparatorTemplate  

test harness

       ADO.NET code   2nd   3rd   4th   5th   6th   7th   8th   9th  

       C# code   2nd   3rd  

       VB.NET code   2nd   3rd  

testing

       applications

               with typed DataSet class  

       code in Web forms   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

       complex data binding in Windows Forms   2nd  

       simple data binding in Windows Forms   2nd   3rd  

       stored procedures  

               with Query Analyzer  

               with Query Analyzer, query results  

       Web services  

       Windows Forms application

               Try/Catch/Finally structure   2nd   3rd  

text box controls

       class hierarchies for data binding  

       definition  

text box property

       Databindings [edit, place in parens] node  

text boxes

       adding to forms  

       binding

               to DataSets   2nd  

               to typed DataSet class   2nd  

       creating   2nd  

three- tier development

       product data

               adding   2nd   3rd   4th   5th   6th   7th   8th  

               updating   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  

Throw statement

       ADO.NET error handling   2nd  

Throw( ) method

       transactions  

tiered development

       data access   2nd   3rd  

               assemblies, compiling ADO24HRS namespace   2nd   3rd  

               assemblies, creating   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st  

               assemblies, creating classes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

               assemblies, custom objects   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

               assemblies, wiring product list page to ProductsDB assembly   2nd   3rd   4th   5th  

               implementing   2nd   3rd  

               tiers, number of   2nd  

               two-tier applications  

       N-tier development  

       NET [edit, period in front] tiered development model  

tiers

       number of   2nd  

       two-tier applications  

       UpdateProducts middle-tier method

               code   2nd   3rd  

tiers.   [See also three-tier development]

timestamp columns

       ANSI-SQL 92 and higher  

       Customers table, code   2nd  

       optimistic concurrency   2nd   3rd   4th  

Toolbox

       Data tab   2nd   3rd  

       Windows Forms tab   2nd   3rd  

tools

       Microsoft Web Application Stress Tool

               downloading  

       XML Schema Definition (XSD.exe))

               DataSet class, typed   2nd   3rd   4th   5th   6th   7th  

Trace object  

Trace.Write( ) method  

trace=true [edit, place true in double quotes] property  

Trace=true [edit, place true in double quotes] property  

tracing   2nd  

       ADO.NET

               information provided  

       information  

               applications, finding bottlenecks   2nd   3rd   4th   5th  

               entries, adding  

               Trace object  

               trace=true [edit, place true in double quotes] property  

               Trace=true [edit, place true in double quotes] property  

traffic

       applications

               simulating   2nd  

Transact-SQL.   [See T-SQL]

Transaction property  

transactions  

       Connection object  

               BeginTransaction( ) method   2nd   3rd   4th  

               canceling  

               Commit( ) method   2nd  

               GetAndBindData( ) method   2nd  

               Open( ) method  

               Rollback( ) method   2nd   3rd   4th   5th   6th   7th   8th  

               Save( ) method   2nd   3rd   4th   5th   6th   7th   8th   9th  

               SqlTransaction object  

               Throw( ) method  

               Transaction property  

       Employee_Add stored procedure  

       examples  

       InvalidOperationException  

       rolling back to saved points, code   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  

       saving  

       stored procedures   2nd   3rd   4th   5th  

               @EmployeeID variable  

               ROLLBACK TRAN SQL statement  

transmitting

       DataSets with Web services   2nd  

Try/Catch/Finally statement

       ADO.NET error handling  

Try/Catch/Finally structure

       ADO.NET error handling   2nd   3rd   4th   5th  

       code   2nd  

       Windows Forms application   2nd   3rd   4th   5th   6th  

               testing   2nd   3rd  

TSEQUAL update syntax

       optimistic concurrency  

tutorials

       QuickStart WEb site  

two-tier applications  

two-tier development (data sources)  

type libraries

       importing   2nd  

typed DataSet class   2nd   3rd   4th  

       annotations   2nd   3rd   4th   5th  

       applications, testing  

       controls, adding to display data   2nd  

       generating   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

       instances, adding to forms   2nd  

       populating, code   2nd  

       text boxes, binding   2nd  

       VB code   2nd  

       VS .NET  

               data adapters, adding   2nd   3rd   4th  

               data connections, adding   2nd   3rd   4th  

               projects, creating   2nd  

       XML Schema definition language standards

               Web site  

       XSD.exe (XML Schema Definition tool)   2nd   3rd   4th   5th   6th   7th