CDbTools db;
_RecordsetPtr m_recordset = db.getResult("select * from product");
 CString xfrq;
 xfrq.Format("%d/%d/%d",m_xfrq.GetYear(),m_xfrq.GetMonth(),m_xfrq.GetDay());
  m_recordset->AddNew();
 m_recordset->PutCollect("cpmc",_variant_t(m_cpmc));
  m_recordset->PutCollect("uid",_variant_t("1"));
  m_var.iVal = m_sl;
  m_recordset->PutCollect("sl",m_var.iVal);
 m_recordset->PutCollect("lx",_variant_t(m_lx));
 m_var.iVal = m_je;
  m_recordset->PutCollect("je",m_var.iVal);
 m_recordset->PutCollect("sccj",_variant_t(m_sccj));
  m_recordset->PutCollect("xfrq",_variant_t(xfrq));
  m_recordset->PutCollect("bz",_variant_t(m_bz));
m_recordset->PutCollect("bz",_variant_t(m_lrrq));
 m_recordset->Update();
 m_recordset->Close();
m_recordset=NULL;

发表于 @ 2006年01月15日　13:47:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:ListCtr的用法 | 新一篇:MFC数据库操作笔记