Programming Microsoft® ADO.NET 2.0 Core Reference

Get a practical introduction to the Microsoft .NET Framework 2.0 libraries (ADO.NET 2.0) that communicate, access, sort, and interact with data from .NET-connected applications. Includes coverage of XML data and Microsoft SQL Server 2005. 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 2005Use Microsoft .NET Framework 2.0 data providers to connect to databases Build connection strings and enable connection poolingExecute queries, including parameterized and asynchronous queries, and retrieve their resultsCreate DataSet objects to work with offline data and explore common usage scenariosUse the new Common Language Runtime features and XML data type in Microsoft SQL Server 2005Generate logic and use stored procedures for simple to advanced updating scenariosDesign 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