Send email with data from database in an email body in ASP.Net

Please refer this example to send the email with Database details.

HTML

EmployeeId:
<asp:TextBox ID="txtEmployeeId" runat="server" />
<asp:Button ID="btnSearch" Text="Search" runat="server" OnClick="SearchEmployee" />

Namespaces

using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Net;
using System.Net.Mail;
using System.Text;

C#

protected void SearchEmployee(object sender, EventArgs e)
{
    this.GetEmployeeData();
}

protected void GetEmployeeData()
{
    int employeeId;
    if (int.TryParse(this.txtEmployeeId.Text.Trim(), out employeeId))
    {
        employeeId = int.Parse(this.txtEmployeeId.Text.Trim());
    }
    string query = "SELECT EmployeeId, FirstName + ' ' + LastName AS Name, HomePhone AS Phone FROM Employees WHERE EmployeeId = @EmployeeId";
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlCommand cmd = new SqlCommand(query, con))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                using (DataTable dt = new DataTable())
                {
                    cmd.Parameters.AddWithValue("@EmployeeId", employeeId);
                    sda.Fill(dt);
                    string id = dt.Rows[0]["EmployeeId"].ToString();
                    string name = dt.Rows[0]["Name"].ToString();
                    string phone = dt.Rows[0]["Phone"].ToString();
                    this.SendEmail(id, name, phone);
                }
            }
        }
    }
}

private void SendEmail(string id, string name, string phoneNumber)
{
    DataTable dt = new DataTable();
    StringBuilder sb = new StringBuilder();
    sb.Append("Hello {LastFirst} <br /> We have received your details." +
        "<hr /><br />" +
        "EmployeeId: {EmployeeId}" +
            "<br />" +
        "Phone Number: {Phone}" +
        "<br />" +
            "Thank You");
    sb = sb.Replace("{EmployeeId}", id);
    sb = sb.Replace("{LastFirst}", name);
    sb = sb.Replace("{Phone}", phoneNumber);

    using (MailMessage mm = new MailMessage("sender@gmail.com", "receiver@gmail.com"))
    {
        mm.Subject = "Employee Details";
        mm.Body = sb.ToString();
        SmtpClient smtp = new SmtpClient();
        smtp.Host = "smtp.gmail.com";
        smtp.EnableSsl = true;
        NetworkCredential NetworkCred = new NetworkCredential("sender@gmail.com", "password");
        smtp.UseDefaultCredentials = true;
        smtp.Credentials = NetworkCred;
        smtp.Port = 587;
        smtp.Send(mm);
        ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Email sent.');", true);
    }
}

Screenshot