private void ShowAllInfo() { string className = this.tvwClass.SelectedNode.Text; //获取选中节点的名称(班级名称) DataView dataview = new DataView(dtClass); //通过班级表new一个DataView dataview.RowFilter = "className = '" + className + "'"; //根据班级名称筛选数据 DataTable dt = dataview.ToTable(); //获取筛选后的班级表 int classID = int.Parse(dt.Rows[0][0].ToString()); lstViewStudent.Items.Clear(); bllstudent = new BLLStudent(); dtStudent = bllstudent.GetStudentInfoClassID(classID);//查询所在班级的学生信息 if (dtStudent == null) { MessageBox.Show("該班級才剛剛建立,還沒有學生!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { for (int i = 0; i < dtStudent.Rows.Count; i++) { listview = new ListViewItem(); listview.Text = dtStudent.Rows[i][2].ToString(); listview.SubItems.Add(dtStudent.Rows[i][1].ToString()); listview.SubItems.Add(dtStudent.Rows[i][3].ToString()); listview.SubItems.Add(dtStudent.Rows[i][4].ToString()); listview.SubItems.Add(className); listview.SubItems.Add(dtStudent.Rows[i][5].ToString()); lstViewStudent.Items.Add(listview); } } tvwCourse.Nodes.Clear(); dtCourse = new DataTable(); bllcourse = new BLLCourse(); dtCourse = bllcourse.GetCourseInfoClassID(classID);//點擊班级列表時顯示課程訊息 if (dtStudent == null) { MessageBox.Show("該班級才剛剛建立,還沒有學生!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { for (int i = 0; i < dtCourse.Rows.Count; i++) { TreeNode tn = new TreeNode(className + "-" + dtCourse.Rows[i]["CourseName"].ToString()); tvwCourse.Nodes.Add(tn); } tvwCourse.SelectedNode = tvwCourse.Nodes[0]; } }
private void tvwCourse_AfterSelect(object sender, TreeViewEventArgs e) { string classCourse = e.Node.Text; string[] str = classCourse.Split('-'); string className = str[0]; string courseName = str[1]; BLLCourse bco = new BLLCourse(); DataTable dtScore = bco.GetCourseAll(); DataView dvScore = new DataView(dtScore); dvScore.RowFilter = "className='" + className + "' and courseName = '" + courseName + "'"; dgvScore.DataSource = dvScore; }