title: N-number of arrays or Collection?
body: <p>How can I move from using n number of arrays to using list with the following example. I'm trying to find out if using a Collection would be better? Or even how can I attempt to do this?</p>
  
  <p><strong>eg</strong> </p>
  
  <pre><code>    params(0, 0) = "guid" 'store procedure variable name
      params(0, 1) = "S" 'data type
      params(0, 2) = strGUID 'value
  </code></pre>
  
  <p><strong>Update:</strong></p>
  
  <p>After trying @christiandev suggestion.</p>
  
  <p>How could store this in a variable?</p>
  
  <pre><code>Dim sqlparams = New List(Of MySqlParameter)()
  Dim param = New MySqlParameter("?iguid", MySqlDbType.String, strGUID)
  </code></pre>
  
  <p><code>ds = objMySQL.getDataSetFromStoredProcedure("get_user_credits", "credits", param, DBName)</code></p>
  
  <pre><code>Error message
  - Value of msql type cannot be converted into a System.Array
  </code></pre>