1
void CTestdbDlg::OnOK()
2
{
3
// TODO: Add extra validation here
4 //AfxOleInit();
5 CoInitialize(NULL); //初始化
6 //打開數據庫
7 _ConnectionPtr m_pConnection;
8 try
9
{
10 m_pConnection.CreateInstance("ADODB.Connection");
11 // ASSERT(m_pConnection != NULL);
12 _bstr_t strConnect="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;Persist Security Info=False";
13 m_pConnection->ConnectionTimeout=5; //設置超時時間為5秒
14 m_pConnection->Open(strConnect,"","",adModeUnknown);
15
}
16 catch(_com_error e)
17 {
18 AfxMessageBox(e.ErrorMessage());
19 }
20 _RecordsetPtr m_pRecordset; //一個指向Recordset對象的指針
21 //查詢
22 CString sql="select sno From [sn] ";
23 try
24 {
25 m_pRecordset.CreateInstance(__uuidof(Recordset));
26 m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
27 while(!m_pRecordset->GetadoEOF())
28 {
29 _variant_t var;
30 var=m_pRecordset->GetCollect("sno");
31 if(var.vt != VT_NULL)
32 {
33 CString strValue =(LPCSTR)_bstr_t(var);
34 MessageBox(strValue);
35 }
36 m_pRecordset->MoveNext();
37 }
38 }
39 catch(_com_error e)/**////捕捉異常
40 {
41 AfxMessageBox(e.ErrorMessage());
42 AfxMessageBox(e.Source());
43 AfxMessageBox(e.Description());
44 }
45 //更新
46 _bstr_t sql2="update [sn] set name='sss' where sno=3";
47 _variant_t RecordsAffected;
48 m_pConnection->Execute(sql2,&RecordsAffected,adCmdText);
49 m_pRecordset->Close();/**////關閉記錄集
50 m_pConnection->Close();/**////關閉連接
51// AfxOleTerm();
52 CoUninitialize();
53
54
}
在連接數據庫之前要添加#import "C:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF","adoEOF")
路徑根據本機設置修改
rename("EOF","adoEOF") //重新命名