CreateCommand Method (ExactTargetConnection)

In This Topic

Creates and returns a ExactTargetCommand object associated with the ExactTargetConnection.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateCommand() As ExactTargetCommand

public new ExactTargetCommand CreateCommand()

Return Value

A ExactTargetCommand object.

Remarks

You can use this method as an alternative to common ExactTargetCommand constructors.

Example

In this sample ExactTargetCommand object is created. It is automatically associated with ExactTargetConnection that created it.

csharp

public void CreateExactTargetCommand(string myConnString)
{
  ExactTargetConnection exactTargetConnection = new ExactTargetConnection(myConnString);
  ExactTargetCommand exactTargetCommand = exactTargetConnection.CreateCommand();
  exactTargetCommand.CommandText = "INSERT INTO Email (Name, Subject) VALUES ('Sale', 'Big Sale!')";
  exactTargetConnection.Open();
  try
  {
    exactTargetCommand.ExecuteNonQuery();
  }
  finally
  {
    exactTargetConnection.Close();
  }
}

Visual Basic

Public Sub CreateExactTargetCommand(ByVal myConnString As String)
  Dim exactTargetConnection As New ExactTargetConnection(myConnString)
  Dim exactTargetCommand As ExactTargetCommand = exactTargetConnection.CreateCommand()
  exactTargetCommand.CommandText = "INSERT INTO Email (Name, Subject) VALUES ('Sale', 'Big Sale!')"
  exactTargetConnection.Open()
  Try
    exactTargetCommand.ExecuteNonQuery()
  Finally
    exactTargetConnection.Close()
  End Try
End Sub

Reference

ExactTargetConnection Class
ExactTargetConnection Members
ExactTargetCommand Class

Send Feedback