用Adodc向access表中插入数据时提示“对象关闭时,操作不被允许”,但数据却已经插入数据库了,这是为什么呀?
CString sql= (CString)"Insert into Product (ProNum, State,Memo1,Operate) Values('";
sql = sql + (CString)s_Edit;
sql = sql + (CString)"','";
sql = sql + (CString)s_State;
sql = sql + (CString)"','";
sql = sql + (CString)s_Memo;
sql = sql + (CString)"','";
sql = sql + (CString)s_Operate;
sql = sql + (CString)"')";
m_Adodc.CommandTypeEnum = CAdodc1::adCmdText;
m_Adodc.ConnectStringTypeEnum = CAdodc1::adConnectTypeOledb;
m_Adodc.put_RecordSource(sql);
m_Adodc.Refresh();
m_DataGrid.Refresh();
UpdateData(false);
代码如上,我知道是因为 m_DataGrid.Refresh();这句引起的 refresh一般只能用来打开记录集,用来执行语句会出错误.但应该有什么解决方法呢?