关于dataGridView显示数据的问题
这个项目中涉及到两张表联查 sql语句:select Teacher.name,Teacher.age,Teacher.teachYear,Grade.GradeName from Teacher inner join Grade on Teacher.gradeId = Grade.GradeId
我在实体类中的 Teacher类添加了一个Grade类型的字段和属性 在构造中new了一下 如下:
public Teacher(string name,int age ,int teachYear,string greadName) { this.Name = name; this.Age = age; this.TeachYear = teachYear; this.Gread = new Grade(); Gread.GreadName = greadName; }
while (read.Read()) { Teacher teacher = new Teacher(); teacher.Name = Convert.ToString(read["name"]); teacher.Age = Convert.ToInt32(read["age"]); teacher.TeachYear = Convert.ToInt32(read["teachYear"]); teacher.Gread.GreadName = Convert.ToString(read["GradeName"]); list.Add(teacher); }