CreateCommand Method (MailChimpConnection)

In This Topic

Creates and returns a MailChimpCommand object associated with the MailChimpConnection.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateCommand() As MailChimpCommand

public new MailChimpCommand CreateCommand()

Return Value

A MailChimpCommand object.

Remarks

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

Example

In this sample MailChimpCommand object is created. It is automatically associated with MailChimpConnection that created it.

csharp

public void CreateMailChimpCommand(string myConnString)
{
  MailChimpConnection mailchimpConnection = new MailChimpConnection(myConnString);
  MailChimpCommand mailchimpCommand = mailchimpConnection.CreateCommand();
  mailchimpCommand.CommandText = "INSERT INTO Folders(Name, Type) VALUES ('Sales', 'campaign')";
  mailchimpConnection.Open();
  try
  {
    mailchimpCommand.ExecuteNonQuery();
  }
  finally
  {
    mailchimpConnection.Close();
  }
}

Visual Basic

Public Sub CreateMailChimpCommand(ByVal myConnString As String)
  Dim mailchimpConnection As New MailChimpConnection(myConnString)
  Dim mailchimpCommand As MailChimpCommand = mailchimpConnection.CreateCommand()
  mailchimpCommand.CommandText = "INSERT INTO Folders(Name, Type) VALUES ('Sales', 'campaign')"
  mailchimpConnection.Open()
  Try
    mailchimpCommand.ExecuteNonQuery()
  Finally
    mailchimpConnection.Close()
  End Try
End Sub

Reference

MailChimpConnection Class
MailChimpConnection Members
MailChimpCommand Class

Send Feedback