vc++ SQLServer添加操作实现

/*
*SQLServer添加操作实现
*/
void CMFCSQLDlg::OnButton2()
{
// TODO: Add your control notification handler code here
CString strsql;
CString strnum="mynum3";
CString strage="myage3";
HRESULT hResult;
_variant_t RecordsAffected;
CoInitialize(NULL);
_ConnectionPtr  m_pAppConn;
hResult = m_pAppConn.CreateInstance(("ADODB.Connection"));///创建Connection对象
  if(SUCCEEDED(hResult))
  {
//m_pAppConn->Open("Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source = .\\DataBase\\aa.mdb", "","",adModeUnknown);
hResult=m_pAppConn->Open("Provider=SQLOLEDB.1;Server=808644DA83B446C\\SQLEXPRESS;DATABASE=ChinabaseSQLServer;UID=sa;PWD=123;","","",adModeUnknown);
MessageBox("运行成功!","成功",MB_OK);
  }
_CommandPtr m_pCommand;
_RecordsetPtr m_pRecordset;
m_pCommand.CreateInstance("ADODB.Command");
//CString edit1 = GetDlgItemText("IDC_EDIT1");
CWnd*   pWnd   =   GetDlgItem(IDC_EDIT1);  
CString   str;  
pWnd->GetWindowText(str);
CWnd* pWnd1 =  GetDlgItem(IDC_EDIT2);  
CString str1;  
pWnd1->GetWindowText(str1); 
 
AfxMessageBox(str);
AfxMessageBox(str1);
strsql.Format("INSERT INTO MTables VALUES('%s','%s','%s','%s','%s')",str,str1,"20","20","20");
try
 {
  m_pAppConn->Execute (_bstr_t(strsql) , &RecordsAffected , adCmdUnknown);
  AfxMessageBox("添加成功!");
 }
catch(_com_error e)
{
    //AfxMessageBox(e.ErrorMessage());
 AfxMessageBox("发生异常!");
}
}