//连接数据库
_ConnectionPtr m_pConnection;
if (CoInitialize(NULL)!=0)
{
//MessageBox(_T("初始化失败!"),MB_OK);
exit(1);
}
try
{
//连接access数据库
m_pConnection.CreateInstance("ADODB.Connection");
//低版本access
//m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PictureInfo.mdb","","",adModeUnknown);//data source 根据自己的数据库名字进行更改,不写路径的话要把数据库放在工程目录下。
//access2010
m_pConnection->Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=PictureInfo.accdb","","",adModeUnknown);
}
catch (_com_error e)
{
AfxMessageBox(e.Description());
}
//设置记录集
_RecordsetPtr m_pRecordset;
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM info",_variant_t((IDispatch*)m_pConnection,true),
adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset->AddNew();///插入新记录
//设置记录各个元素的值,下面只列举一例
m_pRecordset->PutCollect("name",name);
m_pRecordset->Update(); //更新表内记录
//关闭连接
CoUninitialize();
m_pRecordset->Close();
m_pConnection->Close();