[sigridish]

this shows up whenever i hit the save button.

Dim iCount As Integer
        Dim iLoop As Integer
        Dim query3 As New MySqlCommand
        Dim lvitem

        ConnectDatabase()
        conn.Open()
        iCount = lvLogs.Items.Count
        If Not lvLogs.Items.Count = 0 Then
            Do Until iLoop = lvLogs.Items.Count
                lvitem = lvLogs.Items.Item(iLoop)
                With lvitem
                    query3.CommandText = "insert into wer(CustomerName, SalesGroup, CustomerType, TypeOfIndustry, RM, SenioRM) values " _
                    & "('" & .SubItems(0).Text & "','" & .SubItems(1).Text & "','" & .SubItems(2).Text & "','" & .SubItems(3).Text & "','" & .SubItems(4).Text & "','" & .SubItems(5) & "')"
                    query3.ExecuteNonQuery()
                End With
                iLoop = iLoop + 1
                lvitem = Nothing
                MessageBox.Show("Record added!")
            Loop

        End If

thats my code

i've attached my project

Attached File(s)

•  browse.zip (162.59K)
  Number of downloads: 17

[DimitriV]

Okay... Dim lvitem As What exactly? You haven't given it a type.

[sigridish]

what type should i assign to it?

[DimitriV]

What about Dim lvitem As Object?

[sigridish]

it still has the same error kindly help me. i have been doing this for a week

[DimitriV]

I don't see a declaration for LvLogs anywhere?

[sigridish]

lgLogs is the name of my istview

[smohd]

Please avoid duplicate threads. You already have a topic about this here
*Topic closed*