I am using VB.net 2003 and access database
What I am trying to do is load some data from 2 different table in a list view and then save listview data in a 3rd table
I am getting an error
[u]Cast from string "TaskID" to type "Single" is not valid</u>
Task ID is a Numbet declared type Single in Accesss DataBase

here is my code

Sub Meupdate()

        Dim newRow As dstransection.tblRentalOutRow
        Dim Item As ListViewItem
        Dim result As String

'Updating the MS ACCESS table EmployeeTask from listview

        Try

            newRow = Dstransection1.tblRentalOut.NewRow()
            newRow("EmployeeID") = txtEmpID.Text

'TaskID is a number type single in Access DataBase

            newRow("TaskID") = lvwRental.Columns(CSng("TaskID"))
            newRow("DateFinished") = Today
            newRow("DateStarted") = lvwRental.Columns("DateStarted")


  Catch except As Exception
            MessageBox.Show(except.Message, except.GetType.ToString())
        End Try



    End Sub

Will one of you experts to help this beginer programmer.

yvk

__________________
yvk

Check the value of the following in your program:

newRow("TaskID") = lvwRental.Columns(CSng("TaskID"))

My guess would be that the lvwRental.Column is an empty string which cannot be typed as a Single numeric value.




Best Regards,
Earl Francis