Hiding text in gridview if data doesn't exist

SouthendSupporter · December 15th, 2009, 01:41 PM

Hi
I am using the following code in a Gridview to display a link to generate an e-mail to an email address obtained from a database:

Code:

<asp:TemplateField HeaderText="Email">
<ItemTemplate>
<asp:HyperLink ID="EmailLink" text='e-Mail' 
NavigateUrl='<%# Eval("eMail","mailto:{0}?Subject=Enquiry from Cobham Chamber Website")%>' 
runat="server"
target="_blank" />
</ItemTemplate>

I am using text='e-Mail' as I am restricted in width and the email address that will be displayed by using text='<%# Bind("eMail") %>' is too long.

The latter has the advantage that the column is blank if no e-mail address exists (ConvertEmptyStringtoNull set to TRUE)
But with text='e-mail' the records with an address get the word e-mail as a link whilst those without get the word e-Mail without a link.

Can I hide the text when there is no data in the field?

irProject · December 15th, 2009, 04:48 PM

you can use

Code:

<asp:HyperLink ID="EmailLink" text='<%=Bind("eMail")=="" ? "e-Mail" : "" %>'
NavigateUrl='<%# Eval("eMail","mailto:{0}?Subject=Enquiry from Cobham Chamber Website")%>' 
runat="server"

SouthendSupporter · December 15th, 2009, 08:10 PM

Quote:

Originally Posted by irProject

you can use

Code:

<asp:HyperLink ID="EmailLink" text='<%=Bind("eMail")=="" ? "e-Mail" : "" %>'
NavigateUrl='<%# Eval("eMail","mailto:{0}?Subject=Enquiry from Cobham Chamber Website")%>' 
runat="server"

Thanks for the suggestion -
What actually gets displayed is all the text between ' and ' after text=.
-as a link to an e-mail when one is present but as plain text when it isn't :(

I can see the idea is to put "e-mail" and a link in the field if an e-mail address exists and anull in the field if an e-mail address doesn't exist but don't know enough about the syntax to figure out what is actually wrong?

Something missing or extraneous in the syntax??

timeware · December 17th, 2009, 09:16 AM

I have used the following in a system (in the .aspx page within the code<asp:Hyperlink> </>

Code:

 
Visible='<%# IIf(Eval("ForumUser").ToString().Equals(Session("ForumUserID").ToString), "False","True" )%>'

Which checks the ForumUser Name on a record agains a session recording the logged in ID

So you will need to change ForumUser to Email and play around wth the Equals(Session("ForumUserID") bit to be either "" or NULL

Hope it helps.

SouthendSupporter · December 17th, 2009, 10:43 AM

Quote:

Originally Posted by timeware

I have used the following in a system (in the .aspx page within the code<asp:Hyperlink> </>

Code:

 
Visible='<%# IIf(Eval("ForumUser").ToString().Equals(Session("ForumUserID").ToString), "False","True" )%>'

Which checks the ForumUser Name on a record agains a session recording the logged in ID

So you will need to change ForumUser to Email and play around wth the Equals(Session("ForumUserID") bit to be either "" or NULL

Hope it helps.

BRILLIANT!!

Does just what I need -- many thanks