CodeGuru Staff

MS Access (.mdb) is not the only data source you can use as a DAO database. Many other types can be opened directly without ODBC. The secret lies in the parameters passed to CDaoDatabase::Open(). If you’re opening an Access file, you can omit all but the first parameter: CDaoDatabase db; db.Open(“c:\test.mdb”); But there are three […]

This sample was contributed by Adrian Roman. It took me some time to notice all this, and because I couldn’t find anywhere documentation about DBGrid unbound programming in VC++ (only in VB), I think that will be nice to share my observations with others. First, even documentation says that it accepts (almost) any type of […]

The GenericRecordset is a simple wraper for DAO recordset that simplifies the use of the CDaoRecordset::GetFieldValue() function. It allows you to create a recordset based on a query, and recrieve the resulting set using the following functions: GetCString() GetShort() GetLong() GetDouble() GetFloat() GetDate() (this is a COleDate) GetColumn() (this is a VARIANT) GetOleColumn() (COleVariant) (new) […]

. Download sample project Looks like DAO 3.5 has some support for multi-threading. As stated by the MFC 4.2 documentation, the Dao database classes are not thread-safe, and that is indeed true. I recently developed a server application the uses IO completion ports, which by nature, are using a number of threads. Because of that, […]

The following code is a modified version of the MFC source for RFX_Date, instead of the crippled CTime, I use COleDateTime. This avoids the annoying 1970 – 2038 year limits (COleDateTime can handle years 100-9999) of the CTime object and a COleDateTime is a lot nicer to deal with than a TIMESTAMP_STRUCT. All I do […]

This example illustrates how to use an Access database file with an IE 4.0 virtual list view. Download sample project 63KB. Loading large amounts of data into a CListView derived class is a very slow process, even when the data is maintained in memory. Accessing data in a database slows the process down even further. […]

As you are already aware, the tree view control can display two images for each item. Each of these two images belong in different image list controls that have to be associated with the tree control. Whereas, an item can have upto 256 item images, it can only have 15 state images. Nevertheless, the programming […]

The tree view control can display two images for each item in the control. The primary image is generally known as the item image and is immediately to the left of the item label. The secondary image is the state image and is to the left of the item image. To setup the item images, […]

The tree view in conjunction with the image list allows upto four overlay images. Overlay images are images that are drawn transparently over another image. The overlay images are supported only for the item images and not for the state images. Unlike what the documentation says, you can choose any image in the image list […]

In my programming, I have often had to derive the last item in a branch. In fact some of the other topics I cover, uses this function to get the last item in the branch.   // GetLastItem  – Gets last item in the branch // Returns      – Last item // hItem        – Node identifying […]

The tree view control does not have any built-in method for searching the entire tree for a label that contains a given sub-string. The GetItem() function listed below takes a sub-string to search for and searches the item labels for this sub-string. It also has arguments to specify whether to do a case sensitive search, […]

Imagine that the outline is completely expanded. Pressing the down key will take you down on line to the next item. Now imagine that instead of expanding the outline and pressing the down key, you want to get to the items in the same sequence programmatically. Although the CTreeView control provides a GetNextItem() function, it […]