title: How to setup Listview when receiving data from database
body: <p>I can print my data to listview, but the result is totally messed up. how do i setup my listview properly?</p>
  <pre><code>Do While Not rs.EOF
  
     listRecentTransactions.Items.Add(rs.Fields(&quot;BetID&quot;).Value)
     listRecentTransactions.Items.Add(rs.Fields(&quot;FightNumber&quot;).Value)
     listRecentTransactions.Items.Add(rs.Fields(&quot;BetOption&quot;).Value)
     listRecentTransactions.Items.Add(rs.Fields(&quot;Amount&quot;).Value)
     listRecentTransactions.Items.Add(rs.Fields(&quot;TransactionDate&quot;).Value)
     listRecentTransactions.Items.Add(rs.Fields(&quot;Barcode&quot;).Value)
     i = i + 1
  rs.MoveNext()
  Loop
  </code></pre>
  <p>heres the result</p>
  <p><a href="https://i.stack.imgur.com/rHktT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rHktT.png" alt="enter image description here" /></a></p>