Table of content

•	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