Member Avatar for bestex

Hi im having a problem on displaying my Date ng my listview
here is my code

Private Sub frmTransaction_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Try
            IsConnected("Select CONCAT(person.lastName, ',',person.firstName,' ',person.middleName) AS FullName, transaction.transactionDate from transaction INNER JOIN person ON person.personId = transaction.personId", False)
            Call Loader()
        Catch ex As MySqlException
            MsgBox(ex.Message)
        End Try
    End Sub

this is my code to display my items on list view

Private Sub Loader()

        LV.Items.Clear()
        While (myDR.Read())
            With LV.Items.Add(myDR("FullName"))
                 .SubItems.Add(myDR("transactionDate")) '<----- ERROR!

            End With
        End While
    End Sub

im having a problem to display my date.. can anyone fix my code?

  • 2 Contributors
  • 1 Reply
  • 58 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by CodeWord
Member Avatar for CodeWord

Would you be so kind as to tell us the exact error message?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.