ADO.NET Programming in Visual Basic™ .NET

Table of contents

1. Copyright
2. Introduction
3. Visual Basic .NET Database Programming
   1. Database Access in VB .NET
   2. Your First ADO .NET Program
   3. An ADO .NET Windows Form Program
   4. Summary
4. Object-Oriented Programming in Visual Basic .NET
   1. A Thumbnail Sketch of OOP
   2. Terms and Definitions
   3. Encapsulation
   4. Inheritance
   5. Polymorphism
   6. Events and Delegates
   7. Summary
5. Visual Basic .NET Database Tools
   1. A Roadmap of the IDE
   2. Opening or Creating a Project
   3. ASP .NET Projects
   4. Other Types of Applications
   5. The Server Explorer
   6. Installing the MSDE
   7. Creating Databases
   8. Views and the Query Designer
   9. Database Diagrams
   10. Database Projects
   11. Summary
6. The ADO .NET Class Library
   1. ADO .NET Class Library Overview
   2. Comparison of ADO .NET and ADO 2.x
   3. Multitier Application Design
   4. The SqlClient and OleDbClient Classes
   5. The Connection Classes
   6. The Command Class
   7. The DataAdapter Class
   8. The DataSet Class
   9. Summary
7. Connecting to Databases
   1. Using The Connection Class
   2. The SQL Server Data Provider
   3. The Oracle Data Provider
   4. The Microsoft Access (Jet) Database Provider
   5. Connection Class Events
   6. Using Transactions—The Transaction Class
   7. Summary
8. ADO .NET DataAdapters
   1. The DataAdapter Classes
   2. The DataAdapter Configuration Wizard
   3. The Query Builder
   4. Concurrency Management
   5. The Select Command
   6. The Update Command
   7. The Insert and Delete Commands
   8. Programmatically Configuring a DataAdapter Using the CommandBuilder
   9. Programmatically Configuring the DataAdapter Using Your Own Code
   10. Parsing Your SQL Statement–A Better Way
   11. Summary
9. The ADO .NET DataSet
   1. What Is XML
   2. An Overview of the DataSet
   3. Typed and Untyped DataSets
   4. The DataTable Class
   5. The DataColumn Class
   6. Typed DataSets
   7. Untyped DataSets
   8. Master-Detail Relations in the DataSet
   9. Using the DataView Class
   10. Summary
10. Data Binding in Windows Forms
    1. Data Binding in Windows Forms
    2. The CurrencyManager Class
    3. The Data Form Wizard
    4. Binding to Other Objects (Arrays, Lists, etc.)
    5. The Binding Class
    6. Simple Bound Controls
    7. Complex Bound Controls—ListBoxes, ComboBoxes, and the DataGrid
    8. The DataGrid
    9. Summary
11. Data Binding in Web Forms
    1. The Life Cycle of a Web Form
    2. Maintaining Session State
    3. Setting Up Internet Information Server 5.0
    4. ASP .NET and HTML–Universal Browser Support
    5. The Data-Bound Web Form
    6. The Simple Web Controls
    7. The Complex Web Controls
    8. The Web DataGrid
    9. The DataList Control
    10. Summary
12. Building XML Web Services
    1. Multitier Application Services
    2. Creating An ASP .NET Web Services Project
    3. The CustomersOrders Web Service
    4. Using Web Services with Windows Forms Clients
    5. Using Web Services with Web Forms Clients
    6. Summary
13. Creating Your Own Data Control
    1. About UserControls
    2. Creating the Project
    3. Creating the Visual Interface
    4. Creating a Test Harness
    5. Adding the Functionality
    6. Creating the Components
    7. Event Handlers
    8. Completing the Test Harness
    9. Initialization Code
    10. Reading the Data and Schema
    11. The Navigation Procedure
    12. Exposing the Data Table to the World
    13. Let’s Try It!
    14. Updating the Database
    15. Summary