Programming ADO.NET 2.0 Core Reference

Description

Build your expertise as you move beyond the basics - and delve into the essential topics of programming with ADO.NET 2.0. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C# and Visual Basic to help advance your mastery of developing database applications for Microsoft Windows and the Web.

Discover how to:

* Work with design-time data access features in Microsoft Visual Studio 2005
* Use Microsoft .NET Framework 2.0 data providers to connect to databases
* Build connection strings and enable connection pooling
* Execute queries, including parameterized and asynchronous queries, and retrieve their results
* Create DataSet objects to work with offline data and explore common usage scenarios
* Use the new Common Language Runtime features and XML data type in Microsoft SQL Server 2005
* Generate logic and use stored procedures for simple to advanced updating scenarios
* Design Web applications with new data access features in ASP.NET 2.0 - including code-free data-binding capabilities

PLUS - Get Visual Basic and C# code samples, and a Microsoft .NET Data Provider on the Web

CONTENTS:

AcknowledgmentsIntroductionPart I: Getting Started with Microsoft ADO.NET 2.0
* Chapter 1: Overview of ADO.NET
* Chapter 2: Building Your First ADO.NET Application with Microsoft Visual Studio 2005Part II: Getting Connected: Using a .NET Data Provider
* Chapter 3: Connecting to Your Database
* Chapter 4: Querying Your Database
* Chapter 5: Retrieving Data Using SqlDataAdapter ObjectsPart III: Working with Data Offline - The ADO.NET DataSet
* Chapter 6: Working with DataSet Objects
* Chapter 7: Working with Relational Data
* Chapter 8: Sorting, Searching, and Filtering
* Chapter 9: Working with Strongly Typed DataSet Objects and TableAdapters
* Chapter 10: Submitting Updates to Your Database
* Chapter 11: Advanced Updating Scenarios
* Chapter 12: Working with XML DataPart IV: Building Effective Applications with ADO.NET 2.0
* Chapter 13: Building Effective Microsoft Windows - Based Applications
* Chapter 14: Building Effective Web Applications
* Chapter 15: SQL Server 2005 Common Language Runtime IntegrationPart V: Appendixes
* Appendix A: Using Other .NET Data Providers
* Appendix B: Samples and Tools
* About the Author