Data Access (How Do I in Visual C++)

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.

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.

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++.

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 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.

Concepts

Other Resources