SQLд¿â´íÎó

void Cinput_1Dlg::OnBnClickedButton1()
{
// TODO: Add your control notification handler code here
CoInitialize(NULL);
/*´íÎó²¶×½*/
_ConnectionPtr m_pConnection;  
_RecordsetPtr m_pRecordset;  
_variant_t RecordsAffected;  
  HRESULT hr;  
  try  
  {  
  hr = m_pConnection.CreateInstance("ADODB.Connection");///´´½¨Connection¶ÔÏó  
  if(SUCCEEDED(hr))  
  {  
  hr = m_pConnection->Open("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Password=sa;Initial Catalog=binjiangodbc","","",adModeUnknown);///Á¬½ÓÊý¾Ý¿â  
m_pRecordset = m_pConnection->Execute("INSERT INTO zha(Gid,a1,a2,a3,a4) VALUES (1,2,3,4,5)",NULL,adCmdText);;  
   
  } 
}
  catch(_com_error e)///²¶×½Òì³£  
  {  
  CString errormessage;  
  errormessage.Format(_T("Á¬½ÓÊý¾Ý¿âʧ°Ü!\r\n´íÎóÐÅÏ¢:%s"),e.ErrorMessage());  
  AfxMessageBox(errormessage);///ÏÔʾ´íÎóÐÅÏ¢  
}

   


m_pRecordset->Close();
m_pConnection->Close();
m_pRecordset.Release();
m_pConnection.Rele