ASP.NET

        Dim StrSQL As String = ""
        Dim strWHERE As String = ""
        Dim rs As SqlDataReader
        Dim val As String = tripType.SelectedItem.Value
        Dim suv As String = vpreferred.SelectedItem.Value
        'Response.Write(val)
        'Response.End()
        If val = "hourly" Then
            StrSQL = "select DISTINCT s.carTypes, s.Newfare as Fares, s.tip, (s.total+^SUV^) as total from vwhourly s "
            strWHERE = " WHERE s.Hourly = @hourly"
            If Len(suv) <> 0 Then
                strWHERE += " AND s.carTypes = '" & suv & "'"
            End If
        Else
            '     StrSQL = "SELECT city, fare, (fare*(10/100)) AS Discount, (fare-Discount) * ^RT^ AS NewFare, (Newfare*(7/100)) AS tax, (newFare*(20/100)) AS tip, (Newfare + (Newfare*(7/100)) + (newFare*(20/100)) + ^SUV^) AS total FROM Rates "

            StrSQL = "with CTE_Rates as " & _
"( " & _
 "   Select DISTINCT " & _
            "City, " & _
       "     Fare " & _
     "       FROM Rates " & _
") " & _
"SELECT  " & _
"City, " & _
"Fare,  " & _
"Fare * 0.1 AS Discount,  " & _
"(Fare * 0.9) * ^RT^ AS NewFare,  " & _
"Fare * 0.063 AS Tax,  " & _
"Fare * 0.18 AS Tip, " & _
"Fare * 1.143 + ^SUV^ AS Total  " & _
"FROM CTE_Rates "
            strWHERE = " Where city In('" & lblPreviewfromCityState.Text & "' , '" & lblPreviewDropOff.Text & "')"
        End If
        If suv = "SportUtilityVehicle" Then
            StrSQL = Replace(StrSQL, "^SUV^", "12")
        Else
            StrSQL = Replace(StrSQL, "^SUV^", "0")
        End If
        If val Like "round_trip_*airport" Then
            StrSQL = Replace(StrSQL, "^RT^", "2")
        Else
            StrSQL = Replace(StrSQL, "^RT^", "1")
        End If

        Dim conn As New SqlConnection(connStr)
        Dim cmd As New SqlCommand(StrSQL & strWHERE, conn)

        If val = "hourly" Then
            cmd.Parameters.AddWithValue("@hourly", HourlyCharter.SelectedValue)
        End If
        Response.Write(StrSQL)
        Response.End()
        'Now open connection to the db
        conn.Open()

        'open recordset to receive db values
        rs = cmd.ExecuteReader()

          While rs.Read()

            Dim tipValue As Decimal = rs("tip")
            Dim totValue = rs("total")
            Dim tp As String = [String].Format("{0:C}", tipValue)
            Dim tot As String = [String].Format("{0:C}", totValue)
            lblTip.Text = tp
            lblTotal.Text = tot

        End While

VBMain VBM;
VBM = New VBMain(this);

Dim MyLblMsg as System.Web.UI.WebControls.Label = pWebCtl.FindControl("lblMsg")

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Net;
using System.Net.Mail;


namespace sms2
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }


        protected void SendMail()
        {
            // Gmail Address from where you send the mail
            var fromAddress = "net@gmail.com";
            // any address where the email will be sending
            var toAddress = YourEmail.Text.ToString();
            //Password of your gmail address
            const string fromPassword = "12345";
            // Passing the values and make a email formate to display
            string subject = YourSubject.Text.ToString();
            string body = "From: " + YourName.Text + "\n";
            body += "Email: " + YourEmail.Text + "\n";
            body += "Subject: " + YourSubject.Text + "\n";
            body += "Question: \n" + Comments.Text + "\n";
            // smtp settings
            var smtp = new System.Net.Mail.SmtpClient();
            {
                smtp.Host = "smtp.gmail.com";
               // smtp.Port = 587;
                smtp.Port = 2525;
                smtp.EnableSsl = true;
                smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
               // request.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
                smtp.Credentials = new System.Net.NetworkCredential(fromAddress, fromPassword);
                //smtp.Credentials = new NetworkCredential(fromAddress, fromPassword);
                smtp.Timeout = 20000;
            }
            // Passing values to smtp object
            smtp.Send(fromAddress, toAddress, subject, body);
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {
                //here on button click what will done
                SendMail();
                DisplayMessage.Text = "Your Comments after sending the mail";
                DisplayMessage.Visible = true;
                YourSubject.Text = "";
                YourEmail.Text = "";
                YourName.Text = "";
                Comments.Text = "";
            }
            catch (Exception) { }
        }



    }

}