Sams Teach Yourself .Net in 21 Days

By Jason Beres

• Table of Contents
  • Copyright
  • About the Author
  • About the Technical Editor
  • Acknowledgments
  • We Want to Hear from You
  • Introduction
  • Week 1: At a Glance
  • Day 1. Introduction to the Microsoft .NET Framework
  • Day 2. Introduction to Visual Studio .NET
  • Day 3. Writing Windows Forms Applications
  • Day 4. Deploying Windows Forms Applications
  • Day 5. Writing ASP.NET Applications
  • Day 6. Deploying ASP.NET Applications
  • Day 7. Exceptions, Debugging, and Tracing
  • Week 1. In Review
  • Week 2: At a Glance
  • Day 8. Core Language Concepts in Visual Basic .NET and C#
  • Day 9. Using Namespaces in .NET
  • Day 10. Accessing Data with ADO.NET
    • Looking Inside ADO.NET
    • Connecting to a Database
    • Using the Command Object and DataReaders
    • Using Windows Controls with DataReaders and Command Objects
    • Using DataAdapters and DataSets
    • Using Databinding with DataSets
    • Binding to a DataGrid Control
    • Summary
    • Q&A
    • Quiz
    • Exercises
  • Day 11. Understanding Visual Database Tools
  • Day 12. Accessing XML in .NET
  • Day 13. XML Web Services in .NET
  • Day 14. Components and .NET
  • Week 2. In Review
  • Week 3: At a Glance
  • Day 15. Writing International Applications
  • Day 16. Using Macros in Visual Studio .NET
  • Day 17. Automating Visual Studio .NET
  • Day 18. Using Crystal Reports
  • Day 19. Understanding Microsoft Application Center Test
  • Day 20. Using Visual SourceSafe
  • Day 21. Object Role Modeling with Visio
  • Week 3. In Review

Day 10. Accessing Data with ADO.NET

Most of the applications that you write must access some sort of data store. Today, you learn about data access in .NET. ActiveX Data Objects .NET (ADO.NET) is the technology used in the .NET Framework for all database access. Before .NET, the main technology for data access was ActiveX Data Objects (ADO). ADO was great, but it had its drawbacks. But when there's only one way to do something, as with ADO and accessing data, it's easy to forget about the drawbacks and just work with what you have. Microsoft set out to fix all of these drawbacks in ADO.NET, which was written from the ground up specifically for data access in .NET and the challenges that developers face in the disconnected environment of the Internet. Today, you learn

• The ADO.NET architecture and how it differs from ADO
• How to connect to databases with the Connection object
• How to use DataReaders
• How to use the Command object
• How to use DataAdapters
• How to use DataSets
• How to filter and sort DataSets with DataViews
• Databinding fundamentals in Windows Forms

Share This