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
            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
        End Try
    End Sub

this is my code to display my items on list view

Private Sub Loader()

        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?

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