ASP.NET

Not to Display Blank Fields from Database RSS

4 replies

Last post Jan 29, 2013 06:40 AM by darvinkmanwah

‹ Previous Thread|Next Thread ›

- Reply
darvinkmanwa...

Member

42 Points

56 Posts

Not to Display Blank Fields from Database

Apr 05, 2012 09:03 AM|LINK

Hey guys,

How is it possible not to display blank fields from a database. I've got tags associated with a post and they show up on the page but as a blank area. So if I have 5 blank columns in the database it will show 5 empty spaces in the tags.

Here is an example of what I'm talking about, scroll down to the first post: http://darvinkmanwah.com/default.aspx

If you hover between the tags you'll see orange lines, that's because of the CSS styles but it's pulling blank containers from the database. How do I close that gap and not display those empty containers?

Thanks for the help in advance ..,.

Darvin K. Manwah
Matte Painter / Digital Compositor / ASP.net Developer (VB)
darvinkmanwah.com | darvinkmanwah.blogspot.com
- Reply
adeelehsan

All-Star

18297 Points

2740 Posts

Re: Not to Display Blank Fields from Database

Apr 05, 2012 09:38 AM|LINK

You can use where clause while accessing those tags from db. Only access where the values in those tags are not null and not empty spaces. If you can post the structure of the table, it will be easier to post exact solution.

Please Mark As Answer if it helped.

MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
Microsoft Community Contributor Award 2011

darvinkmanwa...

Member

42 Points

56 Posts

Re: Not to Display Blank Fields from Database

Apr 05, 2012 09:51 AM|LINK

Thanks for the speedy reply and here is my code:

<asp:ListView ID="labelRecentArtwork" runat="server" DataSourceID="ArtworkDatabase" >
    <ItemTemplate>
    <div id="content-container">
    <div class="heading-2">
        <asp:HyperLink ID="SubjectLabel1" Text='<%# Eval("Subject") %>' NavigateUrl='<%#"digital-playground/artwork/display.aspx?id=" & DataBinder.Eval(Container.DataItem, "ID") & "#TopPage" %>'
        Runat="server" CssClass="heading-2" ToolTip='<%# Eval("Subject") %>' />
    </div>

    <span class="heading-16">
    <asp:HyperLink ID="HyperLink17" Text='<%# Eval("New") %>' NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Work-in-Progress") & "#TopPage" %>'
    Runat="server" ToolTip='<%# Eval("Subject") %>' />
    </span>

    <span class="heading-5">Posted on
    <asp:Label ID="Label1" CssClass="heading-5" runat="server" Text='<%# Eval("Timestamp") %>' /> | Artwork by</span>
                
    <span class="heading-5">
    <asp:HyperLink ID="HyperLinkAuthor" Text='<%# Eval("Author") %>' NavigateUrl='<%#"digital-playground/members/darvinkmanwah.aspx" & "#Top" %>' Runat="server" ToolTip='<%# Eval("Author") %>' />
    </span>

    <div class="article-summary-article">
        <asp:Label ID="Label2" runat="server" Text='<%# Eval("Intro-Image") %>' ToolTip='<%# Eval("Description") %>' CssClass="intro-image-thumb" Width="640px" Height="189px" />
        <asp:Label ID="SynopsisLabel" CssClass="heading-5" runat="server" Text='<%# Eval("Synopsis") %>' />

        <div class="heading-5 share-this-holder-content">
            <div class="heading-11">
                <asp:HyperLink ID="HyperLink1" runat="server" Text='<%# "View " & Eval("Subject") & " ..." %>'
                NavigateUrl='<%#"digital-playground/artwork/display.aspx?id=" & DataBinder.Eval(Container.DataItem, "ID") & "#TopPage" %>' ToolTip='<%# Eval("Description") %>' />
            </div>
        </div>
    </div>
    <div class="column-spacing"></div>

    <div class="heading-5 article-summary-details">
        <!-- Type of Artwork Tags - Begin -->
        <span class="highlight" title="Collection of Visual Effects Categories">Visual Effects Tags:</span>
                
        <asp:HyperLink ID="HyperLink3" runat="server" Text='<%# Eval("3D-Artwork")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "3D-Artwork") & "#TopPage" %>' ToolTip='<%# Eval("3D-Artwork") %>' />

        <asp:HyperLink ID="HyperLink4" runat="server" Text='<%# Eval("Animated-Short-Film")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Animated-Short-Film") & "#TopPage" %>' ToolTip='<%# Eval("Animated-Short-Film") %>' />

        <asp:HyperLink ID="HyperLink5" runat="server" Text='<%# Eval("Columbus-Communications-Trinidad-Limited")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Columbus-Communications-Trinidad-Limited") & "#TopPage" %>' ToolTip='<%# Eval("Columbus-Communications-Trinidad-Limited") %>' />

        <asp:HyperLink ID="HyperLink6" runat="server" Text='<%# Eval("Digital-Art")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Digital-Art") & "#TopPage" %>' ToolTip='<%# Eval("Digital-Art") %>' />

        <asp:HyperLink ID="HyperLink7" runat="server" Text='<%# Eval("Graphic-Art")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Graphic-Art") & "#TopPage" %>' ToolTip='<%# Eval("Graphic-Art") %>' />

        <asp:HyperLink ID="HyperLink8" runat="server" Text='<%# Eval("Matrix-Designs-Limited")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Matrix-Designs-Limited") & "#TopPage" %>' ToolTip='<%# Eval("Matrix-Designs-Limited") %>' />

        <asp:HyperLink ID="HyperLink13" runat="server" Text='<%# Eval("Matte-Painting")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Matte-Painting") & "#TopPage" %>' ToolTip='<%# Eval("Matte-Painting") %>' />

        <asp:HyperLink ID="HyperLink9" runat="server" Text='<%# Eval("Print")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Print") & "#TopPage" %>' ToolTip='<%# Eval("Print") %>' />

        <asp:HyperLink ID="HyperLink10" runat="server" Text='<%# Eval("Zbrush-Sculpt")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Zbrush-Sculpt") & "#TopPage" %>' ToolTip='<%# Eval("Zbrush-Sculpt") %>' />

        <asp:HyperLink ID="HyperLink2" runat="server" Text='<%# Eval("Work-in-Progress")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Work-in-Progress") & "#TopPage" %>' ToolTip='<%# Eval("Work-in-Progress") %>' />
        <!-- Type of Artwork Tags - End -->
        <br />

        <!-- Software Tags - Begin -->
        <span class="highlight" title="3D and 2D Software Used">Digital Art Software:</span>

        <asp:HyperLink ID="HyperLink11" runat="server" Text='<%# Eval("Adobe-After-Effects")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Adobe-After-Effects") & "#TopPage" %>' ToolTip='<%# Eval("Adobe-After-Effects") %>' />

        <asp:HyperLink ID="HyperLink12" runat="server" Text='<%# Eval("Adobe-Photoshop")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Adobe-Photoshop") & "#TopPage" %>' ToolTip='<%# Eval("Adobe-Photoshop") %>' />

        <asp:HyperLink ID="HyperLink14" runat="server" Text='<%# Eval("Autodesk-Maya")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "Autodesk-Maya") & "#TopPage" %>' ToolTip='<%# Eval("Autodesk-Maya") %>' />

        <asp:HyperLink ID="HyperLink15" runat="server" Text='<%# Eval("E-on-Software-Vue-xStream")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "E-on-Software-Vue-xStream") & "#TopPage" %>' ToolTip='<%# Eval("E-on-Software-Vue-xStream") %>' />

        <asp:HyperLink ID="HyperLink16" runat="server" Text='<%# Eval("The-Foundry-Nuke")%>'
        NavigateUrl='<%#"artwork-tags.aspx?id=" & DataBinder.Eval(Container.DataItem, "The-Foundry-Nuke") & "#TopPage" %>' ToolTip='<%# Eval("The-Foundry-Nuke") %>' />
        <!-- Software Tags - End -->
    </div>
    <br /><hr class="separator"/>
    </div>
</ItemTemplate>
<LayoutTemplate>
    <table id="Table1" runat="server">
        <tr id="Tr1" runat="server">
            <td id="Td1" runat="server">
                <table ID="itemPlaceholderContainer" runat="server" border="0" style="">
                    <tr id="Tr2" runat="server" style=""></tr>
                    <tr ID="itemPlaceholder" runat="server"></tr>
                </table>
            </td>
        </tr>
        <tr id="Tr3" runat="server">
            <td id="Td2" runat="server" style="" class="heading-9 content-holder-background">
                <span class="heading-5">
                    <a href="#Top" title="Top of Page">Top of Page</a> |
                    <a href="digital-playground/artwork/archive.aspx#Top" title="View Older Posts">View Older Posts ...</a>
                    <a href="digital-playground/artwork/archive.aspx?page=2">2</a>
                    <a href="digital-playground/artwork/archive.aspx?page=3">3</a>
                    <a href="digital-playground/artwork/archive.aspx?page=4">4</a> ...
                </span>
                <asp:DataPager ID="DataPager1" runat="server" PageSize="3" QueryStringField="page">
                    <Fields></Fields>
                </asp:DataPager>
            </td>
        </tr>
    </table>
</LayoutTemplate>
</asp:ListView>

<asp:AccessDataSource ID="ArtworkDatabase" runat="server" DataFile="~/App_Data/content.mdb"
    SelectCommand="SELECT [New], [ID], [Subject], [Description], [Organized-Date], [Timestamp], [Article-Date], [Author], [ArticleContent], [ImageRights], [Approved], [Intro-Image], [Synopsis],
    [3D-Artwork], [Animated-Short-Film], [Columbus-Communications-Trinidad-Limited], [Digital-Art], [Graphic-Art], [Matrix-Designs-Limited],
    [Matte-Painting], [Print], [Work-in-Progress], [Zbrush-Sculpt],
    [Adobe-After-Effects], [Adobe-Photoshop], [Autodesk-Maya], [E-on-Software-Vue-xStream], [The-Foundry-Nuke]
    FROM [artwork] ORDER BY [Organized-Date] DESC">
</asp:AccessDataSource>
<!-- Recent Artwork - Main Content - End -->

Darvin K. Manwah
Matte Painter / Digital Compositor / ASP.net Developer (VB)
darvinkmanwah.com | darvinkmanwah.blogspot.com

- Reply
Decker Dong ...

All-Star

118619 Points

18779 Posts
Re: Not to Display Blank Fields from Database

Apr 07, 2012 01:23 AM|LINK
darvinkmanwah
How do I close that gap and not display those empty containers?

In fact，as far as I see——I think it's time for you to ignore these gap by not setting or binding CSS to them。Maybe you can tell whether the bound value is null or empty——if yes，set its style as display or visibility:none。Maybe something looks like this：
```
<div style='<%#Eval("BoundFieldName").ToString().Equals("")?"display:none":"display:block"%>'>
   
</div>
```
- Marked as answer by decker dong - msft on Apr 11, 2012 02:04 AM
- Reply
darvinkmanwa...

Member

42 Points

56 Posts
Re: Not to Display Blank Fields from Database

Jan 29, 2013 06:40 AM|LINK
Hey,

I'm glad to be back to the forum and working on my site again. I was wondering, is that piece of code written properly cause it's showing as though it is not formed properly. Here is my updated version but I'm not sure if it's correct:
```
<div style='<%# Eval("Work-in-Progress").ToString().Equals("")?"display:none":"display:block" %>'>

</div>
```
Thanks ...
Darvin K. Manwah
Matte Painter / Digital Compositor / ASP.net Developer (VB)
darvinkmanwah.com | darvinkmanwah.blogspot.com

‹ Previous Thread|Next Thread ›

Not to Display Blank Fields from Database RSS

4 replies

darvinkmanwa...

Not to Display Blank Fields from Database

adeelehsan

Re: Not to Display Blank Fields from Database

darvinkmanwa...

Re: Not to Display Blank Fields from Database

Decker Dong ...

Re: Not to Display Blank Fields from Database

darvinkmanwah

darvinkmanwa...

Re: Not to Display Blank Fields from Database

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft