Listbox Control

B

Brian Pittman

Hi,

What would be the most efficient way to add items from a multi select
listbox control into a SQL 2K table. For example I want new record added
for each selected item in the listbox. I am able to do the task but in an
inefficient way like the code below.

For Each li In lstPDType.Items
If li.Selected = True Then
learning.Add(li.Value, objectID) 'This is a funtion that adds the
item to a table everytime
End If
Next

any help is appreciated

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,580
Members
45,054
Latest member
TrimKetoBoost

Latest Threads

Top