private void FATTENSemistercomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
FATTENCoursecomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
FATTENSemistercomboBox.GetItemText(FATTENSemistercomboBox.SelectedItem) + "' and fid='" + _fid + "' ");
FATTENCoursecomboBox.DisplayMember = "course_name";
}
private void FAttB_Click(object sender, EventArgs e)
{
FAttP.BringToFront();
FATTENSemistercomboBox.DataSource =
DataAccess.GetDataTable("select semister from taken_course where fId='" + _fid + "' group by semister");
FATTENSemistercomboBox.DisplayMember = "semister";
FATTENCoursecomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
FATTENSemistercomboBox.GetItemText(FATTENSemistercomboBox.SelectedItem) + "' and fid='" + _fid + "' ");
FATTENCoursecomboBox.DisplayMember = "course_name";
}
private void FATTENCoursecomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
FATTdataGridView.DataSource =
DataAccess.GetDataSet(
"select serial,sid as 'Student id',sname as'Student Name', day1,day2,day3,day4,day5 from taken_course where course_name='" + FATTENCoursecomboBox.GetItemText(FATTENCoursecomboBox.SelectedItem) + "'and fid='" + _fid + "' and semister='" + FATTENSemistercomboBox.GetItemText(FATTENSemistercomboBox.SelectedItem) + "'").Tables[0];
FATTdataGridView.Columns[0].Visible = false;
FATTdataGridView.Columns[0].Frozen = true;
FATTdataGridView.Columns[1].Frozen = true;
FATTdataGridView.Columns[1].ReadOnly = true;
FATTdataGridView.Columns[2].Frozen = true;
FATTdataGridView.Columns[2].ReadOnly = true;
}