Click here to Skip to main content
Click here to Skip to main content

Building a Database Application using OLE DB

, 11 May 2004
Rate this:
Please Sign up or sign in to vote.
An article on building a Database Application with OLE DB

Introduction

This article, hopefully will show you how to build a database application with OLE DB. I have tried to make database applications using different ways, like ODBC, ADO, and now OLE DB. Let's get started!

Using the code

We will be needing a database for this tutorial. That's why, I have included a very simple sample of it (data.mdb). You will need to set up a ODBC data source for this. In this article, we will be using an ATL object, you can select it from Insert > New ATL Object > Data Access > Consumer. It will ask you for a data source, select the data source which you have made with ODBC. Because we will be making some changes on the database, check the Change, Insert, Delete support. Click OK and that choose the employee table.

Until now, you haven't write any single code, but actually you have done quite a lot. The wizard will create two class:

  • CEmployee
  • CEmployeeAccessor

You will do a lot on the CEmployee class, like viewing record, adding, and delete.

To access a record, you can write something like this:

CEmployee data;
data.m_id; //to access the id field in employee

To move a record:

CEmployee data;
data.MoveNext();
data.MovePrev();
but before that, you need to set the Database Property Set, so that the MovePrev() will work. Add the code as follow:
CDBPropSet propset(DBPROPSET_ROWSET);
propset.AddProperty(DBPROP_CANFETCHBACKWARDS, true); 
  //add this code to set DBPROP_CANFETCHBACKWARDS to true
propset.AddProperty(DBPROP_IRowsetChange, true);
propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE 
  | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);
From the parameter DBPROP_CANFETCHBACKWARDS, you can see that the Record Set can move backward, if it is set to true.

To add a record

CEmployee data;    
strcpy(data.m_id,"3"); //set the id field with "3"
strcpy(data.m_name,"Tony"); //set the name field with "Tony"
data.Insert(); //this will be added as the last record 

To update a record

CEmployee data;
strcpy(data.m_id,"3"); //set the id field with "3"
strcpy(data.m_name,"Tony"); //set the name field with "Tony"
data.SetData(); //Update the record

To delete a record

CEmployee data;
data.Delete();

That's it, you have just made yourself a simple database application using OLE DB. Pretty simple huh, but beyond that, it's not that simple.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Yulianto

United States United States
No Biography provided

Comments and Discussions

 
QuestionIt seems some wrong with it Pinmemberpigkiller129-May-07 18:54 
GeneralInserting BLOB graphic files into a Word doc Pinmembermckly30-Jun-04 5:27 
GeneralInstructions on Using Code PinmemberYogesh Kshatriya18-Jun-04 1:51 
GeneralYou should have labelled your article ... PinmemberWREY13-May-04 2:30 
GeneralRe: You should have labelled your article ... Pinmembergoodmast3r17-May-04 22:36 
GeneralComments in code PinmemberDaniel Desormeaux12-May-04 10:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.1411022.1 | Last Updated 12 May 2004
Article Copyright 2004 by Yulianto
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid