ADO.NET—the data-access component of the Microsoft .NET Framework—works with any component on any platform that understands XML. Get a solid handle on ADO.NET and learn how to exploit the database functionality of Microsoft Visual Basic® .NET and Microsoft Visual C#™ .NET with this step-by-step primer. You’ll be working in ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Learn about the ADO.NET object model and how to use it to develop data-bound Windows® Forms and Web Forms. See how ADO.NET interacts with XML and how to access older versions of ADO from the .NET environment. Throughout, you’ll find insightful tips and expert explanations for rapid acceleration of development productivity, faster applications, and more powerful results. Topics covered include:
Getting started with ADO.NET
Creating connections
The Data command and DataReader
Accessing data with the DataAdapter
Working with DataSets
Working with DataTables
Controlling table views with DataViews
Editing and updating data
Data-binding in Windows Forms
Data-binding in Web Forms
Using the XML Designer to modify data structure
Reading and writing XML with ADO.NET
Using ADO from the .NET Framework
CD features:* Examples of real-world solutions developed with ADO.NET, including sample code in Visual Basic .NET and Visual C# .NET
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Rebecca M. Riordan is the author of Microsoft SQL Server 2000 Programming Step By Step (Microsoft Press, 1999). She has worked as a consultant, systems analyst, and senior technical support engineer for Microsoft Australia and she studied database design and analysis at the University of California, Irvine. Rebecca was also a presenter at 1994 and 1995 TechEd sessions, covering topics ranging from reusable system components to searching data stores.