Exemplo n.º 1
0
        private void StudentList_SelectedIndexChanged(object sender, EventArgs e)
        {
            textBox2.Text = "";
            textBox1.Text = "";
            string studentId = MyTool.getStudentIdByStudentName(StudentList.Text);
            string sqlStr    = "select Student_course.ID as 记录ID,Student_name as 学生姓名,Class_name as 班级" +
                               " ,Course_name as 课程, Student_course.Score 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);
        }
Exemplo n.º 2
0
        private void StudentList_SelectedIndexChanged(object sender, EventArgs e)
        {
            //string studentId = MyTool.getStudentIdByStudentName(StudentList.Text);
            //string 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);
            //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);
            string studentId = MyTool.getStudentIdByStudentName(StudentList.Text);
            string sqlStr    = "select Student_course.ID as 记录ID,Student_name as 学生姓名,Class_name as 班级" +
                               " ,Course_name as 课程, Student_course.Score 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);
        }