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.