Table of Content

for RuBoard

Sams Teach Yourself ADO.NET in 24 Hours
By Jason  Lefebvre, Paul  Bertucci
Publisher	: Sams Publishing
Pub Date	: May 10, 2002
ISBN	: 0-67232-383-4
Pages	: 408
Slots	: 1			Copyright
		About the Authors
		Acknowledgments
		Tell Us What You Think!
		Introduction
			Conventions Used in This Book
		Hour  1.   Introducing the Microsoft .NET Framework and ADO.NET
			The Microsoft .NET Framework Class Library
			What Is ADO.NET?
			ADO.NET Versus ADO
			The System.Data Namespace
			The System.Data.SqlClient and System.Data.OleDb Namespaces
			Installing the Microsoft .NET Framework
			Summary
			Q&A
			Workshop
		Hour  2.   Working with DataSet s and DataTable s
			Crash Course on Database Schema
			DataSet Overview
			Creating DataSet Schema
			Adding and Removing Data
			Summary
			Q&A
			Workshop
		Hour  3.   Using T-SQL: A Crash Course
			Retrieving Data with SELECT
			Adding New Data with INSERT
			Modifying Data with UPDATE and DELETE
			Using the Built-in SQL Functions
			Summary
			Q&A
			Workshop
		Hour  4.   Adding Relationships to DataSet s
			Database Relationships and Constraints
			The DataRelation Object
			The DataSet Relations Collection
			Summary
			Q&A
			Workshop
		Hour  5.   Connecting to a Data Source
			The Connection Object
			Connecting to Various Data Sources
			ODBC (Open Database Connectivity)
			Connection Pooling
			Summary
			Q&A
			Workshop
		Hour  6.   Retrieving Data from the Data Source
			The Command Object
			Filling a DataSet with the DataAdapter
			Retrieving a Single Value from the Database
			Summary
			Q&A
			Workshop
		Hour  7.   Modifying Database Data
			Using ExecuteNonQuery()
			Summary
			Q&A
			Workshop
		Hour  8.   Using the DataReader and DataAdapter
			DataReader Versus DataAdapter
			Instantiating the DataReader
			Binding DataReader Results to a Web Control
			Stepping Through Data with the DataReader
			Limitations of the DataReader
			Summary
			Q&A
			Workshop
		Hour  9.   Binding Data to List Controls
			Binding Data to Controls
			Simple Data Binding in Windows Forms
			Complex Data Binding in Windows Forms
			Summary
			Q&A
			Workshop
		Hour  10.   Working with XML
			What Is XML?
			Reading XML
			Creating a DataSet from an XML File
			Serializing DataSet s to XML
			Using XmlReader
			Summary
			Q&A
			Workshop
		Hour  11.   Using the Built-In ASP.NET List Controls
			Some General Notes About List Controls
			Working with the Repeater
			Working with the DataGrid
			Working with the DataList
			Summary
			Q&A
			Workshop
		Hour  12.   Formatting ASP.NET List Controls
			A Quick Overview of CSS
			Formatting the Repeater
			Formatting the DataList
			Formatting the DataGrid
			Summary
			Q&A
			Workshop
		Hour  13.   Handling ADO.NET Errors
			Using Formal Error Handling (Ready, "Catch"!)
			Typical Errors to Handle
			Using RowError of the DataSet
			Summary
			Q&A
			Workshop
		Hour  14.   Managing ADO.NET Concurrency
			Optimistic Versus Pessimistic Concurrency
			Coding for Optimistic Concurrency
			Comparing DataSet Values Against the Database for Optimistic Concurrency
			Using a Timestamp for Optimistic Concurrency
			XML and Optimistic Concurrency
			Summary
			Q&A
			Workshop
		Hour  15.   Working with Stored Procedures
			What Are Stored Procedures?
			Executing a Stored Procedure
			Using Parameters
			Summary
			Q&A
			Workshop
		Hour  16.   ADO Upgrade Concerns
			General Upgrade Issues from ADO to ADO.NET
			Accessing an ADO Recordset from ADO.NET
			Summary
			Workshop
		Hour  17.   Using Connection Pooling
			What Is Connection Pooling?
			OLE DB .NET Data Provider
			Summary
			Q&A
			Workshop
		Hour  18.   Working with Transactions
			What Is a Transaction?
			Transactions and ADO.NET
			Transactions with Stored Procedures
			Summary
			Q&A
			Workshop
		Hour  19.   Using Automatically Generated Commands
			Automatically Generated Commands
			Using the CommandBuilder
			Summary
			Q&A
			Workshop
		Hour  20.   Working with Typed DataSet s
			The Typed DataSet
			Generating a Typed DataSet
			Typed DataSets in Visual Studio .NET
			Summary
			Q&A
			Workshop
		Hour  21.   Optimizing Data Access Using Tiered Development
			What Is Tiered Development?
			Implementing Tiered Development
			Creating Your Own Assembly
			Summary
			Q&A
			Workshop
		Hour  22.   Modifying Data in an N-Tier Application
			Updating Product Data
			Adding Product Data
			Summary
			Q&A
			Workshop
		Hour  23.   Optimizing Data Access
			Optimizing ADO.NET Code
			ASP.NET Tracing
			Improving Your Queries with the SQL Query Analyzer
			Simulating Application Traffic
			Data Caching
			Summary
			Q&A
			Workshop
		Hour  24.   Transmitting DataSet s Using Web Services
			Sending a DataSet Using Web Services
			Consuming a DataSet from a Web Service
			Summary
			Q&A
			Workshop
		Appendix  A.
			Hour 1
			Hour 2
			Hour 3
			Hour 4
			Hour 5
			Hour 6
			Hour 7
			Hour 8
			Hour 9
			Hour 10
			Hour 11
			Hour 12
			Hour 13
			Hour 14
			Hour 15
			Hour 16
			Hour 17
			Hour 18
			Hour 19
			Hour 20
			Hour 21
			Hour 22
			Hour 23
			Hour 24
		Index

for RuBoard