Getting the value of the second column of a listview

[lotus18]

Hello World

I have this code:

Windows.Forms.Cursor.Current = Cursors.WaitCursor
 
        Call Main.SetConnection()
        For i = 1 To frmSchedules.lvwSchedules.Items.Count
 
            Command = New OleDbCommand("Select * From Subjects Where SubjectCode " & _
            "Not In ('" & frmSchedules.lvwSchedules.Items(i).SubItems(1).Text & _
            "')", dbConnection)
            Command.CommandType = CommandType.Text
            Data = Command.ExecuteReader
            lvwSubjects.Items.Clear()
            While Data.Read
                Item = lvwSubjects.Items.Add(Data(0))
                Item.SubItems.Add(Data(1))
            End While
        Next i
 
        Data.Close()
        Main.CloseConnection() 'Close Connection
        Windows.Forms.Cursor.Current = Cursors.Default

Everytime I execute this it fails me. and it says InvalidArgument=Value of '9' is not valid for 'index'. My main purpose is to display only the subjects in a listview1 that are not present in a listview2. Waiting for your replies : )

Rey Sean

[Plater]

I believe you want:

For i = 1 To (frmSchedules.lvwSchedules.Items.Count -1)
 

[lotus18]

I believe you want:

For i = 1 To (frmSchedules.lvwSchedules.Items.Count -1)
 

Ah I see. I had a wrong calculations LOL. Thanks Plater.

Rey Sean