16,471
社区成员
发帖
与我相关
我的任务
分享
void CDbtestDlg::OnButton1()
{
// TODO: Add your control notification handler code here
try
{
//打开数据表
HRESULT hr = m_pRecordset->Open( "SELECT * FROM t_test",
m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText
);
if (!SUCCEEDED(hr))
{
return;
}
}
catch(_com_error &e)
{
//关闭记录集
if (m_pRecordset->State)
{
m_pRecordset->Close();
}
}
}
try
{
HRESULT hr = m_pRecordset->Open( "SELECT * FROM t_test",
m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText
);
}
catch(_com_error &e)
{
CString strTips;
strTips.Format("错误编号=[%08lx], 错误信息=[%s], 错误源[%s], 错误描述[%s]",
e.Error(),
e.ErrorMessage(),
(LPCSTR)e.Source(),
(LPCSTR)e.Description());
MessageBox(strTips);
}
_variant_t var;
var.vt = VT_NULL;
m_pRecordset->PutActiveConnection(var);
void CDbtestDlg::OnButton1()
{
// TODO: Add your control notification handler code here
try
{
//打开数据表
HRESULT hr = m_pRecordset->Open( "SELECT * FROM t_test",
m_pConnection.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText
);
if (!SUCCEEDED(hr))
{
return;
}
}
catch(_com_error &e)
{
//关闭记录集
m_pRecordset->PutActiveConnection(NULL); //这里加这句试一试
m_pRecordset->Close();
}
}