Visual C++ and ADO

Using Microsoft® Visual C++® with ADO is a powerful solution for writing data access applications for Microsoft SQL Server™. If you are interested in using Visual C++ and ADO to develop a SQL Server application, you should note the following:

• In Visual C++, you need to use the #import Compiler COM statement to import the Msado15.dll before using ADO.
• With ADO 2.0, converting data in Visual C++ applications has been simplified.

  ADO provides an interface, IADORecordBinding, that supports retrieving data into native C/C++ data types without going through a VARIANT data type, and also provides preprocessor macros that simplify using the interface. The interface has methods to associate ADO Recordset fields with C/C++ variables, add new rows, and perform updates.

• Visual C++ version 6.0 includes the ADO Data Control and a number of other databound controls that you can use to visually design Microsoft Win32® dialog boxes that use ADO.

  The controls are Microsoft Visual Basic® controls that you can program in Visual C++.

• The Component Gallery contains the ADO Data Bound Dialog Wizard, which guides you through the process of creating a Microsoft Foundation Class Library (MFC) data bound dialog box with ADO.

  The controls of the dialog box bind to the fields of a recordset. Using the wizard, you can automatically generate all of the resources, classes, and Component Object Model (COM) initialization code necessary to build a data bound dialog box and add it to your project.

For more information on using Visual C++ with ADO, see the MSDN™ Library, Microsoft Visual Studio® version 6.0 edition.