gridview null values

Hi everyone,

I have a gridview and I need to check of the field orgname is null, i don't want the gridview to show an empty line.

is that possible in asp.net?? any suggestion?

here is the gridview i have.

<asp:GridView ID="GridView1" runat="server"
                Width="100%"  AutoGenerateColumns="false" CellPadding="4" ForeColor="#4e6c93"
                Font-Size="18px"  GridLines="Both" Height="168px"  >
                  <HeaderStyle BackColor="#68acdc" Font-Size="11px" />
                  <Columns>
                  <asp:BoundField DataField="OrgName" HeaderText="Organization Name"  HeaderStyle-BackColor="AliceBlue" HtmlEncode="false"/>
                        <asp:BoundField DataField="TaskAss" HeaderText="Assistance" HeaderStyle-BackColor="AliceBlue" HtmlEncode="false"/>
                        <asp:BoundField DataField="PosFeed"  HeaderText="Feedback" HeaderStyle-HorizontalAlign="Left" HeaderStyle-BackColor="AliceBlue" HtmlEncode="false"/>


            </Columns>
            </asp:GridView>
shpresaAsked:
Who is Participating?
 
Mark ElySenior Coldfusion DeveloperCommented:
Modify your query and add the following to your where clause:

OrgName IS NOT NULL
0
 
shpresaAuthor Commented:
it worked like a charm.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.