title: DataBinder.Eval data item Empty
body: <p>I am having trouble trying to figure on how to hide a ',' when the DataItem is empty.</p>
  
  <p>Basically, I have table row that displays Registered Address and populated using the following technique:</p>
  
  <pre><code>&lt;%# DataBinder.Eval(Container.DataItem, "Address_Line_1" )%&gt;,
  &lt;%# DataBinder.Eval(Container.DataItem, "Address_Line_2")%&gt;,
  &lt;%# DataBinder.Eval(Container.DataItem, "TOWNLAND")%&gt;,                          
  &lt;%# DataBinder.Eval(Container.DataItem, "CITY")%&gt;,
  &lt;%# DataBinder.Eval(Container.DataItem, "STATE")%&gt;,
  </code></pre>
  
  <p>Now if one or many of the above DataItem comes back as Empty then on the front end
  it is displayed as </p>
  
  <blockquote>
    <p>Address 1, , , CITY, ,</p>
  </blockquote>
  
  <p>I tried the following to hide the comma (',') but I keep getting an error saying</p>
  
  <blockquote>
    <p>Missing ')' 
    on the first line of 'If' statement</p>
  </blockquote>
  
  <pre><code>&lt;%#IIf(IsDBNull(DataBinder.Eval(Container.DataItem, "STATE")) OrElse 
  
  String.IsNullOrEmpty(DataBinder.Eval(Container.DataItem, "STATE")) , "" , 
  
  DataBinder.Eval(Container.DataItem, "STATE") &amp; ",")%&gt;
  </code></pre>
  
  <p>I am not sure whether my 'if' statement is wrong or It can't be done as above?</p>
  
  <p>Anybody have suggestions about the above or any other alternative way of hiding the comma if a NULL value?</p>