title: Datatable search by LINQ to avoid duplication
body: <p>I have a column in dataTable with blank rows</p>
  
  <pre><code>Column1
  A
  B
  C
  
  D
  
  E
  </code></pre>
  
  <p>I need to set if exist and to avoid adding, but blank rows should not be counted. Only rows with data should be in the (if exists). Thanks</p>
  
  <pre><code> bool exists = dt.Select().ToList().Exists(row =&gt; row["column1"].ToString() == txtbox)
  
  
  
  if(exists == true)
  {}
  else
  </code></pre>
  
  <p>// it includes blank so it goes to true, which I need is blank rows should not be included.</p>