Programming Microsoft® ADO.NET 2.0 Core Reference

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

Author of two previous editions of this book, David Sceppa is currently working as a Program Manager on the Microsoft SQL Server team, working with the new data features in the product as well as with ADO .NET itself. David has previously worked on Microsoft’s Visual Basic® data team and in Developer Support as a technical lead, helping customers (and coworkers) with issues regarding building database applications with Visual Basic. He is also Microsoft certified and has a background in teaching.