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