VC++ 中MSDataGrid控件的使用

- 日理万妓 2022-08-28 10:57 236阅读 0赞

VC 6.0；新建一个对话框工程；

在对话框中插入ActiveX控件；没有；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_12_color_FFFFFF_t_70_g_se_x_16][]

下载；包含如下三个文件；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_12_color_FFFFFF_t_70_g_se_x_16 1][]

OCX和DLL放到System32目录；注册；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_15_color_FFFFFF_t_70_g_se_x_16][]

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_17_color_FFFFFF_t_70_g_se_x_16][]

再插入，有了；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_13_color_FFFFFF_t_70_g_se_x_16][]

放一个datagrid控件到对话框界面；数据库文件在项目文件夹下；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_18_color_FFFFFF_t_70_g_se_x_16][]

在stdafx.h中加入下图\#import一句；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16][]

在类向导中为datagrid控件添加成员变量；弹出下图提示；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 1][]

确定；弹出下图；点OK；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_13_color_FFFFFF_t_70_g_se_x_16 1][]

输入DataGrid控件的成员变量名称；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_12_color_FFFFFF_t_70_g_se_x_16 2][]

对话框类添加了一个成员变量；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 2][]

自动生成的代码如下；该成员变量加到对话框类的头文件中；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_19_color_FFFFFF_t_70_g_se_x_16][]

工程中将添加如下文件；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_9_color_FFFFFF_t_70_g_se_x_16][]

运行一下程序；出现下图错误；

![9b5af3bea60648b0b0be921ebcd14110.PNG][]

![88a6e0d5821446bd97d3bab4a26fde43.PNG][]

在项目设置中下图位置，选择静态链接；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 3][]

在对话框的初始化成员函数添加如下代码；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 4][]

所添加的代码；

// TODO: Add extra initialization here
    	_RecordsetPtr m_Precord;
    	_ConnectionPtr m_Pconn; 
    
    	try
    	{
    		m_Pconn.CreateInstance(__uuidof(Connection));
    		CString SQL=_T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=英语.mdb");
    		m_Pconn->Open((_bstr_t)SQL,(_bstr_t)_T(""),(_bstr_t)_T(""),adModeUnknown);
    	}
    	catch(_com_error e)
    	{		
    		MessageBox(e.ErrorMessage(),_T("连接错误"),MB_OK|MB_ICONERROR);
    	}
    	try
    	{
    		m_Precord.CreateInstance(__uuidof(Recordset));
    		CString SQL = _T("select * from ENG");
    		m_Precord->CursorLocation = adUseClient;
    		m_Precord->Open((_variant_t)SQL,_variant_t(m_Pconn,true),adOpenStatic,adLockOptimistic,adCmdText);
    		m_datagrid1.SetCaption(_T("英语"));
    		int nrow = m_Precord->GetRecordCount();   
    		int ncol = m_Precord->GetFields()->Count;   
    		m_datagrid1.SetRefDataSource((LPUNKNOWN)m_Precord); 
    		m_datagrid1.Refresh(); 
    	}
    	catch(_com_error e)
    	{	
    		MessageBox(e.ErrorMessage(),_T("连接错误"),MB_OK|MB_ICONERROR);
    	}

运行程序；结果如下图；

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_14_color_FFFFFF_t_70_g_se_x_16][]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_12_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/c1ff573cdfac48f99b3513a3060a5458.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_12_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220828/9ec7c6d47e87411095424cc92b5c5473.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_15_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/0b7292c461e0431a9f72313835c1dc71.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_17_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/b1c0af313a8d4afe8ac765c901f97ed7.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_13_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/32019e55a1574831be96028516a21405.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_18_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/5c9ed65a8096408baf443eef5001f7a3.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/0d2fbfe5893745b7a4ad49cde04d13f3.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220828/36e4bf16c7e748cdade3c2a6f99b86ac.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_13_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220828/a9580feca8bc4571ae1b3521c564ca52.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_12_color_FFFFFF_t_70_g_se_x_16 2]: /images/20220828/7f8a9eaac9114d95b7af979e595e1cb6.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 2]: /images/20220828/13fc25b396524caf8cd349dca528bc63.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_19_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/16c443034bf244a39be7061f9c075a43.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_9_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/1ab95f256f9f4c41b30c746c50ab4852.png
[9b5af3bea60648b0b0be921ebcd14110.PNG]: /images/20220828/017267ade0a94210960b4f8377faad65.png
[88a6e0d5821446bd97d3bab4a26fde43.PNG]: /images/20220828/471f3327bf1f4195ac22d34e62553b4a.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 3]: /images/20220828/2781b34799174952a06d236e629f731f.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_20_color_FFFFFF_t_70_g_se_x_16 4]: /images/20220828/69c56e0be44a4f828d51111c1ed8eff0.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYmNib2JvMjFjbg_size_14_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/2e8e37b796594a91b997c7ca4c6e2870.png