MFC如何联接ACCESS数据库 我只想联接数据库后 实现简单的插入 删除 查找等功能怎么实现呀 我是新手 如果谁能给全代码(最好有注释的)就给他100分分不够可以再加 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 support.microsoft.com/kb/220152www.codersource.net/ado_mfc_clistctrl.html -There is no ADO in MFC, only DAO, but DAO is now obsolete. ODBC, ADO, DAO都可以。找本讲数据库编程的书。 _ConnectionPtr pConn; _RecordsetPtr pRst; _CommandPtr pCmd;HRESULT hr; try {// hr = pConn.CreateInstance(__uuidof(Connection)); ///创建Connection对象 hr = pConn.CreateInstance("ADODB.Connection"); if(SUCCEEDED(hr)) {// adModeUnknown // hr = pConn->Open("FileDSN=asas.dsn","","",0); hr = pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=netChat.mdb","","",adModeUnknown); pRst.CreateInstance("ADODB.Recordset"); pCmd.CreateInstance("ADODB.Command"); pConn->Close(); } } catch(_com_error e) { CString err; err.Format("数据库错误信息:%s",e.ErrorMessage()); AfxMessageBox(err); if(pRst!=NULL) { if(pRst->State) pRst->Close(); pRst.Release(); } if(pConn!=NULL) { if(pConn->State) pConn->Close(); pConn.Release(); } if(pCmd!=NULL) pCmd.Release(); SendMessage(WM_CLOSE); } pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=netChat.mdb","","",adModeUnknown); pRst->Open("update primary_table set is_online=false",_variant_t((IDispatch*)pConn,TRUE), adOpenStatic,adLockOptimistic,adCmdText); //update if(pRst->State) pRst->Close(); if(pConn->State) pConn->Close();BSTR bstrSQL; sqlcmd.Format("select * from primary_table where ID=%d",dwID); bstrSQL=sqlcmd.AllocSysString(); pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=netChat.mdb","","",adModeUnknown); pRst->Open(bstrSQL,_variant_t((IDispatch*)pConn),adOpenDynamic ,adLockBatchOptimistic ,adCmdText); //select if(pRst->State) pRst->Close(); if(pConn->State) pConn->Close();代码很乱.....反正差不多是这意思 完整例子:http://www.vckbase.com/document/viewdoc/?id=496 因为老师要求看着书上的自己做了个基于Access的学生信息管理的要的话给你全部代码 to Tll_W() ( )好呀 发我邮箱里吧 [email protected] 哎 zhucde(【風間苍月 的连接怎么打不开呀 校园网真是慢呀 CSDN我用了半个小时才打开... case DATABASE_SERVER_TYPE_ACCESS: { strsql=_T("Provider=Microsoft.Jet.OLEDB.4.0"); strsql+=_T(";Password=")+sDatabaseParam.strPassword; strsql+=_T(";User ID=")+sDatabaseParam.strUserName;; strsql+=_T(";Data Source=")+sDatabaseParam.strDbName; strsql+=_T(";Persist Security Info=False"); break; } ActieveX控件如何调试啊? 用双缓冲合并多图片显示,图片显示不出来 请问,我启用了Unicode字符集编译后,new ASSERT VERITY这些语句都编译不过,请问怎么处理? 帮一下忙,软件估价问题! 一个关于Windows平台下RPC和COM的问题 是不是任何文件都能加到vc的资源中去? VC应用程序如何打包 如何知道鼠标移出对象 窗口没有响应怎么办 ? 请教RangePtr::findnext的用法 收到一個dialog上的edit,ON_WM_KEYUP訊息 编译中找不到头文件怎么办?回答加分
www.codersource.net/ado_mfc_clistctrl.html -
There is no ADO in MFC, only DAO, but DAO is now obsolete.
找本讲数据库编程的书。
_RecordsetPtr pRst;
_CommandPtr pCmd;
HRESULT hr;
try
{
// hr = pConn.CreateInstance(__uuidof(Connection)); ///创建Connection对象
hr = pConn.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr))
{// adModeUnknown
// hr = pConn->Open("FileDSN=asas.dsn","","",0);
hr = pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=netChat.mdb","","",adModeUnknown);
pRst.CreateInstance("ADODB.Recordset");
pCmd.CreateInstance("ADODB.Command");
pConn->Close();
}
}
catch(_com_error e)
{
CString err;
err.Format("数据库错误信息:%s",e.ErrorMessage());
AfxMessageBox(err);
if(pRst!=NULL)
{
if(pRst->State)
pRst->Close();
pRst.Release();
}
if(pConn!=NULL)
{
if(pConn->State)
pConn->Close();
pConn.Release();
}
if(pCmd!=NULL)
pCmd.Release();
SendMessage(WM_CLOSE);
} pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=netChat.mdb","","",adModeUnknown);
pRst->Open("update primary_table set is_online=false",_variant_t((IDispatch*)pConn,TRUE),
adOpenStatic,adLockOptimistic,adCmdText); //update
if(pRst->State)
pRst->Close();
if(pConn->State)
pConn->Close();BSTR bstrSQL;
sqlcmd.Format("select * from primary_table where ID=%d",dwID);
bstrSQL=sqlcmd.AllocSysString(); pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=netChat.mdb","","",adModeUnknown);
pRst->Open(bstrSQL,_variant_t((IDispatch*)pConn),adOpenDynamic ,adLockBatchOptimistic ,adCmdText); //select if(pRst->State)
pRst->Close();
if(pConn->State)
pConn->Close();代码很乱.....反正差不多是这意思
看着书上的
自己做了个基于Access的学生信息管理的
要的话给你全部代码
发我邮箱里吧
[email protected]
校园网真是慢呀 CSDN我用了半个小时才打开...
{
strsql=_T("Provider=Microsoft.Jet.OLEDB.4.0");
strsql+=_T(";Password=")+sDatabaseParam.strPassword;
strsql+=_T(";User ID=")+sDatabaseParam.strUserName;;
strsql+=_T(";Data Source=")+sDatabaseParam.strDbName;
strsql+=_T(";Persist Security Info=False");
break;
}