VC++ SQLServer添加操作实现

/*

*VC++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("发生异常!");

}

}