dotConnect for Mailchimp Documentation
Devart.Data.MailChimp Namespace / MailChimpCommand Class / MailChimpCommand Constructor / MailChimpCommand Constructor(String,MailChimpConnection)
The text of the query.
A MailChimpConnection object that represents the connection to Mailchimp.
Example

MailChimpCommand Constructor(String,MailChimpConnection)
Initializes a new instance of the MailChimpCommand class with the text of the query and a %% object.
Syntax
'Declaration
 
Public Function New( _
   ByVal commandText As String, _
   ByVal connection As MailChimpConnection _
)
 

Parameters

commandText
The text of the query.
connection
A MailChimpConnection object that represents the connection to Mailchimp.
Remarks
The following table shows initial property values for an instance of MailChimpCommand.
Properties Initial value
CommandText commandText
CommandTimeout 30
CommandType System.Data.CommandType.Text
Connection connection
Example
The following example creates a MailChimpCommand and sets some of its properties.
public void CreateCommand()
{
  MailChimpConnection mailchimpConnection = new MailChimpConnection(
      "api key=8b10fe893c9732d12befe0b7d846ffcb-us10;");
  string mySelectQuery = "SELECT * FROM Folders";
  MailChimpCommand mailchimpCommand = new MailChimpCommand(mySelectQuery, mailchimpConnection);
  mailchimpCommand.FetchSize = 100;
}
Public Sub CreateCommand()
  Dim mailchimpConnection As New MailChimpConnection( _
    "api key=8b10fe893c9732d12befe0b7d846ffcb-us10;")
  Dim mySelectQuery As String = _
    "SELECT * FROM Folders"
  Dim mailchimpCommand As New MailChimpCommand(mySelectQuery, mailchimpConnection)
  mailchimpCommand.FetchSize = 100
End Sub
See Also