ListView 绑定数据示例

listview属性设置：

代码如下：

        private void Form1_Load(object sender, EventArgs e)
        {
            getsource();
        }

        //listview读取数据
        public void getsource()
        {
            string connStr = "Server=.;Database=db_02;User=sa;Pwd=";
            using(SqlConnection myConn=new SqlConnection(connStr))
            {
                myConn.Open();
                listView1.View = View.Details;
                listView1.FullRowSelect = true;
                SqlCommand myComm = new SqlCommand("select * from tb_04",myConn);
                SqlDataReader myReader = myComm.ExecuteReader();
                while(myReader.Read())
                {
                    ListViewItem lvItem = new ListViewItem(myReader[1].ToString());
                    listView1.Items.Add(lvItem);
                }
                myConn.Close();
                myReader.Close();
            }
        }


        //在listview选择列时读取数据
        public void getSource(string username)
        {
            string conn = "Server=.;Database=db_02;User=sa;Pwd=";
            using(SqlConnection myConn=new SqlConnection(conn))
            {
                myConn.Open();
                SqlCommand myComm = new SqlCommand("select * from tb_04 where 人员姓名='"+username +"'",myConn);
                SqlDataReader myReader = myComm.ExecuteReader();
                while(myReader.Read())
                {
                    textBox1.Text = myReader[0].ToString();
                    textBox2.Text = myReader[1].ToString();
                    textBox3.Text = myReader[2].ToString();
                    textBox4.Text = myReader[3].ToString();
                    textBox5.Text = myReader[4].ToString();
                    textBox6.Text = myReader[5].ToString();
                    textBox7.Text = myReader[6].ToString();
                }
                myConn.Close();
                myReader.Close();

            }
        }

        public string name;//listview选择行时的姓名
        private void listView1_Click(object sender, EventArgs e)
        {
            name = listView1.SelectedItems[0].SubItems[0].Text;
            if (name!= null)
            {
                getSource(name);
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if(textBox2.Text=="")
            {
                MessageBox.Show("请选择要修改的信息","提示");
            }
            else
            {
                //此处可以加入更新数据库的语句
                MessageBox.Show("修改成功", "提示");
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

运行结果：