How do I send an email from asp.net that is populated with results from an SQL stored procedure?

Hello,

I have been populating the values on the form by performing a query via stored procedure. Those results I would like to send an email to the user (Email is pulled with the stored procedure too) from my asp.net page by clicking on a button. The email is a standard email TO, From, Body, Subject..

 I tried the same thing in Classic ASP, But I am totally lost how to do in ASP.net

 I am using SQL Server, ASP.net 2.0 with C#

I really appreciate if I can get any help!

 

Thanks in advance

san

 

Here is the code which i have used in my Classic ASP

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>Status of the Ticket Closed</title>

<%

Dim strSQL, result, results, sqlinsproc, ProblemStatusID, Email, ProblemStatus, Solution, TicketID, myMail, Body

ProblemStatusID=Request.QueryStr ...