定义了两个记录集变量
_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里面的记录
然后两个记录集我随便的进行操作,该怎么办啊??高手帮我---
_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里面的记录
然后两个记录集我随便的进行操作,该怎么办啊??高手帮我---
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);