sql_emailer.cs

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Net.Mail;
using System.Text;
using System.Web;

namespace sql_emailer
{
    class Program
    {
        static void Main(string[] args)
        {
            if (args == null || args.Count() < 3)
                return;

            var fileName = args.First();
            if (String.IsNullOrWhiteSpace(fileName))
                return;
            if (!File.Exists(fileName))
                return;

            var query = File.ReadAllText(fileName);

            var title = args.Skip(1).First();
            if (String.IsNullOrWhiteSpace(title))
            {
                var fileInfo = new FileInfo(fileName);
                title = String.Format("Results for {0}", fileInfo.Name);
            }

            var argEmails = args.Skip(2).First();
            if (String.IsNullOrWhiteSpace(argEmails))
                return;
            var emailAddresses = argEmails.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);

            var connectionName = "DefaultConnectionString";
            if (args.Count() == 4)
            {
                connectionName = args.Skip(3).First();
            }

            var connectionString = ConfigurationManager.AppSettings[connectionName];
            var sb = new StringBuilder();
            sb.AppendFormat("<h1>{0}</h1>", HttpUtility.HtmlEncode(title));
            sb.Append("<table><thead><tr>");

            using (var conn = new SqlConnection(connectionString))
            {
                var cmd = new SqlCommand
                {
                    CommandText = query, 
                    CommandType = CommandType.Text, 
                    Connection = conn,
                    CommandTimeout = 600
                };

                conn.Open();
                using (var reader = cmd.ExecuteReader())
                {

                    for (var i = 0; i &lt; reader.FieldCount; i++)
                    {
                        sb.AppendFormat("<th>{0}</th>", HttpUtility.HtmlEncode(reader.GetName(i)));
                    }

                    sb.Append("</tr></thead><tbody>");

                    while (reader.Read())
                    {
                        sb.Append("<tr>");
                        for (var i = 0; i &lt; reader.FieldCount; i++)
                        {
                            sb.AppendFormat("<td>{0}</td>", HttpUtility.HtmlEncode(reader.GetValue(i)));
                        }
                        sb.Append("</tr>");
                    }
                }
                conn.Close();
            }

            sb.Append("</tbody></table>");

            var msg = new MailMessage
            {
                From = new MailAddress("[email protected]"), 
                IsBodyHtml = true, 
                Subject = title, 
                Body = sb.ToString()
            };
            foreach (var emailAddress in emailAddresses)
            {
                msg.To.Add(new MailAddress(emailAddress));
            }

            var smtp = new SmtpClient();
            smtp.Send(msg);
        }
    }
}