How to send email from SQL Server to gmail

Question

I am a beginner in SQL and ASP.NET, basically i'm creating a website in that there is a contact us page. In that there are four textbox (Name, Email Address,Subject & Your Message). What ever i type in the text box it stored in the table's database in SQL. So now how to send the data (which is present in table) to gmail account.

Answer 1

Prerequisites: SMTP server (Gmail, exchange, any other)

Options

• Send mail from c#
• Send mail in database (wouldn't recommend as SQL Server is expensive in licensing)

How to do it from c#:

using(var smtpClient = new SmtpClient("smtp.gmail.com", 587)
{
    EnableSsl = true,
})
{
    var credentials = new NetworkCredential("your-sender-account@gmail.com", "your-sender-passworder"); // Don't store you password in clear text
    var smtpClient.Credentials = credentials;

    var to = new MailAddress("to-email@gmail.com");
    var from = new MailAddress("from-email@gmail.com");
    var mailMessage = new MailMessage(from, to)
    {
        Subject = "Your subject",
        Body = "Your content"
    };

    smtpClient.Send(mailMessage);
}

If you use gmail as your smtp server, you would need to allow less secure apps in your gmail settings, of the account used in the NetworkCredintial

Documentation SmtpClient