ADOÏòACCESSÊý¾Ý¿â²åÈëÊý¾ÝÎÊÌ⣬¾È¼±

m_PriceÊÇfloatÐÍ
m_MonthÊÇctimeÐÍ
ÆäËüÊÇcstringÐÍ
´íÎóÌáʾ£ºµ¯³ö´íÎó¶Ô»°¿ò£¬×××.exe£­Ó¦ÓóÌÐò´íÎ󣬡­¡­¡­¡­¡­¡­¸ÃÄÚ´æ²»ÄÜΪ"read"
¸ßÊÖ¼±¾È¡«¡«¡«¡«µ½µ×Ó¦¸ÃÈçºÎд

C/C++ code:

void CDailyAccountDlg::OnAdd()
{

UpdateData();

CString sql;

CoInitialize(NULL);

_ConnectionPtr pCon(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));

try
{
pCon->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dailyAccount.mdb", "", "", adConnectUnspecified);
try
{
sql.Format("insert into daily(category,event,price,describe,date)values('%s','%s','%d','%s',#%s#)",csg_Category,csg_Event,m_Price,m_Desc,m_Month);
pRst->Open((_bstr_t)sql, _variant_t((IDispatch*)pCon), adOpenDynamic, adLockUnspecified, adCmdText);
}
catch(_com_error e)
{
AfxMessageBox("Êý¾Ý²åÈëʧ°Ü!");
}
}
catch(_com_error e)
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü!");
}

pRst->Close();
pCon->Close();
pRst.Release();
pCon.Release();
CoUninitialize();
}

---

ÄãcatchµÄʱºò¾Í²»ÄÜ°Ñ´íÎóÐÅÏ¢ÏÔʾ³öÀ´Âð?
C/C++ code

---

Code highlighting pro