直接上代码:
void CADOConDlg::OnButton1()
{
// TODO: Add your control notification handler code here
HRESULT hr;
CString strSql;
_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
try
{
//create the SQL service object
hr = m_pConnection.CreateInstance(__uuidof(Connection));
ASSERT( SUCCEEDED(hr) );
strSql.Format("%s","Provider=SQLOLEDB;server=xxx;database=xxx;UID=xxx;PWD=xxx");
m_pConnection->ConnectionString = (_bstr_t)strSql;
hr = m_pConnection->Open("","","",adConnectUnspecified);
ASSERT( SUCCEEDED(hr) );
//create the record set object for write
hr = m_pRecordset.CreateInstance(__uuid