//在stdaxh.h引入ADO支持库
#import "c:\program files\common files\system\ado\msado15.dll" \
no_namespace \
rename("EOF", "adoEOF")
dialog中
//检查是否创建access数据库
CString m_str = "";
m_str.Format("\\Alarm.mdb");
CString strPath = Getpath() + m_str;
CFileFind m_FileFind;
if (!m_FileFind.FindFile(strPath))
{
MessageBox("文件不存在", "提示", MB_OK | MB_ICONHAND);
}
//将连接数据的字符串先写好
#if defined _WIN64//如果是64位程序
m_csConnection.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%s", strPath);
#elif defined _WIN32//如果是32位程序
m_csConnection.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s", strPath);
#endif
CoInitialize(NULL);//初始化窗口
HRESULT hr;
try
{
hr = m_pConnection.CreateInstance(__uuidof(Connection));
if (SUCCEEDED(hr))
{
m_pRecordset.CreateInstance(__uuidof(Recordset));
}
}
catch (_com_error* e)
{
AfxMessageBox(e->ErrorMessage());
}
//增加数据
CString sqlstr;
sqlstr.Format("Insert into alarm (日期,时间,错误代码,提示等级,模块分类,错误信息) values('%s','%s','%s','%s','%s','%s')", "1", "1", "1", "1", "1", "1");
try
{
HRESULT hr = m_pConnection->Open(_bstr_t(m_csConnection), "", "", adModeUnknown);
if (SUCCEEDED(hr))
{
m_pConnection->Execute(_bstr_t(sqlstr), NULL, adCmdText);
}
}
catch (_com_error e)
{
AfxMessageBox(sqlstr + _T(" 增加记录失败!!!"));
}
m_pConnection->Close()