Microsoft KB Archive/225065

= PRB: Cannot Manipulate Columns of MS DataGrid in Visual C++ at Design Time =

Article ID: 225065

Article Last Modified on 3/27/2002

-

APPLIES TO


 * Microsoft Visual C++ 6.0 Enterprise Edition

-



This article was previously published under Q225065



SYMPTOMS
Microsoft DataGrid version 6.0 does not support modifications to the columns of Grid at design time when using it in Visual C++.



RESOLUTION
You can manipulate the columns of DataGrid programmatically at run time. The sample code below shows how to add/remove a column, and modify the column's caption when using ADO data control and DataGrid with an MFC CVCDataGridDlg class.

Insert the following variables and member function prototypes in the corresponding dialog class declaration:
 * CDataGrid m_Grid; // DataGrid variable.
 * CAdodc m_DataControl; // ADO Data Control variable.
 * void OnAdd // Function for adding a column.
 * void OnRemove // Function for removing a column.
 * void OnModify // Function for modifying a column.

Sample Code
//implementation
 * 1) include "columns.h"   // CColumns collection object header file.
 * 2) include "column.h"    // CColumn object header file.
 * 3) include "_recordset.h" // C_Recordset object header file.
 * 4) include "fields.h"    // CFields collection object header file.
 * 5) include "field.h"     // CFields object header file.
 * 6) include 

// Adding a column. void CVCDataGridDlg::OnAdd {  //Get the total number of columns. short i = (short)(m_DataGrid.GetColumns.GetCount); //Insert the new column. m_DataGrid.GetColumns.Add(i); CString rCaption; GetDlgItemText(IDC_EDIT2,rCaption); //Set the caption of the column. m_DataGrid.GetColumns.GetItem(_variant_t(i)).SetCaption((LPCTSTR)rCaption); m_DataGrid.Refresh; }

// Removing a column. void CVCDataGridDlg::OnRemove {  m_DataGrid.GetColumns.Remove( _variant_t((long) atoi(m_Edit.GetBuffer(m_Caption.GetLength) ))); m_DataGrid.Refresh; }

// Modifying a column caption. void CVCDataGridDlg::OnModify {  CString rCaption, rColNum; GetDlgItemText(IDC_EDIT1,rColNum); GetDlgItemText(IDC_EDIT2,rCaption); m_DataGrid.GetColumns.GetItem(_variant_t((long) atoi(rColNum))).SetCaption((LPCTSTR) rCaption); m_DataGrid.Refresh; }



STATUS
The behavior is by design.



Step to Reproduce the Problem

 * 1) Create an MFC Appwizard Project.
 * 2) Insert a Microsoft ADO Data Control, version 6.0 (OLEDB).
 * 3) Insert a Microsoft DataGrid Control, version 6.0 (OLEDB).
 * 4) Right-click the DataGrid control.

RESULTS: Note that the "Edit" option for making changes to the columns of DataGrid at design time is absent. This option is available in Visual Basic 6.0.

Keywords: kbdatabase kbprb kbpending KB225065

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.