0

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
2
Views
6 Years
Discussion Span
Last Post by CodeWord
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.