在gridview中检索记录 [英] retrieving records in gridview

问题描述

public List<Student> Getlist()
       {

           List<Student> s = new List<Student>();

           Student sd = new Student();
           cmd = new SqlCommand("Select stdid, studname from Students", con);
           con.Open();
           dr = cmd.ExecuteReader();
               while (dr.Read())
               {
                   sd.studentid = (int)dr[0];
                   sd.studentname = (string)dr[1];
                   s.Add(sd);
               }

           return s;
           con.Close();
       }

它显示7次相同的记录
我必须更改的地方
请帮助我.

it is displaying same records 7 times
where i have to change
please help me.

推荐答案

//Student sd = new Student();
          cmd = new SqlCommand("Select stdid, studname from Students", con);
          con.Open();
          dr = cmd.ExecuteReader();
              while (dr.Read())
              {
                  Student sd = new Student(); //GOES OVER HERE
                  sd.studentid = (int)dr[0];
                  sd.studentname = (string)dr[1];
                  s.Add(sd);
              }

          return s;

这篇关于在gridview中检索记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！