void second::OnButton3()
{
// TODO: Add your control notification handler code here
variant_t vNULL;
vNULL.vt=VT_ERROR;
vNULL.scode=DISP_E_PARAMNOTFOUND;
HRESULT hr;
hr=m_pCommad.CreateInstance(_uuidof(Command));
UpdateData(TRUE);
if(m_xuehao.IsEmpty())
{
AfxMessageBox("数据不能为空");
return ;
}
m_pCommad->ActiveConnection=m_pConnection;
CString strSQL;
strSQL="insert into table(xuehao,xingming,nianling,jiguan) VALUES(?,?,?,?)";
m_pCommad->CommandText=(_bstr_t)strSQL;
_ParameterPtr pParam1,pParam2;
pParam1= m_pCommad->CreateParameter("",adBSTR,adParamInput,sizeof(_bstr_t),(_bstr_t)m_xuehao);
m_pCommad->Parameters->Append(pParam1);
pParam1= m_pCommad->CreateParameter("",adBSTR,adParamInput,sizeof(_bstr_t),(_bstr_t)m_xingming);
m_pCommad->Parameters->Append(pParam1);
pParam1= m_pCommad->CreateParameter("",adInteger,adParamInput,sizeof(int),_variant_t((long)m_nianling));
m_pCommad->Parameters->Append(pParam1);
pParam1= m_pCommad->CreateParameter("",adBSTR,adParamInput,sizeof(_bstr_t),(_bstr_t)m_jiguan);
m_pCommad->Parameters->Append(pParam1);
m_pCommad->Execute(&vNULL,&vNULL,adCmdText);
m_xuehao="";
UpdateData(FALSE);
}
显示数据库连接成功,但是通过对话框添加数据就不行,数据无法添加进数据库,
且对话框出来后总是卡死光不掉,大神看看这段代码是不是有什么问题