数据库添加到ListView,数据无法显示

Question

 {
            SqlConnection con = new SqlConnection("server=.\\SQLEXPRESS;uid=sa;pwd=1;database=Meteorology");
            con.Open();
            SqlCommand com = new SqlCommand(strName, con);
            SqlDataReader dr = com.ExecuteReader();
            listView1.View = View.Details;
            listView1.GridLines = true;
            listView1.FullRowSelect = true;
         
            
            while (dr.Read())
            {
                ListViewItem Item = new ListViewItem();
                Item.SubItems.Clear();
                Item.SubItems[0].Text = dr["studentid"].ToString();
                Item.SubItems.Add(dr["name"].ToString());
                Item.SubItems.Add(dr["sex"].ToString());
                listView1.Items.Add(Item);
            }
            dr.Close();
            con.Close();
        }

Answer 1

在ListView控件右上角的ListView任务里有个视图：改为Details

Answer 2

SqlCommand com = new SqlCommand(strName, con);
//先看看strName语句在SQL中有没数据

Answer 3

while (dr.Read())
  {
  ListViewItem Item = new ListViewItem(dr["studentid"].ToString());
  Item.SubItems.Add(dr["name"].ToString());
  Item.SubItems.Add(dr["sex"].ToString());
  listView1.Items.Add(Item);
  }