I have a table called Where_Used that has a column called Rig_ID. The windows form has a combobox called cmbrigs. I know the process of writing a stored procedure but not the code that goes inside it. What I am trying to find out is what code I need to place into the stored procedure and how to write to the procedure in vb.net 2005 to do the following: -
The combobox has multiple separate items in it and I would like the stored procedure to write each individual item to the column rig_ID in the Where_Used table using a loop in the stored procedure instead of using a loop and multiple insert commands in vb.net
Hope this makes sense. In a nut shell I would like the stored procedure to do the loop to enter the combobox data to the table.