CDaoRecordset *m_pRecordset;
CDaoDatabase *m_pDatabase;
////////初始化
m_pDatabase = new CDaoDatabase;
try
{
m_pDatabase->Open("user.mdb");//放在了工程的目录下，并将数据 //库转化了低级版本
m_pRecordset =new CDaoRecordset(m_pDatabase);
m_name = _T("select mima from yonghu");
m_pRecordset->Open(dbOpenDynaset,m_name);
}
catch(CDaoException *e)
{
e->ReportError();
}
///////////查询
while(!m_pRecordset->IsEOF())
{
COleVariant var;
CString str;
var = m_pRecordset->GetFieldValue(0);
str.Format("%s",(const char*)var.pbstrVal);
m_CtrlRecieve.AddString(str);
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
m_name = _T("select yonghu from yonghu");
m_pRecordset->Open(dbOpenDynaset,m_name);
while(!m_pRecordset->IsEOF())
{
COleVariant var;
CString str;
var = m_pRecordset->GetFieldValue(0);
str.Format("%s",(const char*)var.pbstrVal);
m_CtrlSel.AddString(str);
m_pRecordset->MoveNext();
}
m_pRecordset->Close();//查询时要关闭
////////////////////////增删改
if(!m_pDatabase->IsOpen())
m_pDatabase->IsOpen();
id1=m_CtrlRecieve.GetCurSel();
m_CtrlRecieve.GetLBText(id1,buf);
sqlupdate.Format("update yonghu set yonghu ='112664' where mima =
'%s'",buf);
sqlupdate.Format("insert into yonghu(mima) values('%s')",buf);
if(m_pDatabase->CanUpdate())
m_pDatabase->Execute(sqlupdate);
sqlupdate.Format("insert into yonghu(mima) values('14')");
if(m_pDatabase->CanUpdate())
m_pDatabase->Execute(sqlupdate);
sqlupdate.Format("insert into yonghu(mima) values('15')");
if(m_pDatabase->CanUpdate())
m_pDatabase->Execute(sqlupdate);
