ListView简单显示数据

窗体属性设置：

代码如下：

     

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("server=(local);pwd=;uid=sa;database=db_02");
            con.Open();
            SqlCommand com = new SqlCommand("select * from tb_02", con);
            SqlDataReader dr = com.ExecuteReader();
            //listView1.View = View.Details;
            listView1.FullRowSelect = true;//设置选中整行数据

            while (dr.Read())
            {
                ListViewItem lv = new ListViewItem(dr[0].ToString());
                lv.SubItems.Add(dr[1].ToString());
                lv.SubItems.Add(dr[2].ToString());
                listView1.Items.Add(lv);
            }
            dr.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            listView1.Items.Clear();
        }

  

运行结果：