数据库课程设计报告（员工培训管理系统）

}

m_pRecordset->Close(); m_pConnection->Close(); return ;

//判断该课是否已有学生选择 str = \

m_pRecordset.CreateInstance(\m_pRecordset = m_pConnection->Execute(str.AllocSysString

(),NULL,adCmdText);

UpdateData(TRUE); OK=0;

while( !m_pRecordset->adoEOF ) { } if( OK ){ //

AfxMessageBox(\该课程已有学生选择，如要删除该课程，请先对选 pcid = m_pRecordset->GetCollect(\CString tmp1 = (LPCSTR)(_bstr_t)pcid; if( strcmp(m_Edit1_cid,tmp1)==0 ){ }

m_pRecordset->MoveNext();

OK=1; break;

课结果表进行修改\

if(::MessageBox(NULL,\该课程已有学生选择，如要删除该课程，

是否到选课管理进行删除？\提示\

this->ShowWindow(SW_HIDE);

DailogForMGResultC* dlg = new DailogForMGResultC

(userName,LinkSql); }

}

}

//以下删除数据 _variant_t ra;

_bstr_t strAdd = \

AfxMessageBox(strAdd); }

m_pRecordset->Close(); m_pConnection->Close(); return ;

dlg->DoModal();

this->ShowWindow(SW_SHOW);

m_pConnection->Execute(strAdd,&ra,adCmdText); m_pConnection->Close();

m_adodc1.SetRecordSource(\ m_adodc1.Refresh(); UpdateData(FALSE); AfxMessageBox(\成功删除\

void DailogForMGcourse::OnUPDATE() {

// TODO: Add your control notification handler code here UpdateData(TRUE);

_ConnectionPtr m_pConnection;

::CoInitialize(NULL);

try {

m_pConnection.CreateInstance(\

}

catch (_com_error e) {

::CoUninitialize();

_bstr_t strConn=LinkSql.AllocSysString();

m_pConnection->Open(strConn,\

//if(m_pConnection->State == adStateOpen) MessageBox(\成功连接数据库\

AfxMessageBox(e.ErrorMessage());

}

return;

//以下更新数据

_variant_t ra; int ok=0;

CString strAdd = \ \

if(m_Edit9_cscode!=\{ }

if(m_Edit1_cid==\{ } else {

if(m_Edit2_cname!=\{ }

if(m_Edit3_personid!=\

if(ok) else {

strAdd+=\ok=1;

strAdd += \strAdd += \ok=1;

AfxMessageBox(\请输入课程号\return ;

AfxMessageBox(\状态输入有误,请确认!\return ;