示例#1
0
        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";
        }
示例#2
0
        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";
        }
示例#3
0
        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;
        }