Link to home
Start Free TrialLog in
Avatar of mpdillon
mpdillon

asked on

ListView not showing Header or data

I am using VB.Net in VS 2008 . I have never used a ListView control before. I am trying to create a List view with 4 columns and one tag attached to the first column.
When I execute the attached code, I do not receive any errors. However, the ListView control does not display any Headers. The only data displayed is the Employee ID. There are no subitems.
Is my code incorrect? Is there a property of the ListView that I have set incorrectly (the only property I changed was MultiSelect. I changed it to False). Or something else?
Thanks,
pat
Private Sub LoadListView()
        Dim GMFConn As New System.Data.SqlClient.SqlConnection
        Dim GMFCmd As New System.Data.SqlClient.SqlCommand
        Dim GMFReader As System.Data.SqlClient.SqlDataReader
        Dim ParmString As String = ""
        Dim FirstString As String = ""
        Dim LastString As String = ""
        Dim EmpIDNoString As String = ""
        Dim IDNoLong As Long = 0
        Dim CrewString As String = ""
        Dim LineString As String = ""
        Dim ColumnHeaderListView As ColumnHeader
        Dim ListItem As ListViewItem
        '
        Me.lvwEmployee.Clear()
        '
        'Add Header columns
        ColumnHeaderListView = New ColumnHeader
        ColumnHeaderListView.Text = "Employee ID"
        Me.lvwEmployee.Columns.Add(ColumnHeaderListView)
        '
        ColumnHeaderListView = New ColumnHeader
        ColumnHeaderListView.Text = "First Name"
        Me.lvwEmployee.Columns.Add(ColumnHeaderListView)
        '
        ColumnHeaderListView = New ColumnHeader
        ColumnHeaderListView.Text = "Last Name"
        Me.lvwEmployee.Columns.Add(ColumnHeaderListView)
        '
        ColumnHeaderListView = New ColumnHeader
        ColumnHeaderListView.Text = "Crew"
        Me.lvwEmployee.Columns.Add(ColumnHeaderListView)
        '
        ColumnHeaderListView = Nothing
        '
        GMFConn.ConnectionString = GMFConnStringPublic
        GMFConn.Open()
        GMFCmd.Connection = GMFConn
        '
        ParmString = "Select IDNo, EmpIdNo,FirstName, LastName,Crew From GMFEmployee Order by FirstName"
        GMFCmd.CommandText = ParmString
        GMFReader = GMFCmd.ExecuteReader
        Do While GMFReader.Read
            If GMFReader.IsDBNull(0) Then IDNoLong = 0 Else IDNoLong = GMFReader.Item("IDNo")
            If GMFReader.IsDBNull(1) Then EmpIDNoString = "" Else EmpIDNoString = GMFReader.Item("EmpIDNo").ToString.Trim
            If GMFReader.IsDBNull(2) Then FirstString = "" Else FirstString = GMFReader.Item("FirstName").ToString.Trim
            If GMFReader.IsDBNull(3) Then LastString = "" Else LastString = GMFReader.Item("LastName").ToString.Trim
            If GMFReader.IsDBNull(4) Then CrewString = "" Else CrewString = GMFReader.Item("Crew").ToString.Trim
            If Val(EmpIDNoString) > 0 Then
                ListItem = New ListViewItem
                ListItem.Tag = IDNoLong
                ListItem.Text = EmpIDNoString
                ListItem.SubItems.Add(FirstString)
                ListItem.SubItems.Add(LastString)
                ListItem.SubItems.Add(CrewString)
                Me.lvwEmployee.Items.Add(ListItem)
            End If
        Loop
        GMFReader.Close()
        '
        GMFCmd.Dispose()
        GMFConn.Close()
        GMFConn.Dispose()
        ListItem = Nothing
    End Sub

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think ListView.View property of lvwEmployee is Title and you need Details.
Avatar of mpdillon
mpdillon

ASKER

The view Property was set to Large Icon. Setting it to Details worked great. Thank you.