private void search_Click(object sender, EventArgs e) { dao.resultDao dao = new dao.resultDao(); dao.studentDao sdao = new dao.studentDao(); List <model.Result> rs = new List <model.Result>(); rs = dao.selectStudent(textBox1.Text, comboBox1.Text, comboBox2.Text);//学生编号s List <model.Student> s = new List <model.Student>(); s = sdao.selectStudent(rs);//根据学生编号s查询出所有的学生信息 DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("学号", typeof(string)); dt.Columns.Add("性别", typeof(String)); dt.Columns.Add("学院", typeof(string)); dt.Columns.Add("专业", typeof(String)); dt.Columns.Add("年级", typeof(String)); dt.Columns.Add("班级", typeof(String)); foreach (model.Student a in s) { dt.Rows.Add(a.Student_name, a.Id_number, a.Sex, a.Student_academy, a.Profession, a.Student_grade, a.Classs); } dataGridView1.DataSource = dt; }
//录入成绩 private void button1成绩_Click(object sender, EventArgs e) { string course = comboBox1成绩.Text; if (course == "") { MessageBox.Show("请选择需要录入的课程!"); } else { dataGridView1成绩.Rows.Clear(); //coursedao cdao = new coursedao(); string[] c = course.Split(' '); string cour = c[0]; dao.resultDao rdao = new dao.resultDao(); List <model.Result> rs = new List <model.Result>(); rs = rdao.selectResult(cour); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dao.studentDao sdao = new dao.studentDao(); Console.WriteLine("姚雅丽"); dt.Columns.Add("学号", typeof(string)); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("性别", typeof(string)); dt.Columns.Add("类型", typeof(string)); dt.Columns.Add("成绩", typeof(string)); foreach (DataGridViewColumn co in dataGridView1成绩.Columns) { if (co.Index != 4 && co.Index != 3) { co.ReadOnly = true; } } foreach (model.Result r in rs) { model.Student s = new model.Student(); s = sdao.selectNum(r.Student_num); dataGridView1成绩.Rows.Add(r.Student_num, s.Student_name, s.Sex, "", ""); } } }