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