title: ASP.NET : Filter unique rows from Data table
body: <p>Hi i am using data table in asp.net. I am not able to get how can we filter unique data from data table .</p>
  
  <p>Problem is describe below</p>
  
  <pre><code>Data Table:
  Consumer No Date             Value
  ABC001           1st Aug 09 1
  ABC001           1st Aug 09 2
  ABC001           2nd Aug 09 1
  XYZ001           1st Aug 09 1
  XYZ002           1st Aug 09 1
  XYZ002           1st Aug 09 2
  </code></pre>
  
  <p>I would like following output based upon filter applied over first and second column. In output we can see that there is unique combination of first and second column.</p>
  
  <pre><code>Consumer No Date             
  ABC001           1st Aug 09 
  ABC001           2nd Aug 09 
  XYZ001           1st Aug 09 
  XYZ002           1st Aug 09
  </code></pre>
  
  <p>How can i apply filter on data table?   </p>