title: Querying A Datable Using Linq Returning Distinct Values
body: <p>I am attempting to get distinct values from a datatable column. here is my code..</p>
  
  <pre><code>var sourceItems = ds.Tables[0].AsEnumerable()
                                .GroupBy(x =&gt; x.Field&lt;string&gt;("Source").ToString())
                                .Select(x =&gt; x.First());
  ddlSource.DataSource = sourceItems;
  ddlSource.DataBind();
  </code></pre>
  
  <p>This code is returning 4 rows of <code>System.Data.DataRow</code> as the values. I need the actual values stored in the rows not the row type. Also is this code a proper way to grab only distinct values in the column?</p>