定义了两个记录集变量
_RecordsetPtr record1;
_RecordsetPtr  record2;然后连接数据库
_variant_t affected;
con.CreateInstance(__uuidof(Connection));
record1.CreateInstance(__uuidof(Recordset));
con->Open("provider=SQLOLEDB;server=127.0.0.1;database=keyan","sa","123",0);
record1->CursorLocation=adUseClient;
record1->Open(_bstr_t("select * from task1"),_variant_t((IDispatch*)con,true),adOpenStatic,adLockOptimistic,adCmdText);
这个时候record1里面已经有数据了
我想在record2中保存另一张表task2里面的记录
然后两个记录集我随便的进行操作,该怎么办啊??高手帮我---

解决方案 »

  1.   

    再用record2来Open表Task2不就行了,record1和record2用同一个connection
      

  2.   

    楼上的用同一个connection是不行的再定义一个连接_ConnectionPtr con2; _variant_t affected;
    con.CreateInstance(__uuidof(Connection));
    record1.CreateInstance(__uuidof(Recordset));
    con->Open("provider=SQLOLEDB;server=127.0.0.1;database=keyan","sa","123",0);
    record1->CursorLocation=adUseClient;
    record1->Open(_bstr_t("select * from task1"),_variant_t((IDispatch*)con,true),adOpenStatic,adLockOptimistic,adCmdText); con2.CreateInstance(__uuidof(Connection));
    record2.CreateInstance(__uuidof(Recordset));
    con2->Open("provider=SQLOLEDB;server=127.0.0.1;database=keyan","sa","123",0);
    record2->CursorLocation=adUseClient;
    record2->Open(_bstr_t("select * from task2"),_variant_t((IDispatch*)con,true),adOpenStatic,adLockOptimistic,adCmdText);