Display multiple columns from Database in ListView

Question

I'm not sure why this isn't working. I'm trying to display 2 columns from my database side by side in a listview box on my form. When I use this it doesn't display any of the data correctly.

    ("SELECT Person FROM tblPeople" + " SELECT Occur FROM tblpeople" , conn);  

try
{
    SqlDataReader reader = cmd.ExecuteReader();

    while (reader.Read())
    {
       listView1.Items.Add(reader["People"].ToString());
       listView1.Items.Add(reader["Occur"].ToString()); 
    }

So i'm looking for my data to display like this:

    John   3
    James  4
    Frank  1

As the names are coming from column People and the numbers are coming from column Occur.

Why don't you just put SELECT person, occur FROM tblpeople? — MarioDS
– MarioDS, Commented Apr 30, 2012 at 21:54
Good tip! I'll change it to that but that doesn't really answer what I asked. — user1353517
– user1353517, Commented Apr 30, 2012 at 21:55
Please don't prefix your titles with "C#" and such. That's what tags are for. — John Saunders
– John Saunders, Commented Apr 30, 2012 at 22:05

digEmAll · Accepted Answer · 2012-04-30 22:09:45Z

4

To get the desired effect, you should set the view style to Details and add the second column value as sub-item.

Basically, you should do something like this:

  listView1.View = View.Details;

  listView1.Columns.Add("People");
  listView1.Columns.Add("Occur");

  while (reader.Read())
  {
      var item = new ListViewItem();
      item.Text = reader["People"].ToString();        // 1st column text
      item.SubItems.Add(reader["Occur"].ToString());  // 2nd column text
      listView1.Items.Add(item);
  }

edited Apr 30, 2012 at 22:09

answered Apr 30, 2012 at 22:02

digEmAll

57.3k9 gold badges118 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

digEmAll Over a year ago

@user1353517: Good. However, if you want to display tables you might also have a look at DataGridView's ;)

walther · Accepted Answer · 2012-04-30 21:59:14Z

0

Method Add() adds every time a new item to the collection. If your item consists of values from two objects, probably the easiest way would be to create a new item to encapsulate it, so you can easily bind it to your controls.

Consider something like this:

public class MyNewObject
{
    public string People { get;set; }
    public string Occur { get;set; }

    public MyNewObject(string p, string o)
    { 
        People = p;
        Occur = o;
    }
}

and then just

while (reader.Read())
{
    listView1.Items.Add(new MyNewObject(reader["People"].ToString(),reader["Occur"].ToString()));
}

answered Apr 30, 2012 at 21:59

walther

13.6k5 gold badges44 silver badges67 bronze badges

Collectives™ on Stack Overflow

Display multiple columns from Database in ListView

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related