Visual C++ 6 Unleashed

By MICKEY WILLIAMS and David Bennett

• Table of Contents
  • Copyright
  • About the Authors
  • About the Contributors
  • Acknowledgments
  • Tell Us What You Think!
  • Introduction
  • How to Use This Book
  • What You Need to Use This Book
  • What's New in Visual C++ 6.0
  • Contacting the Main Author
  • Part I: Introduction
  • Chapter 1. The Visual C++ 6.0 Environment
  • Part II: MFC Programming
  • Chapter 2. MFC Class Library Overview
  • Chapter 3. MFC Message Handling Mechanism
  • Chapter 4. The Document View Architecture
  • Chapter 5. Creating and Using Dialog Boxes
  • Chapter 6. Working with Device Contexts and GDI Objects
  • Chapter 7. Creating and Using Property Sheets
  • Chapter 8. Working with the File System
  • Chapter 9. Using Serialization with File and Archive Objects
  • Part III: Internet Programming with MFC
  • Chapter 10. MFC and the Internet Server API (ISAPI)
  • Chapter 11. The WinInet API
  • Chapter 12. MFC HTML Support
  • Part IV: Advanced Programming Topics
  • Chapter 13. Using the Standard C++ Library
  • Chapter 14. Error Detection and Exception Handling Techniques
  • Chapter 15. Debugging and Profiling Strategies
  • Chapter 16. Multithreading
  • Chapter 17. Using Scripting and Other Tools to Automate the Visual C++ IDE
  • Part V: Database Programming
  • Chapter 18. Creating Custom AppWizards
  • Chapter 19. Database Overview
  • Chapter 20. ODBC Programming
  • Chapter 21. MFC Database Classes
    • Using the AppWizard to Generate MFC Classes
    • The CRecordset Class
    • The CRecordView Class
    • The CDatabase Class
    • Exception Handling
    • Bulk Row Operations
    • Summary
  • Chapter 22. Using OLE DB
  • Chapter 23. Programming with ADO
  • Part VI: MFC Support for COM and ActiveX
  • Chapter 24. Overview of COM and Active Technologies
  • Chapter 25. Active Documents
  • Chapter 26. Active Containers
  • Chapter 27. Active Servers
  • Chapter 28. ActiveX Controls
  • Part VII: Using the Active Template Library
  • Chapter 29. ATL Architecture
  • Chapter 30. Creating COM Objects Using ATL
  • Chapter 31. Creating ActiveX Controls Using ATL
  • Chapter 32. Using ATL to Create MTS and COM+ Components
  • Part VIII: Finishing Touches
  • Chapter 33. Adding Windows Help
  • Part IX: Appendix

Summary

In this chapter, you explored MFC's support for database operations in your applications.

You learned that most developers will use the AppWizard to begin their MFC ODBC development. It's easy, relatively bug-free, and allows faster development of applications.

You examined the basic classes that MFC provides for working with ODBC datasources—CDatabase, CRecordset, and CRecordView.

You learned that you can use CDatabase functions to execute SQL statements against the datasource, including transactions. You can use the CRecordset class to provide a simple way to move data from rows in the database back and forth between member variables of the recordset by using record field exchange. You saw that, in addition to using recordsets to select rows from a database, you can use recordsets to add, delete, and update rows in the database.

You also looked at how to use the CRecordView class to provide a convenient interface between the user and the data in a recordset, including a special case of dialog data exchange that supports the member variables of an associated recordset.

Finally, you learned that for efficiency, bulk operations are supported in the MFC ODBC API. This chapter showed you how to implement this feature.

Share This