Example DataShape:

        Microsoft provides us a special data accessing service, Data Shaping Service for OLE DB, which allows an application to create relationships that maybe had not previously existed between keys, fields, or rowsets. It also supports the dynamical construction of hierarchical rowset objects from your data provider. This service can be used with a treeview control. It is pretty easy to use it with the help of ADO. However, it is not friendly to use with OLEDB interfaces directly. You may research to find very few peaces of codes to tell you how to use this special service.

        Fortunately, OleDBPro provides a template called as CChapterRecord<T> to dramatically simplify the use of data shaping service. You can even update records through this service. This example lets you know the following how-tos.

1. How to extend CRBase::QueryColsInfo() to set data types for simplifying accessing data.

2. How to build relationships (parent, child, grandchild, ......) among rowsets.

3. How to open a chaptered rowset with MS Data Shaping service.

4. How to deal with data.

5. How to free the resource associated with a chapter.

        You are encouraged to experiment an article at MS Support web entitled as HOWTO: Create Hierarchical Recordsets from an Oracle Stored Procedure with CChapterRecord<T>. It is simple but interesting.

Goto the list of examples