64,651
社区成员
发帖
与我相关
我的任务
分享
void CDbTestDlg::OnBtnSaveRecordset()
{
LRESULT lResult = m_ado.GetConnect()->Open(m_strConnString, "", "", adModeUnknown);
if (!SUCCEEDED(lResult))
{
MessageBox("连接数据库失败");
return;
}
_bstr_t bstrSqlQuery = "SELECT * FROM student";
lResult = m_ado.GetRecordset()->Open(bstrSqlQuery, m_ado.GetConnect().GetInterfacePtr(), adOpenStatic, adLockBatchOptimistic, adCmdText);
if (!SUCCEEDED(lResult))
{
MessageBox("查询数据库失败!");
return;
}
m_ado.GetRecordset()->Save("d:\\Recordsets.xml", adPersistXML);
m_ado.ConnectionClose();
}