private void FATSemistercomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
FATCoursecomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
FATSemistercomboBox.GetItemText(FATSemistercomboBox.SelectedItem) + "' and fid='" + _fid + "' ");
FATCoursecomboBox.DisplayMember = "course_name";
}
private void FGradeB_Click(object sender, EventArgs e)
{
FGradeP.BringToFront();
FATSemistercomboBox.DataSource =
DataAccess.GetDataTable("select semister from taken_course where fId='" + _fid + "' group by semister");
FATSemistercomboBox.DisplayMember = "semister";
FATCoursecomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
FATSemistercomboBox.GetItemText(FATSemistercomboBox.SelectedItem) + "' and fid='" + _fid + "' ");
FATCoursecomboBox.DisplayMember = "course_name";
}
private void FATCoursecomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
FATdataGridView.DataSource =
DataAccess.GetDataSet(
"select serial, sid as 'student id',sname as 'student name',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='" + FATCoursecomboBox.GetItemText(FATCoursecomboBox.SelectedItem) + "'and Fid='" + _fid + "' and semister='" + FATSemistercomboBox.GetItemText(FATSemistercomboBox.SelectedItem) + "'").Tables[0];
FATdataGridView.Columns[0].Visible = false;
FATdataGridView.Columns[0].Frozen = true;
FATdataGridView.Columns[1].ReadOnly = true;
FATdataGridView.Columns[1].Frozen = true;
FATdataGridView.Columns[2].ReadOnly = true;
FATdataGridView.Columns[2].Frozen = true;
}
