private void SATScomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
sATCoursecomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
SATSemistercomboBox.GetItemText(SATSemistercomboBox.SelectedItem) + "' and sid='" + _sid + "' ");
sATCoursecomboBox.DisplayMember = "course_name";
}
private void SAttendenceB_Click(object sender, EventArgs e)
{
AttendencePanel.BringToFront();
SATSemistercomboBox.DataSource =
DataAccess.GetDataTable("select semister from taken_course where sId='" + _sid + "' group by semister");
SATSemistercomboBox.DisplayMember = "semister";
sATCoursecomboBox.DataSource =
DataAccess.GetDataTable("select course_name from taken_course where semister='" +
SATSemistercomboBox.GetItemText(SATSemistercomboBox.SelectedItem) + "' and sid='" + _sid + "' ");
sATCoursecomboBox.DisplayMember = "course_name";
}
private void sATCNcomboBox_SelectedIndexChanged(object sender, EventArgs e)
{
SATdataGridView.DataSource =
DataAccess.GetDataTable(
"select day1,day2,day3,day4,day5 from taken_course where course_name='" + sATCoursecomboBox.GetItemText(sATCoursecomboBox.SelectedItem) + "'and sid='" + _sid + "' and semister='" + SATSemistercomboBox.GetItemText(SATSemistercomboBox.SelectedItem) + "'");
}
