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

}

m_c_name=\m_c_teacher=\m_c_intro=\m_c_book=\m_c_classroom=\m_c_number=\m_c_classtime=\m_c_state=\UpdateData(FALSE);

BEGIN_EVENTSINK_MAP(tercher_course, CDialog) //{{AFX_EVENTSINK_MAP(tercher_course)

ON_EVENT(tercher_course, IDC_DATAGRID1, -601 /* DblClick */, OnDblClickDatagrid1, VTS_NONE) //}}AFX_EVENTSINK_MAP

END_EVENTSINK_MAP()

void tercher_course::OnDblClickDatagrid1() {

v_ColNum.iVal = 3; v_ColNum.iVal = 2;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_teacher = v_Value.bstrVal; v_ColNum.iVal = 1;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_name = v_Value.bstrVal; v_ColNum.iVal = 0;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_id = v_Value.bstrVal;

cols = m_datagrid1.GetColumns(); //调用GetColumns 返回CDataGrid对应的CColumns对象 v_ColNum.vt = VT_I2;

// TODO: Add your control notification handler code here UpdateData(TRUE); int ColNum = 2; CString colVal;

CColumns cols; //要包含的文件头COlumns.h CColumn col; //要包含的文件头COlumn.h VARIANT v_ColNum,v_Value;

}

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_intro = v_Value.bstrVal; v_ColNum.iVal = 4;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_book = v_Value.bstrVal; v_ColNum.iVal = 5;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_classroom = v_Value.bstrVal; v_ColNum.iVal = 6;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_number = v_Value.bstrVal; v_ColNum.iVal = 7;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_classtime = v_Value.bstrVal; v_ColNum.iVal = 8;

col = cols.GetItem(v_ColNum); v_Value = col.GetValue(); m_c_state = v_Value.bstrVal; UpdateData(FALSE);

void tercher_course::OnButton5() { }

void tercher_course::OnButton6() { }

exit(0);

this->ShowWindow(SW_HIDE); teacher dlg; dlg.DoModal();

this->ShowWindow(SW_SHOW);

void tercher_score::OnButton1() {

//清空输入框 UpdateData(TRUE);

_ConnectionPtr m_pConnection; ::CoInitialize(NULL); try{ }

catch(_com_error e) { }

_variant_t ra;

_bstr_t strAdd=\strAdd=strAdd+\strAdd=strAdd+\strAdd=strAdd+\strAdd=strAdd+\strAdd=strAdd+\

::CoUninitialize();

AfxMessageBox(e.ErrorMessage()); return;

m_pConnection.CreateInstance(\_bstr_t

strConn=\m_pConnection->Open(strConn,\

Info=False;Initial Catalog=Employee training management system;Data Source=520-002\

}

m_pid=\m_cid=\m_score=\m_aid=\m_exam_date=\

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

m_adodc1.SetRecordSource(\m_adodc1.Refresh(); UpdateData(FALSE);

void tercher_score::OnButton2() {

MessageBox(strAdd);

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

strAdd=strAdd+\strAdd=strAdd+\strAdd=strAdd+\strAdd=strAdd+\strAdd=strAdd+\UpdateData(TRUE);

_ConnectionPtr m_pConnection; ::CoInitialize(NULL); try{ }

catch(_com_error e) { }

variant_t RecordsAffected; _variant_t ra;

_bstr_t strAdd=\

::CoUninitialize();

AfxMessageBox(e.ErrorMessage()); return ;

m_pConnection.CreateInstance(\

_bstr_t strConn=\m_pConnection->Open(strConn,\//

Info=False;Initial Catalog=Employee training management system;Data Source=520-002\