VB.Net 2005: Getting values from ListView.CheckedItems

The following code does not work, and I need to know why. All I want to do is get the .Text value of each ListViewItem in the ListView's CheckedItems and store it in a SQL CE database.

For Each lvItem As ListViewItem In lv.CheckedItems
                    Dim sb As New StringBuilder
                    sb.Append("INSERT INTO tbl1(Name, ID) VALUES('")
                    sb.Append(szCurrName)
                    sb.Append("', '")
                    sb.Append(lvItem.Text)
                    sb.Append("')")
                    cmdAdd.CommandText = sb.ToString
                    Try
                        cmdAdd.ExecuteNonQuery()
                    Catch sqlEx As SqlCeException
                    End Try
                Next

ThanksStart Free Trial