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
  • Chapter 22. Using OLE DB
  • Chapter 23. Programming with ADO
    • ADO Objects
    • Connection Objects
    • ADOCommand Objects
    • ADORecordset Objects
    • ADOFields Collections and ADOField Objects
    • ADOParameter Objects and the ADOParameters Collection
    • ADOProperty Objects and ADOProperties Collections
    • Writing a Visual C++ ADO Application
    • Processing ADO Errors
    • Enhanced ADO Recordset Functionality
    • Executing Commands
    • Transactions
    • Summary
  • 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

ADOCommand Objects

ADOCommand objects are used to represent specific commands that will be executed against the datasource. Command objects are used to keep track of parameters associated with the command, and other settings. You can create a command using an existing connection, or you can have ADO create a new connection for use with the new command.

ADOCommand Properties

All ADOCommand objects have the following properties:

• ActiveConnection is used to specify the connection that is to be used with the command. You set this to an existing Connection object or you specify a connection string for a new connection to be used with the command.
• CommandText contains the text of the command, usually an SQL statement.
• CommandTimeout contains the timeout value that is used for this command.
• CommandType specifies the type of the command, which can be a text command—such as a complete SQL statement—a table name, or a stored procedure.
• Prepared specifies whether the command will be prepared prior to the first execution.

ADOCommand objects also include an ADOParameters collection, which is used to work with values passed between the Command object and procedure calls or parameterized commands, and an ADOProperties collection containing specific characteristics of the command.

ADOCommand Methods

All ADOCommand objects also support the following methods:

• CreateParameter is used to create a new Parameter object for use with the command.
• Execute executes the command against the data source.

Share This