通过ADO修改数据时,出现“在对应所需名称或序数的集合中,未找到项目”
UpdateData(true);
if(m_type.IsEmpty ()||m_ID.IsEmpty())
{
MessageBox("不能为空!");
return;
}
ADOconn m_AdoConn;
m_AdoConn.OnInitADOConn();
_bstr_t sql;
sql="select * from Department";
_RecordsetPtr m_pRecordset;
m_pRecordset=m_AdoConn.GetRecordSet(sql);
try
{
m_pRecordset->Move (pos,vtMissing);
m_pRecordset->GetFields ()->GetItem ((_variant_t)"资产类型ID")->Value=(_bstr_t)m_ID;
m_pRecordset->GetFields ()->GetItem ((_variant_t)"资产类型")->Value=(_bstr_t)m_type;
m_pRecordset->GetFields ()->GetItem ((_variant_t)"备注")->Value=(_bstr_t)m_remark;
m_pRecordset->Update();
m_AdoConn.ExitConnect();
}
catch(_com_error e)
{
MessageBox(e.Description ());
return;
}
MessageBox("修改成功");
m_grid.DeleteAllItems();
OnInitDialog();
[解决办法]
sql="select * from Department";
是不是表名不对啊
[解决办法]
先在 PL/SQL里执行下。