Main Page

   
Database Access with Visual Basic® .NET, Third Edition
By Jeffrey P. McManus, Jackie Goldstein
   
Publisher : Addison Wesley
Pub Date : February 14, 2003
ISBN : 0-672-32343-5
Pages : 464


Database Access with Visual Basic .NET continues to use techniques developed by Jeffrey McManus that provide solutions to problems faced by developers every day. Since data access is the most used feature in corporate development, it is important for developers to understand the most effective and efficient way to access data using .NET technologies. This book provides clear explanations of how to use ADO.NET to access data stored in relational databases, as well as how XML integrates with ADO.NET. The authors use their years of experience to relate key topics to real-world applications through use of Business Cases that include code listings in Visual Basic .NET.

   
•  Table of Contents
Database Access with Visual Basic® .NET, Third Edition
By Jeffrey P. McManus, Jackie Goldstein
   
Publisher : Addison Wesley
Pub Date : February 14, 2003
ISBN : 0-672-32343-5
Pages : 464
Copyright
    Preface
      Who This Book Is For
      How This Book Is Organized
      The Software Environment
      Keeping in Touch
      About the Authors
      About the Contributor
      About the Technical Reviewers
   
    Acknowledgments
    Chapter 1.  Database Basics
      What Is a Database?
      Business Cases
      Tables and Fields
      Manipulating Data with Objects
      Data Types
      Creating a Database Schema
      Relationships
      Normalization
      Creating a User Interface in a Windows Forms Application
      Summary
   
    Chapter 2.  Structured Query Language Queries and Commands
      What Is a Query?
      Testing Queries with the Server Explorer
      Retrieving Records with the SELECT Clause
      Designating a Record Source with the FROM Clause
      Specifying Criteria with the WHERE Clause
      Sorting Results with ORDER BY
      Displaying the Top or Bottom of a Range with TOP
      Joining Related Tables in a Query
      Performing Calculations in Queries
      Aliasing Field Names with AS
      Queries That Group and Summarize Data
      Union Queries
      Subqueries
      Manipulating Data with SQL
      Using Data Definition Language
      Summary
   
    Chapter 3.  Getting Started with SQL Server 2000
      Setting Up and Running Microsoft SQL Server 2000
      Getting Started with SQL Server 2000: The Basics
      Summary
   
    Chapter 4.  ADO.NET—Data Providers
      Overview of ADO.NET
      Overview of .NET Data Provider Objects
      The Connection Object
      The Command Object
      The DataReader Object
      Using the Connection and Command Design-Time Components
      Other Data Provider Objects
      Summary
   
    Chapter 5.  ADO.NET—The DataSet
      Applications and Components of the DataSet
      Populating and Manipulating the DataSet
      Using the DataSet Component
      Summary
   
    Chapter 6.  ADO.NET—The DataAdapter
      Populating a DataSet from a Data Source
      Updating the Data Source
      Summary
   
    Chapter 7.  ADO.NET—Additional Features and Techniques
      Detecting Concurrency Conflicts
      Table and Column Mappings
      DataViews
      Strongly Typed DataSets
      Summary
   
    Chapter 8.  Visual Studio.NET Database Projects
      Creating a Database Project
      Database References
      Scripts
      Queries
      Summary
   
    Chapter 9.  XML and .NET
      An Overview of XML
      XML Classes in .NET
      Extending SQL Server with SQLXML 3.0 and IIS
      Using XML, XSLT, and SQLXML to Create a Report
      Summary
   
    Chapter 10.  ADO.NET and XML
      Basic Reading and Writing of XML
      Creating an XmlReader from a Command Object
      The XmlDataDocument Object
      Summary
   
    Chapter 11.  WebForms: Database Applications with ASP.NET
      An Overview of ASP.NET
      Accessing a Database Through ASP.NET
      Improving the Performance of ASP.NET Database Applications Through Stored Procedures
      Summary
   
    Chapter 12.  Web Services and Middle-Tier Technologies
      Using the Middle Tier to Provide Presentation Logic
      Using Data in the Middle Tier
      Exposing Objects Through Web Services
      Putting It All Together
      Summary