ASP.NET

/*This Function will change the Connection string in the web.congif file based on the Database that exists on the
* session Variable. If there is nulll then set odirect3 as a current Database name.
*/

private string GetConnectionString(string DB) // where DB is your database name from the session
{

    string connString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;

    if (DB != null)
    {
        return connString.Replace("oDirectv3", DB);
    }
    else
    {
        return connString.Replace("oDirectv3", "oDirectv3");
    }

}

<add name="DBConnectionString" connectionString="Data Source=VUYISWA\SQLEXPRESS;Initial Catalog=oDirectv3;Persist Security Info=True;User ID=V;Password=wow" providerName="System.Data.SqlClient"/>

MailMessage message = new MailMessage(strEmailFrom, ToEmail, Subject, Body);
                
                message.IsBodyHtml = IsBodyHtml;
                SmtpClient emailClient = new SmtpClient(SMTPServer);
                System.Net.NetworkCredential SMTPUserInfo = new System.Net.NetworkCredential(SMTPUser, SMTPPassword);
                emailClient.UseDefaultCredentials = false;
                emailClient.Credentials = SMTPUserInfo;
                emailClient.Send(message);