private void SCourseSemistercomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
SCourseSubjectcomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
SCourseSemistercomboBox.GetItemText(SCourseSemistercomboBox.SelectedItem) + "' ");
SCourseSubjectcomboBox.DisplayMember = "course_name";
}
private void button2_Click(object sender, EventArgs e)
{
SCourseP.BringToFront();
SCourseSemistercomboBox.DataSource =
DataAccess.GetDataTable("select semister from taken_course where sId='" + _sid + "' group by semister");
SCourseSemistercomboBox.DisplayMember = "semister";
SCourseSubjectcomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
SCourseSemistercomboBox.GetItemText(SCourseSemistercomboBox.SelectedItem) + "' and sid='" + _sid + "' ");
SCourseSubjectcomboBox.DisplayMember = "course_name";
}
private void SCourseSubjectcomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
sMarkdataGridView.DataSource =
DataAccess.GetDataTable(
"select mid_mark as 'MidTerm Mark',mid_grade as 'MidTerm Grade' ,final_mark as 'FinalTerm Mark',final_grade as 'FinalTerm Grade' from taken_course where course_name='" + SCourseSubjectcomboBox.GetItemText(SCourseSubjectcomboBox.SelectedItem) + "'and sid='" + _sid + "' and semister='" + SCourseSemistercomboBox.GetItemText(SCourseSemistercomboBox.SelectedItem) + "'");
}
