已经包含了ADo的Ado.cpp,AdoCommand.cpp,AdoRecordSet.cpp及3个相应头文件;
执行对话框里的按纽:
void CbltlDlg::OnButton1()
{
UpdateData(TRUE);
CString strDBConnection;
CString strSql;
CString str1;
strDBConnection = "Provider=OraOLEDB.Oracle; Data Source=CTM; User Id=system; Password=manager";
CAdoConnection adoConnection;
str1.Format(_T("%d"),m_1_1);
adoConnection.Open(strDBConnection);
CAdoRecordSet rs(&adoConnection);
strSql.Format("Insert into ZHONGYI.T10(B1) value('%s')",str1);
if(rs.Open(strSql))
AfxMessageBox("Insert successful");
else AfxMessageBox("error");
adoConnection.Close();
rs.Close();
}
执行对话框里的按纽:
void CbltlDlg::OnButton1()
{
UpdateData(TRUE);
CString strDBConnection;
CString strSql;
CString str1;
strDBConnection = "Provider=OraOLEDB.Oracle; Data Source=CTM; User Id=system; Password=manager";
CAdoConnection adoConnection;
str1.Format(_T("%d"),m_1_1);
adoConnection.Open(strDBConnection);
CAdoRecordSet rs(&adoConnection);
strSql.Format("Insert into ZHONGYI.T10(B1) value('%s')",str1);
if(rs.Open(strSql))
AfxMessageBox("Insert successful");
else AfxMessageBox("error");
adoConnection.Close();
rs.Close();
}
try
{}
catch
{}
查看异常你会找出问题。
用没有用?
//blush