ASP.NET

<br />
public class EmailTo<br />
{<br />
	public string getEmailTo() <br />
	{<br />
     <br />
                // Command - specify as StoredProcedure<br />
                using (System.Data.SqlClient.SqlConnection myConnection = new<br />
                   System.Data.SqlClient.SqlConnection(ConfigurationManager.<br />
                   ConnectionStrings["ConnectionString2"].ConnectionString))<br />
                {<br />
                    System.Data.SqlClient.SqlCommand myCommand2 = new System.Data.SqlClient.SqlCommand();<br />
                    myCommand2.CommandText = "usp_get_email_to";<br />
                    myCommand2.CommandType = CommandType.StoredProcedure;<br />
                    myCommand2.Connection = myConnection;<br />
<br />
                    // Return value as parameter<br />
                    SqlParameter returnEmail = new SqlParameter("Email", SqlDbType.NVarChar);<br />
                    returnEmail.Direction = ParameterDirection.ReturnValue;<br />
                    myCommand2.Parameters.Add(returnEmail);<br />
<br />
<br />
                    // Execute the stored procedure<br />
                    myConnection.Open();<br />
                    myCommand2.ExecuteNonQuery();<br />
                    myConnection.Close();<br />
<br />
                    return returnEmail;<br />
<br />
                                 <br />
            }<br />
        }<br />
}<br />
<br />

<br />
CREATE PROCEDURE dbo.usp_get_email_to<br />
<br />
	@Email nvarchar(256),<br />
	@UserId uniqueidentifier<br />
	<br />
AS<br />
<br />
SET @Email  = (SELECT Email FROM aspnet_Membership<br />
	WHERE UserId=@UserId)<br />
<br />
<br />
RETURN @Email<br />
GO<br />
<br />
<br />