private void NewChooseCourse_Load(object sender, EventArgs e) { // sqlStr = "select Class_name from Class"; // MyTool.queryDataToComno(sqlStr,"Class_name",ClassList); sqlStr = "select Course_name from Course"; MyTool.queryDataToComno(sqlStr, "Course_name", CourseList); //// string studentId = MyTool.getStudentIdByStudentName(StudentList.Text); // sqlStr = "select Student_id from Student where Student_name='" + StudentList.Text + "'"; // SqlConnection sqlconncetion1 = new SqlConnection(MyTool.connStr); // sqlconncetion1.Open(); // SqlCommand sqlcommand1 = new SqlCommand(sqlStr, sqlconncetion1); // string studentId = sqlcommand1.ExecuteScalar().ToString(); // sqlconncetion1.Close(); // sqlStr = "select Student_course.ID as 记录ID,Student_name as 学生姓名,Class_name as 班级" + // " ,Course_name as 课程,Course.Credit as 学分 from Student,Course,Student_course,Class" + // " where Student.Student_id=Student_course.Student_id and Course.Course_id=Student_course.Course_id" + // " and Class.Class_id =Student.Class_id and Student.Student_id ='" + studentId + "'"; // //填充数据表 // MyTool.queryDataToGrid(sqlStr, dataGridView1); // //填充学生下拉框 // sqlStr = "select Student_name from Student"; // MyTool.queryDataToComno(sqlStr, "Student_name", StudentList); MyTool.queryDataToComno("select Class_name from Class", "Class_name", ClassList); }
private void NewStuScore_Load(object sender, EventArgs e) { textBox1.ReadOnly = true; MyTool.queryDataToComno("select Class_name from Class", "Class_name", ClassList); }