idispatch error 3092
做了一个注册的界面,当注册完成时点击“确定”就会有idispatch error 3092。。。。。
void CRegDlg::OnOK()
{
// TODO: Add extra validation here
//-------------------------
try{
UpdateData(TRUE);
CString sql;
sql = "select * from user where name = '"+m_user+"'";
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
if (m_pRecordset->GetRecordCount()>0)
{
AfxMessageBox("该员工已存在");
return;
}
else
{
m_pRecordset->AddNew();
m_pRecordset->PutCollect("name",(_variant_t)m_user);
m_pRecordset->PutCollect("password",(_variant_t)m_sec);
m_pRecordset->PutCollect("password2",(_variant_t)m_sec2);
m_pRecordset->Update();
m_pRecordset->Close();
// UpdateList();
UpdateData(FALSE);
}
}
catch(_com_error e)///捕捉异常
{
CString temp;
temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
::MessageBox(NULL,temp,"提示信息",NULL);
}
}