动态更新combox下拉选项

以学生选课为例：
要求：
想让combox里的选项随另一个窗体中的dataGreatview里的值变化，有一个老师登录进老师界面， 他有发布两门课程，然后我要查看某一门课里的学生人数。我的课程和combox里的下拉菜单对应起来，如果我再添加课程，combox的选项也要跟着增加。如果换一-个老师登录的话，combox里也要随另一个登录人变化
思路：
先要在窗体加载时，让combox下的选项取值。
将某个老师的所有课程提出来放在一个临时的DataTable里，然后combox在这个临时的DT中取值。
动态更新combox代码：

private void TeacherStudentManger_Load(object sender, EventArgs e)
        {
            try
            {
                //加载数据库数据到dt
                string name = Teacher.name;//找哪个老师下的课程
                string sql = string.Format(@"select courseName from SelectCourse where courseTeacher='{0}' ", name);
                DataTable dt = DBHelper.GetDataTable(sql);
                this.comboBox1.Items.Add("全部");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string zhi = dt.Rows[i].ItemArray[0].ToString();//找到对应老师的每门课
                    this.comboBox1.Items.Add(zhi);//将找到的值放入combox里去
                }
                this.comboBox1.Text = "全部";
                sql = string.Format(@"select distinct stuName,stuSex,stuNumber,ClassName,stuMajor, collegesDepartments from MySelectCourse left join SelectCourse on MySelectCourse.selectCourseID=SelectCourse.selectCourseID 
							 left join Student on MySelectCourse.stuID=Student.stuID
							 left join CollegesAndDepartments on Student.collegesID=CollegesAndDepartments.collegesID
							 left join Class  on Class.ClasId=Student.ClassID where courseTeacher='{0}' and state=0", Teacher.name);
                dataGridView1.DataSource = DBHelper.GetDataTable(sql);
            }
            catch
            {
                
            }
        }

根据combox的选项显示对应datagridtview，并不是用使用datagridtview的加载事件，而是用combox的SelectedIndexChanged事件。代码如下：

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            string value = this.comboBox1.Text;
            if (value == "全部")
            {
                string sql = string.Format(@"select distinct stuName,stuSex,stuNumber,ClassName,stuMajor, collegesDepartments from MySelectCourse left join SelectCourse on MySelectCourse.selectCourseID=SelectCourse.selectCourseID 
							 left join Student on MySelectCourse.stuID=Student.stuID
							 left join CollegesAndDepartments on Student.collegesID=CollegesAndDepartments.collegesID
							 left join Class  on Class.ClasId=Student.ClassID where courseTeacher='{0}' and state=0", Teacher.name);
                dataGridView1.DataSource = DBHelper.GetDataTable(sql);
            }
            else
            {
                string sql = string.Format(@"select stuName,stuSex,stuNumber,ClassName,stuMajor, collegesDepartments from MySelectCourse left join SelectCourse on MySelectCourse.selectCourseID=SelectCourse.selectCourseID 
							 left join Student on MySelectCourse.stuID=Student.stuID
							 left join CollegesAndDepartments on Student.collegesID=CollegesAndDepartments.collegesID
							 left join Class  on Class.ClasId=Student.ClassID where courseTeacher='{0}' and courseName='{1}' and state=0", Teacher.name, value);
                dataGridView1.DataSource = DBHelper.GetDataTable(sql);
            }
        }