title: Saving multiple items to SQL database
body: <p>I have some items in my listbox which I will store everyone of them into my database, what I am doing now is looping the box and call my database saving logic to save every single item. I thought this is pretty inefficient, is there anyway that I can use to batch save my items so that I don't open and close the connection as many times as my items. Thanks.</p>
  
  <pre><code> For Each item In outletToBox.Items
          .CamCode = Items.ToString
          .CamCampaignAutoID = retID
          .CamRemarks = uitxtCamRemarks.Text.Trim
  
  
         '---use savetable object to save to database table---
   Next
  </code></pre>