{
CRecordset m_recordSet=&m_database;
m_recordSet.Open(CRecordset::forwardOnly,strSQL); m_recordSet.Close(); //查出该课程的课程号
m_recordSet.Open(CRecordset::forwardOnly,strSQL); m_recordSet.Close();
m_recordSet.GetFieldValue("student_no",student_no);
strSQL.Format("select * from course where active_status='Y' and course_name='%s'",course); m_recordSet.GetFieldValue("course_no",course_no);; BOOL CScoreAddDlg::OnInitDialog()
CDialog::OnInitDialog(); CRecordset m_recordSet; if(!m_database.IsOpen()) { }
CString strSQL;
strSQL.Format("select course_name from course where active_status='Y'"); for(int i=0;i<m_recordSet.GetRecordCount();i++){ }
m_recordSet.Close();
strSQL.Format("select student_name from student where active_status='Y'"); for(int j=0;j<m_recordSet.GetRecordCount();j++){ }
m_recordSet.Close(); { } return true;
this->SetWindowText("成绩窗口"); CString temp;
m_recordSet.GetFieldValue("student_name",temp); m_cStudent.AddString(temp); CString temp;
m_recordSet.GetFieldValue("course_name",temp); m_cCourse.AddString(temp); m_database.Open(_T("student")); m_recordSet.m_pDatabase=&m_database;
m_recordSet.Open(CRecordset::forwardOnly,strSQL);
m_recordSet.MoveNext();
m_cCourse.SetCurSel(1);
m_recordSet.Open(CRecordset::forwardOnly,strSQL);
m_recordSet.MoveNext();
m_cStudent.SetCurSel(1);
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,免费范文网,提供经典小说教育文库SQL server2008数据库课程设计范例——学生成绩管理系统(9)在线全文阅读。
相关推荐: