title: how to remove empty strings from list, then remove duplicate values from a list
body: <p>Lets say I have a list of some column values coming from a table, how do I remove empty strings and duplicate values. Please see the following code:</p>
  
  <pre><code>List&lt;string&gt; dtList = dtReportsList.AsEnumerable().Select(dr =&gt; dr.Field&lt;string&gt;("column1")).ToList();
  </code></pre>
  
  <p>This is what I have coded just now but but Amiram's code is way more elegant, so I will choose  that answer here is how I did it:</p>
  
  <pre><code>DataTable dtReportsList = someclass.GetReportsList();
  
          if (dtReportsList.Rows.Count &gt; 0)
         { 
             List&lt;string&gt; dtList = dtReportsList.AsEnumerable().Select(dr =&gt; dr.Field&lt;string&gt;("column1")).ToList();
             dtList.RemoveAll(x=&gt;x == "");
             dtList = dtList.Distinct().ToList();         
  
             rcboModule.DataSource = dtList;
             rcboModule.DataBind();               
             rcboModule.Items.Insert(0, new RadComboBoxItem("All", "All"));
         }
  </code></pre>