Data Access (How Do I in Visual C+)

This page links to help on tasks related to data access using Visual C++. To view other categories of popular tasks covered in Help, see How Do I in Visual C++.

Programming

• Data Access Programming
  Describes the several ways to work with databases.

• Installing Database Support
  Describes the database components that are installed automatically with Visual C++.

• Record (Data Access)
  Describes a record, a collection of data about a single entity, such as an account or a customer, stored in a table (a row of the table).

• Schema (Data Access)
  Describes how a database schema describes the current structure of the tables and database views in the database.

• Catalog Information
  Describes what information can be stored in a table in a data source, such as the names of tables and the columns in them, table privileges, names of primary and foreign keys, information about predefined queries or stored procedures, information about indexes on tables, and statistics about tables.

• Transactions
  Describes transactions, a series of operations performed on a database.

• Record Views
  Describes the classes that MFC provides to access record views.

• Data Access Frequently Asked Questions
  Provides answers to the most frequently asked questions about data access.

ADO.NET

• Data Access Using ADO.NET (C++/CLI)
  Provides an overview of using ADO.NET in Visual C++.

• How to: Marshal ANSI Strings for ADO.NET (C++/CLI)
  Demonstrates how to add a native string (char *) to an ADO.NET database and how to marshal a System.String from an ADO.NET database to a native string.

• How to: Marshal BSTR Strings for ADO.NET (C++/CLI)
  Demonstrates how to add a COM string (BSTR) to an ADO.NET database and how to marshal a System.String from an ADO.NET database to a COM string.

• How to: Marshal Unicode Strings for ADO.NET (C++/CLI)
  Demonstrates how to add a Unicode string (wchar_t *) to an ADO.NET database and how to marshal a System.String from an ADO.NET database to a Unicode string.

• How to: Marshal a VARIANT for ADO.NET (C++/CLI)
  Demonstrates how to add a VARIANT to an ADO.NET database and how to marshal a System.Object from an ADO.NET database to a VARIANT.

• How to: Marshal a SAFEARRAY for ADO.NET (C++/CLI)
  Demonstrates how to add a SAFEARRAY to an ADO.NET database and how to marshal an array from an ADO.NET database to a SAFEARRAY.

• ADO.NET Code Examples
  Demonstrates how to return results from a data source and write the output to the console or command prompt.

ADO

• Data-Bound Controls (ADO and RDO)
  Describes databinding, a mechanism that allows users to work with data retrieved from a database.

• Data Access: ADO and RDO
  Summarizes the two underlying technologies that support data-source or data-bound controls.

• ADO Databinding
  Discusses the use of the databinding ActiveX controls that are built with ADO.

• Using ADO Databinding in Visual C++
  Describes the steps needed to use ADO databinding in Visual C++.

• Inserting the Control into a Visual C++ Application
  Describes how you can insert an ActiveX control into a dialog box from the toolbar or using the Insert ActiveX Control dialog box

• Setting Control Properties at Design Time
  Shows how to set properties of controls at design time using the Dialog editor.

• Updating Data with the ADO Data Control
  Describes how to create an application that modifies data using ADO data control.

• Using ADO Databinding in Visual C++
  Shows how to use ADO databinding in Visual C++.

ODBC

• Open Database Connectivity (ODBC)
  Provides an overview of the classes that the Microsoft Foundation Classes (MFC) library supplies for programming with Open Database Connectivity (ODBC).

• Installing and Getting Started with ODBC
  Helps you install the components needed to start working with Open Database Connectivity (ODBC).

• Design and Create an ODBC Database Application
  Helps you design and set up an ODBC database application.

• ODBC Basics
  Provides the basics of Open Database Connectivity (ODBC).

• ODBC and MFC
  Introduces the main concepts of the Microsoft Foundation Classes (MFC) library's ODBC-based database classes and provides an overview of how the classes work together.

• ODBC Connections
  Describes how to configure an ODBC data source.

OLE

• OLE DB Programming
  Represents the starting point for information about the Microsoft OLE DB database technology and the OLE DB Template Library.

• OLE DB Programming Overview
  Describes what OLE DB is, and what makes it distinct from other database technologies.

• OLE DB Consumer Templates (C+)
  Lists the OLE DB Consumer Templates that the OLE DB version 2.6 specification supports.

• OLE DB Provider Templates (C+)
  Describes the OLE DB Provider and describes what services they must support.

• ATL Database Classes (OLE DB Templates)
  Describes the templates in ATL that make the high-performance OLE DB database technology easier to use by providing classes that implement many of the commonly used OLE DB interfaces.

• Debugging Your Provider
  Lists the two ways to debug your provider.

• Dynamically Binding Columns in Your Provider
  Describes how to implement dynamic column binding.

• Fetching Data
  Describes how to fetch data after you open the data source, session, and rowset objects.

• Testing the Read-Only Provider
  Creates a default MFC Application Wizard application for a test consumer. The test application is a simple dialog with OLE DB consumer template code added.

• Using Multiple Result Sets from One Stored Procedure
  Shows how to handle multiple result sets.

• Using the OLE/COM Object Viewer
  Describes how to use the OLE/COM Object Viewer.

See Also

Concepts

How Do I in Visual C++

Other Resources

ADO.NET