D
David
How do I reference selected items in a listbox that resides inside a View of
a MultiView? My code is below but it does not work. Thanks.
David
Dim listRow As ListItem
For Each listRow In LstCompanyNotHave.Items
If listRow.Selected = True Then
strSQL = "INSERT INTO tblLinkStaffCompany" & _
" (PersonID, CompanyID)" & _
" VALUES" & _
" (" & lngpid & ", " & listRow.Value & ")"
cmd = New OleDbCommand(strSQL, conWcccuData)
cmd.ExecuteNonQuery()
intUpdated = intUpdated + 1
End If
Next
a MultiView? My code is below but it does not work. Thanks.
David
Dim listRow As ListItem
For Each listRow In LstCompanyNotHave.Items
If listRow.Selected = True Then
strSQL = "INSERT INTO tblLinkStaffCompany" & _
" (PersonID, CompanyID)" & _
" VALUES" & _
" (" & lngpid & ", " & listRow.Value & ")"
cmd = New OleDbCommand(strSQL, conWcccuData)
cmd.ExecuteNonQuery()
intUpdated = intUpdated + 1
End If
Next