VB6: Inserting/Updating Listbox Values into Stor Proc

I have a form which has several textboxs these values are gathered up and placed into Hold variables then passed to a sroted procedure for insert/update into the database. One textbox is ClassCode I have a submit button that is used to submit one classcode however I also have a button that will apply all the changes to all classcodes for that selected course

ie: Course = "Home Repare"
ClassCode1 ="Installing Tilt"
ClassCode2 = "Sink Instulation"
ClassCode3 = "Roof Repare"

Each of the ClassCodes has it's own guid associated with the guid of "Home Repare"
Now to my question.
How can I pass the values from a listbox( Containes the all the ClassCode values for the selected course ) to a stored procedure and loop through the values to insert/update the database without opening and closing the connection for each ClassCode?

Assuming: Visual Basic 6
Put the textboxes in an array!
All your textboxes should be called ClassCode.
Try it -- VB will ask if you want to put the second one in a "control array". Click yes.
Now after doing this, make sure the Index numbers are in the right order.
This should make it simpler.