Ado的学习笔记
添加到数据库使用m_pRecordset指针
BOOL AddToDataBase (const ADO& adoVar)
{
try
{
//添加新行
adoVar.m_pRecordset->AddNew();
adoVar.m_pRecordset->PutCollect("No",(_bstr_t)m_nNum);
adoVar.m_pRecordset->PutCollect("StuId",(_bstr_t)m_strSutdentID);
adoVar.m_pRecordset->PutCollect("Name",(_bstr_t)m_strName);
adoVar.m_pRecordset->PutCollect("Sex",(_bstr_t)m_strSex);
adoVar.m_pRecordset->PutCollect("Age",(_bstr_t)m_nAge);
adoVar.m_pRecordset->PutCollect("PhoneNum",(_bstr_t)m_strPhoneNum);
adoVar.m_pRecordset->Update();
}
catch(...)
{
MessageBox(_T("添加操作失败"),_T("提示"),MB_ICONEXCLAMATION);
return FALSE;
}
return TRUE;
}
ADO 指定pos 删除m_pRecordset
BOOL DeleteOneData(ADO adoVar, int pos)
{
try
{
adoVar.m_pRecordset->Move(pos,vtMissing);
adoVar.m_pRecordset->Delete(adAffectCurrent);
adoVar.m_pRecordset->Update();
adoVar.CloseRecordset();
}
catch(...)
{
MessageBox(_T("DeleteOneData 操作失败"));
return FALSE;
}
return TRUE;
}