利用SqlDataReader实现与listview数据的绑定 问题出在哪里怎么运行不出来呢？

Question

 if (lvstudent.Items.Count >0)
            {
                lvstudent.Items.Clear();
            }
            
            string sql = "select * from Students ";
            DC dc = new DC();            SqlCommand cmd = dc.Getcmd(sql);
            SqlDataReader dr = cmd.ExecuteReader();            while (dr.Read())
            {
                string id = dr["ID"].ToString();
                string name = dr["Name"].ToString();
                string gender = dr["Gender"].ToString();
                string major = dr["Major"].ToString();
                string room = dr["Room"].ToString();
                string phone = dr["Phone"].ToString();                ListViewItem item = new ListViewItem();
                item.Text = id;
                item.SubItems.Add(name);
                item.SubItems.Add(gender);
                item.SubItems.Add(major);
                item.SubItems.Add(room);
                item.SubItems.Add(phone);
                this.lvstudent.Items.Add(item);            }
            dr.Close();        }

Answer 1

数据库连接成功 编译不报错 是错在哪里呢？
或者这样呢？窗体加载时自动绑定表中所有数据：
  string sql = "select * from Students ";
            DC dc = new DC();
            SqlDataAdapter da = new SqlDataAdapter();
            //SqlCommand cmd = dc.Getcmd(sql);
            // SqlDataReader dr = cmd.ExecuteReader();
            DataTable dt = new DataTable();
           da.Fill(dt);
          
             foreach(DataRow dr in dt.Rows)
               {
                string id = dr["ID"].ToString();
                string name = dr["Name"].ToString();
                string gender = dr["Gender"].ToString();
                string major = dr["Major"].ToString();
                string room = dr["Room"].ToString();
                string phone = dr["Phone"].ToString();                ListViewItem item = new ListViewItem();
                item.Text = id;
                item.Tag = dr;                 item.SubItems.Add(name);
                item.SubItems.Add(gender);
                item.SubItems.Add(major);
                item.SubItems.Add(room);
                item.SubItems.Add(phone);
                this.lvstudent.Items.Add(item);               }
           
        }依然没反应 ？是怎么回事

Answer 2

SqlDataAdapter da = new SqlDataAdapter(sql,dc.Getcon());
上处中一处写错

Answer 3

            ListViewItem item = new ListViewItem(new String[] { id, name, gender, major, room, phone });
this.lvstudent.Items.Add(item);