Database Connectivity in VC++ .

MFC supports two different kinds of database access :-
* Access via Data Access Object (DAO) and the Microsoft Jet Data engine.
* Access via Open Database Connectivity (ODBC) and an ODBC driver.

      A DAO database object, represent in MFC by class CDAODatabase, represents a connectionto a database through which we can operate on data.  We can have one or more CDaoDatabase objects active at a time in  given work space represented by a CDaoWorkspace object
In ADO
-- Each work space object contains a collection of open databases objects called database collection.
-- Each DAO database Objects contains collection of tabledefs, recordsets and relations.
      In MFC, access to a workspace's database collection is through member functions of class CDaoWorkspace.  Access to a database objects is through member functions of class CDaoDatabase.

Accessing ( Database object) without DAO

 # Connecting to Database in VC++ ( using DAO )

• Create the VC++ application using MFC Appwizard
• In step2 of Appwizard, ( in answer to the question what database support would you like to include) click the radio button labelled database view file support.
•  Next, click the button labelled "Data Source" open the Database option box.
• Select the DAO button, and then specify the database name as our data source, click ok.  When the select Database Table window appear click on select the table ( name student ) and then click on ok button.
• Now, we click the ok button and the Finnish button in Appwizard, letting Appwizard to create the new program.
• This creates a program whose view class based on the CDaoRecord view class, which in turn is based on CFormView class.
• Open the main view, IDD_DB_FORM, in the dialog editor and add the controls we need two text boxes - one for name and other for grade and a button with the caption " Display the current record field".

• email
• facebook
• linkedin
• twitter
• reddit
• google+