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

Summary

Today you learned all the basics of accessing data with ADO.NET. Like most of the object models in the FCL, Microsoft seems to have thought of everything, and ADO.NET is no different. Choosing the wrong data access strategy when developing applications can spell disaster for scalability and functionality. With ADO.NET, you have many options to choose from when deciding how to get data to and from any type of data store.

If you need fast, read-only access, use a DataReader.

If you need complex relational data that must be disconnected from a data source, use DataSets and DataAdapters.

Tomorrow you continue learning about using ADO.NET through the Visual tools in Visual Studio .NET. Everything you learned today serves as a foundation for your work tomorrow and the rest of the week.

Share This