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

库\

CString str,_cid; int ok=0; _variant_t cscode;

str = \

m_pRecordset = m_pConnection->Execute(str.AllocSysString(),NULL,adCmdText); UpdateData(TRUE);

while( !m_pRecordset->adoEOF ) {

_cid = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\if(m_Edit3_cidValue==_cid) { }

m_pRecordset->MoveNext();

str = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\break;

}

catch (_com_error e) { }

::CoUninitialize();

AfxMessageBox(e.ErrorMessage()); return;

}

} //

AfxMessageBox(pa);

if( str != \ }

AfxMessageBox(\课程已经开始或结束,不能删除!\m_pRecordset->Close(); m_pConnection->Close(); return ;

//以下删除数据 _variant_t ra;

_bstr_t strAdd = \strAdd = strAdd + \//

AfxMessageBox(strAdd);

m_pConnection->Execute(strAdd,&ra,adCmdText); m_pConnection->Close(); m_Adodc2.Refresh(); UpdateData(FALSE); AfxMessageBox(\成功删除\}

BOOL DailogForSelectCourse::OnInitDialog() {

CString strAdd=\课程号=training_plan.cid,成绩=score,考核评价 CDialog::OnInitDialog();

=apprisement.description from training_plan,apprisement where

training_plan.personid='\ }

6.2设置课程模块

m_Adodc2.SetRecordSource(strAdd); m_Adodc2.Refresh();

m_combo1_FieldName.SetWindowText(\请选择\m_combo1_FieldName.AddString(\课程号\m_combo1_FieldName.AddString(\课程名\m_combo1_FieldName.AddString(\任课老师\m_combo1_FieldName.AddString(\课程简介\m_combo1_FieldName.AddString(\所用教材\m_combo1_FieldName.AddString(\上课地点\m_combo1_FieldName.AddString(\课程上限人数\m_combo1_FieldName.AddString(\开课时间\m_combo1_FieldName.AddString(\状态\m_combo1_FieldName.AddString(\考核日期\return TRUE;

// DailogForMGcourse.cpp : implementation file

//

#include \

#include \员工培训管理系统.h\#include \#include \#include \

#include \#ifdef _DEBUG

#define new DEBUG_NEW #undef THIS_FILE

static char THIS_FILE[] = __FILE__; #endif

///////////////////////////////////////////////////////////////////////////// // DailogForMGcourse dialog

DailogForMGcourse::DailogForMGcourse(CString Name,CString

/*=NULL*/) : CDialog(DailogForMGcourse::IDD, pParent)

{ userName = Name; LinkSql = Link;

//{{AFX_DATA_INIT(DailogForMGcourse)

m_Edit1_cid = _T(\

Link,CWnd*

pParent