title: Get distinct values from a column of DataTable in .NET 2.0
body: <p>I am working on a legacy project which was developed using .NET Framework 2.0.
  In this project, I get distinct values from <code>DataRowCollection</code> by <code>ItemNo</code> column. I am only interested in <code>ItemNo</code>. The <code>DataRow</code> consist of <code>ItemNo</code>, <code>Qty</code> and <code>Date</code>.</p>
  
  <p>I am thinking of iterating the <code>DataRowCollection</code> and adding the unique <code>ItemNo</code> into a list of string as below (not tested)</p>
  
  <pre><code>var items =  new List&lt;string&gt;();
  foreach (DataRow orderItem in rows)
  {
       var itemNo = orderItem["ITEMNO"].ToString().Trim();
       if(items.Find(delegate(string str) { return str == itemNo ;}) == null)
       {
              items.Add(itemNo);
       }
   }
  </code></pre>
  
  <p>Is there a better way of doing this without LINQ (.Net Framework 2.0 doesnt like LINQ)</p>