4,011
社区成员
发帖
与我相关
我的任务
分享
try
{
CString sql;
sql = "SELECT * FROM 收费表";
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open((_variant_t)sql,((CCar_costApp*)AfxGetApp())->m_pConnection.GetInterfacePtr(),
adOpenStatic,adLockOptimistic,adCmdText);
// m_pRecordset->MoveLast();
m_pRecordset->AddNew();
m_pRecordset->PutCollect("居民号",_variant_t(m_dep_id));
m_pRecordset->PutCollect("车辆号",_variant_t(m_car_id));
m_pRecordset->PutCollect("入库时间",_variant_t(m_start_time));
m_pRecordset->PutCollect("办理人",_variant_t(m_use_id));
m_pRecordset->MoveNext();
m_pRecordset->Update();
AfxMessageBox("修改成功!");
m_pRecordset->Close();
}