与ado有关的问题

void CMy1dbView::OnButton6()//打开 记录集 { try { kk.CreateInstance(__uuidof(Recordset)); kk->Open("Select * from tree",conn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); //kk->MoveNext(); // while(!kk->adoEOF) // { //kk->MoveFirst(); // kk->MoveNext(); //kk->Close(); //AfxMessageBox("我在测试记录集,打开正确");//} //} } catch(_com_error e) { AfxMessageBox("我在测试记录集,有错误"); } // TODO: Add your control notification handler code here } void CMy1dbView::OnButton7() { long x=555555; long y=8888; CString ss,e; ss="trreeeee"; e="your event"; //kk->Open("Select * from tree",conn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); try { kk->MoveLast(); kk->AddNew(); kk->PutCollect("yy",x);//_variant_t(12)); kk->PutCollect("ew",_variant_t(ss)); kk->PutCollect("t",_variant_t(ss)); kk->PutCollect("tt",y); kk->PutCollect("ww",_variant_t(e)); kk->Update(); AfxMessageBox("我在测试记录集,添加成功"); kk->Close(); } catch(_com_error e) { AfxMessageBox("我在测试记录集,有添加失败"); } // TODO: Add your control notification handler code here } void CMy1dbView::OnButton8() {//修改记录 CString ss; long x; x=99999; ss="good morning"; try { // kk->MoveFirst(); // kk->MoveNext(); kk->MoveLast(); kk->PutCollect("tt",_variant_t(ss)); kk->PutCollect("ww",_variant_t(ss)); kk->PutCollect("t",_variant_t(ss)); kk->PutCollect("yy",x); kk->Update(); AfxMessageBox("我在测试记录集,修改成功"); } catch(_com_error r) { AfxMessageBox("我在测试记录集,修改失败"); } // TODO: Add your control notification handler code here } void CMy1dbView::OnButton9() {//清除记录 this->UpdateData(); HRESULT hr; try { conn.CreateInstance(__uuidof(Connection)); //__uuidof(Connection)); conn->Open("DSN=kkk","","",-1);//adAsyncConnect kk.CreateInstance(__uuidof(Recordset)); hr=kk->Open("select * from tree",conn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); kk->MoveFirst(); // kk->Delete(adAffectCurrent); kk->Update(); AfxMessageBox("我在测试记录集,清除成功"); _variant_t rr; long u; u=kk->GetCollect("yy"); rr=kk->GetCollect("t"); CString str; str.Format("%s",(LPSTR)(_bstr_t)(rr));//利用转换VARIANT到cstring成功 rr=kk->GetCollect("t"); m_edit1=u; m_edit2=str; UpdateData(false); } catch(_com_error T) { AfxMessageBox("我在测试记录集,清除失败"); } // TODO: Add your control notification handler code here } void CMy1dbView::OnButton10() { try{ if(kk!=NULL) kk->Close(); if(conn!=NULL) conn->Close(); } catch(_com_error u) { AfxMessageBox("我在关闭所有的接口"); } // TODO: Add your control notification handler code here } void CMy1dbView::OnButton11() //实现了查询的记录 {try{ if(kk->adoEOF){ kk->MoveFirst(); AfxMessageBox("文件已到尾");} kk->MoveNext(); _variant_t r; _bstr_t rr; long t; t=kk->GetCollect("yy"); // CString str; //str.Format("%d",t); m_edit1=t; _variant_t value; value=kk->GetCollect("t"); CString str; str=(LPSTR)(_bstr_t)value; str.Format("%s",str); m_edit2=str; kk->Update(); kk->Update(); this->UpdateData(false); this->UpdateData(false); } catch(_com_error y) { AfxMessageBox("已到尾,刚转向头一条记录"); kk->MoveFirst(); } // this->UpdateData(true);