Your definitive guide to the core topics for creating distributed, datacentric applications.

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

• Getting Started with Microsoft ADO.NET 2.0
  • Overview of ADO.NET
  • Building Your First ADO.NET Application with
  • Microsoft Visual Studio 2005
• Getting Connected: Using a .NET Data Provider
  • Connecting to Your Database
  • Querying Your Database
  • Retrieving Data Using SqIDataAdapter Objects
• Working with Data Offline - The ADO.NET DataSet
  • Working with DataSet Objects
  • Working with Relational Data
  • Sorting, Searching, and Filtering
  • Working with Strongly Typed DataSet Objects and TableAdapters
  • Submitting Updates to Your Database
  • Advanced Updating Scenarios
  • Working with XML Data
• Building Effective Applications with ADO.NET 2.0
  • Building Effective Microsoft Windows-Based Applications
  • Building Effective Web Applications
  • SQL Server 2005 Common Language Runtime Integration
• Appendixes
  • Using Other .NET Data Providers.
  • Samples and Tools