You are previewing ADO.NET Programming in Visual Basic™ .NET.
O'Reilly logo
ADO.NET Programming in Visual Basic™ .NET

Book Description

Prentice Hall PTR's new ADO.NET Programming in Visual Basic .NET -

  • The practical guide to database development with VB.NET and ADO.NET

  • Includes detailed coverage of XML-based Web services

  • Data providers, DataGrids, DataSets, data binding, and much more

  • Complete case study application-building a robust ADO.NET data control

Build powerful database apps and Web services fast, with VB.NET and ADO.NET!

With ADO.NET, you can build database-enabled applications and Web services with more speed, flexibility, and power than ever before. ADO.NET Programming in Visual Basic .NET teaches you all you'll need to know to make the most of ADO.NET - whether you're an experienced Visual Basic database programmer or not. The authors' realistic code examples and practical insights illuminate ADO.NET from its foundations to state-of-the-art data binding and application optimization.

Coverage includes -

  • Understanding the ADO.NET class libraries

  • Utilizing Visual Basic.NET's powerful database programming tools

  • Connecting to databases using ADO.NET's wide range of data providers

  • Using DataSets to read, store, and process XML data

  • Mastering data binding with Windows Forms and ASP.NET Web Forms

  • Building data-driven XML-based Web Services and Windows thin client applications

The book concludes with a complete case study application - constructing a .NET version of the powerful ADO data control that VB 6 programmers loved, but isn't included in ADO.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