samedi 14 février 2015

ERROR: value of 1 is not valid for index. When two or more checkboxes are checked


For i = 0 To lviadmn.Items.Count - 1
lviadmn.Items(i).Checked = True
For Each item As ListViewItem In lviadmn.CheckedItems


insert to database (btw I'm using access)



sqlcmd.CommandText = "INSERT INTO tbl_countersecond (queservnum, questdname) VALUES ('" & lviadmn.Items(i).SubItems(0).Text & "', '" & lviadmn.Items(i).SubItems(1).Text & "')"

MsgBox("RECORD SUCCESSFULLY FORWARDED", MsgBoxStyle.OkOnly, "QUEUE")
sqlcmd.ExecuteNonQuery()




Aucun commentaire:

Enregistrer un commentaire