title: Retrieve distinct values from datatable using linq vb.net
body: <p>I am trying to retrieve all of the distinct values from a particular column in a datatable.  The column name in the datatable is "Count".  I have 2240 rows and I have 6 distinct values in the "Count" column.  The problem is, when I execute the following code, it is giving me the number of rows rather than the 6 distinct values.</p>
  
  <pre><code>Dim counts = (From row In loadedData
  Select row.Item("Count")).Distinct()
  For Each i In counts
      MsgBox(i)
  Next
  </code></pre>
  
  <p>How can I modify this to retrieve the 6 distinct values, rather than it giving me the total number of rows?</p>