how to get clickable email from aspnetdb?

Hi,

I can fetch the mailaddresses from table aspnet_membership in a gridview. I
just create a sqldatasource and a gridview and this sql statement, all in
the aspx file.

SelectCommand="select aspnet_Users.UserName as Lid, aspnet_Membership.Email
as Emailadres FROM aspnet_Membership INNER JOIN aspnet_Users ON
aspnet_Membership.UserId = aspnet_Users.UserId "


But i want to be able to click on those mailaddresses and so starting my
outlook.

Thanks for help.

Re: how to get clickable email from aspnetdb?

You must have following html in order to make it clickable




PS: Look up mailto tag, you can automatically prepopulate subj and message
body also.
George.


"Mich" wrote in message
news:eToQKJUXIHA.1208@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> I can fetch the mailaddresses from table aspnet_membership in a gridview.
> I just create a sqldatasource and a gridview and this sql statement, all
> in the aspx file.
>
> SelectCommand="select aspnet_Users.UserName as Lid,
> aspnet_Membership.Email as Emailadres FROM aspnet_Membership INNER JOIN
> aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId "
>
>
> But i want to be able to click on those mailaddresses and so starting my
> outlook.
>
> Thanks for help.
>

Re: how to get clickable email from aspnetdb?

Thanks, i know this tag. My problem is: how to integrate it in the sql
statement in the aspx file?
I tried this, but get an error "tag not wel formed":

SelectCommand="select aspnet_Users.UserName as Lid, " & " & "aspnet_Membership.Email" & ">email as Emailadres FROM
aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId =
aspnet_Users.UserId ">



"George Ter-Saakov" schreef in bericht
news:uM0yYYUXIHA.3940@TK2MSFTNGP05.phx.gbl...
> You must have following html in order to make it clickable
>
>
>
>
> PS: Look up mailto tag, you can automatically prepopulate subj and message
> body also.
> George.
>
>
> "Mich" wrote in message
> news:eToQKJUXIHA.1208@TK2MSFTNGP03.phx.gbl...
>> Hi,
>>
>> I can fetch the mailaddresses from table aspnet_membership in a gridview.
>> I just create a sqldatasource and a gridview and this sql statement, all
>> in the aspx file.
>>
>> SelectCommand="select aspnet_Users.UserName as Lid,
>> aspnet_Membership.Email as Emailadres FROM aspnet_Membership INNER JOIN
>> aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId "
>>
>>
>> But i want to be able to click on those mailaddresses and so starting my
>> outlook.
>>
>> Thanks for help.
>>
>
>

Re: how to get clickable email from aspnetdb?

I also tried this but same error:

SelectCommand="select aspnet_Users.UserName as Lid, + '' + aspnet_Membership.Email + '
' as Emailadres FROM aspnet_Membership INNER JOIN aspnet_Users ON
aspnet_Membership.UserId = aspnet_Users.UserId ">


"George Ter-Saakov" schreef in bericht
news:uM0yYYUXIHA.3940@TK2MSFTNGP05.phx.gbl...
> You must have following html in order to make it clickable
>
>
>
>
> PS: Look up mailto tag, you can automatically prepopulate subj and message
> body also.
> George.
>
>
> "Mich" wrote in message
> news:eToQKJUXIHA.1208@TK2MSFTNGP03.phx.gbl...
>> Hi,
>>
>> I can fetch the mailaddresses from table aspnet_membership in a gridview.
>> I just create a sqldatasource and a gridview and this sql statement, all
>> in the aspx file.
>>
>> SelectCommand="select aspnet_Users.UserName as Lid,
>> aspnet_Membership.Email as Emailadres FROM aspnet_Membership INNER JOIN
>> aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId "
>>
>>
>> But i want to be able to click on those mailaddresses and so starting my
>> outlook.
>>
>> Thanks for help.
>>
>
>