//
}
}
AfxMessageBox(m_Edit2_cidValue+\if( strcmp(m_Edit2_cidValue,tmp1)==0 ) cnt++; m_pRecordset->MoveNext();
if( OK ){ }
CString _cid;
str = \
m_pRecordset = m_pConnection->Execute(str.AllocSysString(),NULL,adCmdText); UpdateData(TRUE); OK=0;
while( !m_pRecordset->adoEOF ) {
_cid=str = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\if(m_Edit2_cidValue==_cid) {
str = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\break;
AfxMessageBox(\已选修了该课程!\m_pRecordset->Close(); m_pConnection->Close(); return ;
//
}
}
m_pRecordset->MoveNext();
AfxMessageBox(pa); if( str != \ }
AfxMessageBox(\课程已经开始或结束,不能选课\m_pRecordset->Close(); m_pConnection->Close(); return ;
str = \
m_pRecordset = m_pConnection->Execute(str.AllocSysString(),NULL,adCmdText); UpdateData(TRUE); OK=0;
while( !m_pRecordset->adoEOF ) {
CString tmp2 = (LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\CString tmp1 = (LPCSTR)(_bstr_t)pcid; if( strcmp(tmp1,tmp2)==0 ) {
pa=(LPCSTR)(_bstr_t)m_pRecordset->GetCollect(\OK=1; break;
}
}
m_pRecordset->MoveNext();
sum=atoi(pa); if( cnt>=sum ){ }
AfxMessageBox(\该课已满人！\m_pRecordset->Close(); m_pConnection->Close(); return ;
//
_variant_t ra;
_bstr_t strAdd = \ALUES('\strAdd = strAdd + personid + \strAdd = strAdd + m_Edit2_cidValue + \strAdd = strAdd + \//AfxMessageBox(strAdd);
m_pConnection->Execute(strAdd,&ra,adCmdText);
m_Adodc2.SetRecordSource(\ m_Adodc2.Refresh();
}
}
UpdateData(FALSE); m_pRecordset->Close(); m_pConnection->Close(); AfxMessageBox(\成功选课\
void DailogForSelectCourse::OnButtonDEL() {
// TODO: Add your control notification handler code here CString tmp=personid;
if( ::MessageBox(NULL,\确定要删除这门课吗？\提示\
//
AfxMessageBox(\
UpdateData(TRUE);
_ConnectionPtr m_pConnection; _RecordsetPtr m_pRecordset; ::CoInitialize(NULL);
//在ADO操作中建议语句中要常用try?catch()来捕获错误信息 //因为它有时会经常出现一些想不到的错误 try {
m_pConnection.CreateInstance(\_bstr_t strConn=LinkSql.AllocSysString();
m_pConnection->Open(strConn,\
//if(m_pConnection->State == adStateOpen) MessageBox(\成功连接数据
