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; }