Variable into Mailto 1

[sila]

Hi
I'm getting an email address out of a database using the following....

Me.SqlConnection1.Open()
        dtrCabinetEmail = Me.SqlComm_SelectCabinetEmail.ExecuteReader
        If dtrCabinetEmail.Read Then
            Email = dtrCabinetEmail("committee_email")
            Me.lblEmail.Text = "" & Email & ""
        End If
        Me.SqlConnection1.Close()

I'm then trying to read the value into a mailto doing this on the aspx side...

<a href=mailto:<asp:Label id="lblEmail" runat="server"></asp:Label></a>

Its not working - but then I don't know what I'm doing! Any help appreciated.

Thanks

 

[ca8msm]

Easiest way is to not use a Label. Instead use a LiteralControl (or a hyperlink control may be better suited depending on what you are doing.). Anyway, here's an example using a Literal Control:

<asp:Literal id="Literal1" runat="server"></asp:Literal>

and to populate it:

Literal1.Text = "<a href=""mailto:me@here.com"">Email Me</a>"

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[sila]

The part where you have me@here.com is where the value will be changing for various email addresses, does what you have given me above cover that? If my email variable is called MemberEmail, where would it go?

Thanks

 

[ca8msm]

You would just set the Text property like any other string variable as that is all it is:

        Dim MemberEmail As String = "me@here.com"
        Literal1.Text = "<a href=""mailto:" & MemberEmail & """>Email Me</a>"

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[sila]

Thanks ca8msm!