想把记录集装到RecordsetPtr中,并能够用Grid显示,而且也能编辑
但:
方法一:
_RecordsetPtr m_pRecordset;
m_pRecordset->Open((_variant_t)sql,(_variant_t)connstr,adOpenStatic,adLockOptimistic,adCmdText);
这种在DataGrid中显示不出来,但能修改方法二:
_RecordsetPtr m_pRecordset;
pconn->Open((_bstr_t)connstr,"","",0);
pconn->CursorLocation = adUseClient;
m_pRecordset =pconn->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
这种能显示,但DataGrid中是只读的问问高手看,这个怎么解决啊
但:
方法一:
_RecordsetPtr m_pRecordset;
m_pRecordset->Open((_variant_t)sql,(_variant_t)connstr,adOpenStatic,adLockOptimistic,adCmdText);
这种在DataGrid中显示不出来,但能修改方法二:
_RecordsetPtr m_pRecordset;
pconn->Open((_bstr_t)connstr,"","",0);
pconn->CursorLocation = adUseClient;
m_pRecordset =pconn->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
这种能显示,但DataGrid中是只读的问问高手看,这个怎么解决啊
_RecordsetPtr m_pRecordset;
m_pRecordset->Open((_variant_t)sql,(_variant_t)connstr,adOpenStatic,adLockOptimistic,adCmdText); m_queryTblGrid.SetRefDataSource(NULL);
m_queryTblGrid.SetRefDataSource((LPUNKNOWN)m_pRecordset);
m_queryTblGrid.Refresh();
m_pRecordset->PutCursorLocation(adUseClient);
OK了, 多谢了
顺便再问个:DataGrid能不能设置成不要自动提交的, 比如改完后,最后我调用一下m_pRecordset->Update();来保存到数据库中, 能否这样?
如果取消自动提交的话
或许得禁止update,然后你自己写个文本框来处理
当然这是最坏的打算~~