How to display records in the listview control?

Question

I'm trying to use listview control in vb.net or vb2008 express edition to display records from my database after it is being queried.I have two column headers in my listview control which are named Account# and Authorized Users. I was able to display the records from the database into the listview control but i don't know how to arrange it in a proper column where it should be displayed cause what happen is all records are being combined in one column which other records should be aligned to the other column.What I want is to display the account numbers in aligned with the Account# column header and the names should be aligned in Authorized Users column header. Here's the codes I used:

***************************************************************** Private Sub Button1_Click(-------------) Handles Button1.Click Dim db As New memrecDataContext Dim au = From ah In db.Table1s _ Where ah.Account <> " " For Each ah In au With Form9.ListView1.Items Form9.ListView1.Items.Add(ah.Account) Form9.ListView1.Items.Add(ah.Name) Form9.Show() End With Next End Sub *********************************************************

I would greatly appreciate if you could correctly debug the codes for me?

xpda · Accepted Answer · 2009-11-27 08:00:52Z

In listview, details mode, both columns are in a single listview item. The first column is item.text, and the rest are in item.subitems, something like this:

dim item as ListViewItem ListView1.Columns.Add("Account") ListView1.Columns.Add("Name") For Each ah In au item = New ListViewItem item.text = ah.Account item.subitems.add(ah.Name) form9.listview1.items.add(item) next ah

A couple of notes: You should not show the form every time you add an item to the listview. You're better off showing the form only once. Second, the With statement is used to shortcut writing form9.listview.items. Inside the With block you can use just a period (.) instead of writing out form9.listview.items.

+1 for the answer and correcting the misuse of the with keyword.
Thanks -- if it's the correct answer, you can click on the checkmark to mark it.

Collectives™ on Stack Overflow

How to display records in the listview control?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related