Using the Flexgrid in VC++ 中文版 英文版

Using the Flexgrid in VC++ 作者：VGirish 翻译：胡盼（翻译得很粗糙，大家见谅） Introduction

介绍 When I had to use the flexgrid for the first time, I was too frustrated to find out that no proper documentation existed on the net. The ones available were too complicated for me to understand. And the ones that were easy were in VB. This article is to help persons who are going to use the flexgrid in their applications using VC++. Also take a look at the Warning note at the end of this article.

当我第一次不得不使用flexgrid控件时，发现在互联网上没有相关的合适的文档时，让我很困扰。而那些可利用的对我来说，又太复杂。于此同时，在VB中的flexgrid控件的文档又十分简单。本文档是帮助那些想在自己用VC++摆弄些的程序中使用flexgrid控件的人们。注意阅读以下文章结尾的注意事项。

Implementation

实现过程 Step 1 First, include the msflexgrid control in the project. To do that :- 1. In the VC++ IDE Menu, go to Project->Add To Project->Components and Controls menu. 2. Then , in the dialog box that appears, select Registered ActiveX Controls. There, You can see a control named "Microsoft Hierarchical FlexGrid Control...". 3. Select that and add it to your project using the Insert button. You can now see the FlexGrid control in the resource editor's CONTROLS toolbar. 4. Add it to your dialog as you add a control usually. 第一步 1.在VC++的编译器的菜单栏，选择 工程->增加到工程-> Components and Controls

2.然后，在出现的查找文件对话框中，选择Registered ActiveX Controls，这儿，你会看到一个名称为”Microsoft Hierarchical FlexGrid Control...”的控件

3.选中它，并通过单击插入按钮，将它增加到你的工程中。你会发现FlexGrid控件出现在资源编辑工具栏的下方。

4.这样你就可以在你的对话框中使用FlexGrid控件了，就像使用普通的控件一样。

Step 2 Then, set the properties as you want it to be. Right click on the grid and select the Properties option. Change the settings there as per your requirements.

第二步 接着，按照自己的要求设置FlexGrid控件的属性。右击网格并选择属性选项。按照个人的要求，改变该控件的属性。

Step 3 Add a member variable for that grid. E.g. de>m_Gridde>. The sample given below is for an example. Use it as a guideline to make your application.

第三步

给FlexGrid控件增加一个想关联的成员变量，例如m_Gridde, 以下给出一个例

子。使用该例子作为一个指导准侧来编写你的程序。

Step 4 Its better to clear the flexgrid before you do any operations on it. To do that, use :- 第四步 最好在你对FlexGrid控件进行任何操作之前，先清空它。像这样做:- m_Grid.Clear();

Step 5 To add records to the Grid, use something like this. 第五步 给你的网格控件（FlexGrid控件）中添加一些数据，像这样： CString strName,strRemarks; m_nCount = 0;

// Clear and refresh the grid //清除并且刷新FlexGrid控件

m_Grid.Clear(); m_Grid.Refresh();

// Get the value for strName from the database here //从数据库中获取数据，并将获取的数据赋给strName // Get the strRemarks from the database here //从数据库中获取数据，并将获取的数据赋给strRemarks

m_nCols = m_Grid.GetCols(); m_Grid.SetTextArray(0, "Name " ); // First Column //第一列

m_Grid.SetTextArray(1, "Remarks " ); // Second Column //第一列

m_nCount++; // Fill First Column //填充第一列数据

m_Grid.SetTextArray( m_nCols * m_nCount + 0,strName ); // Fill Second Column //填充第二列数据 m_Grid.SetTextArray( m_nCols * m_nCount + 1, strRemarks );

// Redraw the grid //重绘网格控件 m_Grid.SetRedraw(TRUE); m_Grid.Refresh();

Step 6 To retrieve data from the Grid when the user double clicks on a record, add a double click message handler for the grid using the class wizard. Assuming that you have named the function as de>OnDblClickGridde>, then :-

第六步 当用户双击一个记录时能从网格控件中获取数据，首先得通过建立类向导（class wizard）给网格控件增加一个双击的消息处理函数，假设你已经把该函数命名为 OnDblClickGridde，那么：

void YourDialog::OnDblClickGrid() { // Get the current row and column //获取当前的行号和列号 int nRow = m_Grid.GetRow(); int nCol = m_Grid.GetCol();

CString strName,strRemarks;

// Get data from the First Column //从第一列获取数据 strName = m_Grid.GetTextMatrix(nRow,nCol+0); // Get data from the Second Column //从第二列获取数据 strRemarks = m_Grid.GetTextMatrix(nRow,nCol+1); }

Step 7 To move to the previous record, do this :- 第七步 移到前一条记录，需要这样做： void YourDialog::OnBtnPrevious() { m_Grid.SetRedraw(FALSE);

// Get the current selection //获取当前的选择项

int NextRow = m_Grid.GetRowSel();

// If the position is at the last record, return //如果你当前的位置是最后一条记录，那么返回 if(NextRow <= 1) { return; } else { long BackColor[2],FontColor[2];

int Column;

// The BackColor and the FontColor variables // are manipulated because we want a // selected effect to be given to the previous // record. Here, we are merely changing // the color of the selected // row to give it that effect. // 背景色和前景色的变量的值被修改，因为我么需要选中的行影响到它先前的记录，这里，我们仅仅改变选中行的颜色 BackColor[0] = 0x00FFFFFF; BackColor[1] = 0x00FFFFB0;

FontColor[0] = 0x00400000; FontColor[1] = 0x000000FF;

for(Column = 1; Column < m_Grid.GetCols(); Column++) { m_Grid.SetCol(Column); m_Grid.SetCellBackColor(BackColor[0]); m_Grid.SetCellForeColor(FontColor[0]); }