title: Hiding the Null Fields
body: <p>I have a data repeater that is reading a few different fields. However, some information being pulled is empty. I would like to hide these fields in this case.</p>
  
  <p>I am not sure how best to go about this. I have tried the following methods:</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                  ConnectionString="&lt;%$ ConnectionStrings:db %&gt;" 
                  SelectCommand="SELECT GrName, GrRoom
                                  FROM [Group] WHERE GrName LIKE 'A%' ORDER BY GrName  &amp;&amp; * IS NOT NULL"&gt;
              &lt;/asp:SqlDataSource&gt;
  
              &lt;!-- output to page --&gt;
              &lt;div data-role="collapsible-set"&gt;
                  &lt;asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1"&gt;
                      &lt;ItemTemplate&gt;
              &lt;div data-role="collapsible" data-collapsed="true"&gt;
                                  &lt;p&gt;Room: &lt;%# Eval("GrRoom")%&gt;&lt;/p&gt;
                          &lt;/div&gt;
                      &lt;/ItemTemplate&gt;
                  &lt;/asp:Repeater&gt;
  </code></pre>
  
  <p>Or, do I do something like this in the head?</p>
  
  <pre><code>    &lt;script type="text/vbscript"&gt;
  If (GrRoom = NULL) Then
    display: none;
  End If
  &lt;/script&gt;
  </code></pre>
  
  <p>I'm not sure I'm grasping this concept right now. Basically, I want the following to function to run as:</p>
  
  <p>"If GrRoom is empty, do not display"</p>
  
  <p>Any thoughts on this? I appreciate your insight. I'm relatively new to ASP and .NET, so I'm still learning a lot.</p>
  
  <p>Thank you for your time and help. </p>