<< Return to Main Index

< Return to Class Index

class CGXDaoGrid: public CGXBrowserGrid

The CGXDaoGrid class provides functionality for browsing MS Access databases. As for any CGXBrowserGrid-derived class, this class lets you create MS-Query-like views where you can browse MS Access tables or querydefs.

The CGXBrowserGrid class maintains one current record with the current cell.  When the user edits data in the current record, all changes are stored in an internal buffer.  When the user moves the current cell to another record, changes for the current record are written to the attached CDaoRecordset before the current cell is positioned to a new record.  When the user clicks on the last row, a new record will be added to the CDaoRecordset (if it supports appending records).

The state information of the CGXDaoGrid class is stored in the CGXDaoParam class. CGXDaoParam can be shared among several views (works the same way as CGXGridParam). You can embed it in a document if you want to support several browse views on the same data, as for example in a dynamic splitter window. The DaoQuery sample shows how to derive a view from CGXDaoGrid and how to add support for serializing the scheme information of the grid.

CGXDaoGrid is not derived from CWnd. The CGXDaoRecordView class represents the CGXDaoGrid as view. The CGXDaoRecordWnd class represents the CGXDaoGrid as control.

Note: You should turn off the CDaoRecordset double-buffering mechanism for the CDaoRecordset that you want to display in the grid. CGXDaoGrid will manually call SetFieldDirty / SetFieldNull. Therefore, this CDaoRecordset feature is obsolete and will only slow down performance. If you do not depend on this feature for any other reasons, you should set the CDaoRecordset attribute

   m_bCheckCacheForDirtyFields = FALSE;

It makes no difference if you change this attribute before or after opening or initializing the CDaoRecordset.

#include <gxdao.h>

See Also

CGXDaoParam CGXBrowserGrid CGXDaoRecordWnd CGXDaoRecordView

CGXDaoGrid

Class Members