Newest KB Articles in Sample code

How to send email in ASP.NET with SMTP authentication

Tue, 10 Jul 2012 19:58:57 GMT

Basic examples of sending mail using System.Net.Mail in C# and VB.NET. Settings that require updating highlighted in red.

Trust Level and TLS Requirements

The scripting will require that the Trust Level is set to Full in a site's web.config, syntax example

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
  <system.web>
    <trust level="Full"/>
  </system.web>
</configuration>

TLS 1.2 is also required in order to make an encrypted connection to the mail server. If TLS 1.2 is not already forced for a site / application, bootstrapping code needs to be added to the mail scripting with syntax differing slightly between C# and VB.NET. Highlighted in red in the below scripting examples.

System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;

VB.NET

System.Net.ServicePointManager.SecurityProtocol = DirectCast(3072, System.Net.SecurityProtocolType)

C# Example

<%@ Import Namespace="System.Net" %>
<%@ Import Namespace="System.Net.Mail" %>

<script language="C#" runat="server">
  protected void Page_Load(object sender, EventArgs e)
  {
    System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
    MailMessage mail = new MailMessage();

    mail.From = new MailAddress("postmaster@domain.com");
    mail.To.Add("postmaster@domain.com");

    mail.Subject = "Test email sent from System.Net.Mail";
    mail.Body = "Mail test";
    mail.Headers.Add("Message-Id",
                      String.Format("<{0}@{1}>",
                      Guid.NewGuid().ToString(),
                      "domain.com"));

    SmtpClient smtp = new SmtpClient("sm##.internetmailserver.net");

    NetworkCredential Credentials = new NetworkCredential("postmaster@domain.com", "password");
    smtp.Credentials = Credentials;
    smtp.EnableSsl = true;
    smtp.Port = 25;
    smtp.Send(mail);
    lblMessage.Text = "Mail Sent";
  }
</script>
<html>
<body>
  <form runat="server">
    <asp:Label id="lblMessage" runat="server"></asp:Label>
  </form>
</body>
</html>

VB.NET Example

<%@ Page Language="VB" %>
<%@ Import Namespace="System.Net.Mail" %>
<script runat="server">
  Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)

    System.Net.ServicePointManager.SecurityProtocol = DirectCast(3072, System.Net.SecurityProtocolType)
    Dim strFrom = "postmaster@domain.com"
    Dim strTo = "postmaster@domain.com"
    Dim Mail As New MailMessage(New MailAddress(strFrom.Trim()), New MailAddress(strTo))
    Mail.BodyEncoding = Encoding.Default
    Mail.Subject = "Test email sent from System.Net.Mail"
    Mail.Body = "Mail test"
    Mail.Headers.Add("Message-Id",
                      String.Format("<{0}@{1}>",
                      Guid.NewGuid().ToString(),
                      "domain.com"))
    Mail.Priority = MailPriority.High
    Mail.IsBodyHtml = True

    Dim SmtpMail As New SmtpClient
    Dim basicAuthenticationInfo As New System.Net.NetworkCredential("postmaster@domain.com", "password")

    SmtpMail.Host = "sm##.internetmailserver.net"
    SmtpMail.UseDefaultCredentials = False
    SmtpMail.Credentials = basicAuthenticationInfo
    SmtpMail.EnableSsl = true
    SmtpMail.Port = 25

    SmtpMail.Send(Mail)
    lblMessage.Text = "Mail Sent"
  End Sub
</script>
<html>
<body>
  <form runat="server">
    <asp:Label id="lblMessage" runat="server"></asp:Label>
  </form>
</body>
</html>

How to send mail using CDO - SMTP authentication

Mon, 02 Jul 2012 14:36:41 GMT

Basic example of sending mail using CDO in Classic ASP. Settings that require updating highlighted in red.

<%
set objMessage = createobject("cdo.message")
set objConfig = createobject("cdo.configuration")
Set Flds = objConfig.Fields

Flds.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
Flds.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") ="sm##.internetmailserver.net"

Flds.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
Flds.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername") ="postmaster@domain.com"
Flds.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword") ="password"

Flds.update
Set objMessage.Configuration = objConfig
objMessage.To = "postmaster@domain.com"
objMessage.From = "postmaster@domain.com"
objMessage.Subject = "CDO email test"
objMessage.fields.update
objMessage.HTMLBody = "Test sent from CDO using smtp authentication."
objMessage.Send
%>

Sample code to connect to an MS SQL database using php

Fri, 22 Jan 2010 01:21:45 GMT

The following is sample code to connect to a MS SQL database using the php MS SQL driver. On lines two and three, server, dbName, userName and password should be replaced with the connection settings for the applicable database.

Note that the driver works for SQL 2005 and higher, but not SQL 2000.

<?php
$serverName = "serverName";
$connectionInfo = array( "Database"=>"databaseName", "UID"=>"userName", "PWD"=>"password", "TrustServerCertificate"=>True);
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

If you run into problems when using this code, please post in our community forum. Technical support is unable to assist with specific coding issues.

How to set up a connection string so communication with the SQL server is encrypted

Thu, 14 Jan 2010 00:19:29 GMT

The connection string below is an example that specifies the use of encryption.

Essentially you are using the connection string from the SQL section of your control panel and adding encrypt=true to the end. Setting the encrypt property to true will cause the transmission of data to and from the SQL server to be encrypted.

<connectionStrings>

<add name="MyConn" connectionString="Data Source=server;Initial Catalog=database;User ID=username;Password=password; encrypt=true;TrustServerCertificate=true" providerName="System.Data.SqlClient"/>

</connectionStrings>

How to query a SQL database with .NET SQL Data Provider in ASP.NET

Tue, 25 Nov 2008 00:56:40 GMT

<%@ import namespace="system.data.sqlclient" %>
<Script runat="server">
Sub page_load            
        Dim dbconn as sqlconnection            
        Dim dbCMD as sqlCommand            
        Dim dtr as sqldatareader            
        dbConn = New SQLConnection ("Data Source=DBSERVERNAME;Initial Catalog=YOURDBNAME;User ID=YOURUSERID;Password=YOURPASSWORD")            
        dbConn.open()            
        dbCMD = new sqlcommand ("select * from tblTest",dbconn)            
        dtr = dbCMD.executereader()            
        While dtr.read()                        
                response.write ("<li>")                        
                response.write (dtr(0) & "---" & dtr(1))            
        End while            
        dtr.close()            
        dbConn.close()
End Sub
</Script>

If you run into problems when using this code, please post in the DiscountASP.NET or Everleap community forum. Technical support is unable to assist with specific coding issues.

How to insert data into an MS SQL database with .NET SQL Data Provider in ASP.NET

Tue, 25 Nov 2008 00:55:34 GMT

<%@ import namespace="system.data.sqlclient" %>
<Script runat="server">
Sub page_load            
        Dim dbconn as sqlconnection            
        Dim dbCMD as sqlCommand            
        dbConn = New SQLConnection ("Data Source=DBSERVERNAME;Initial Catalog=YOURDBNAME;User ID=YOURUSERID;Password=YOURPASSWORD")            
        dbConn.open()            
        dbCMD = new sqlcommand ("insert into tblTest values ('test')",dbconn)            
        dbCMD.executenonquery()            
        dbConn.close()
End Sub
</Script>
Record Inserted

If you run into problems when using this code, please post in the DiscountASP.NET or Everleap community forum. Technical support is unable to assist with specific coding issues.