c# listview ,listbox

 lisrview

private void LoadData()
        {
            listView1.Columns.Add("姓名", 50, HorizontalAlignment.Right);
            listView1.Columns.Add("电话",60,HorizontalAlignment.Center);
            listView1.Columns.Add("邮箱",80,HorizontalAlignment.Center);
            listView1.Columns.Add("公司",100,HorizontalAlignment.Center);

            OleDbConnection con = new OleDbConnection(connString);
            con.Open();
            OleDbCommand cmd = new OleDbCommand("select * from linker",con);
            OleDbDataReader dr = cmd.ExecuteReader();
            while(dr.Read())
            {
                ListViewItem lvi = new ListViewItem();
                lvi.ImageIndex = 1;
                lvi.SubItems.Clear();
                lvi.SubItems[0].Text = dr["id"].ToString();
                lvi.SubItems.Add(dr["l_name"].ToString());
                lvi.SubItems.Add(dr["phonenum"].ToString());
                lvi.SubItems.Add(dr["e-mail"].ToString());
                listView1.Items.Add(lvi);
           
            }

       
        }

 

listbox

 

 private void loadlistbox()
        {
            OleDbConnection con = new OleDbConnection(connString);
            con.Open();
            OleDbCommand cmd = new OleDbCommand("select * from linker", con);
            OleDbDataAdapter adp = new OleDbDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            listBox1.DataSource = ds.Tables[0];
            listBox1.DisplayMember = "l_name";
            listBox1.ValueMember = "id";

        }