title: How to store database resultset?
body: <p>I want to know which is the best way to store database value in <code>vb.net</code>, For example, I've this code:</p>
  
  <pre><code> Dim conn As MySqlConnection = Connection() 'Return a connection obj
   conn.Open()
  
   Dim transaction = conn.BeginTransaction
   Dim cmd = New MySqlCommand("SELECT * FROM tb ORDER BY ID")
   Dim ResultSet = Cmd.ExecuteReader
  
   If ResultSet.HasRows Then
  
      Do While ResultSet.Read
  
         'Here the value should be store
  
      Loop
  
   End if
  </code></pre>
  
  <p>How you can see I take all table from my database, now I want store each records in a structure that allow me to access it like the table. An array is good for do this? A list? Which is the best way?</p>