The following example creates a
MailChimpCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source.
public void CreateMailChimpDataReader(string mySelectQuery,string mailchimpConnectionString)
{
MailChimpConnection mailchimpConnection = new MailChimpConnection(mailchimpConnectionString);
MailChimpCommand mailchimpCommand = new MailChimpCommand(mySelectQuery, mailchimpConnection);
mailchimpCommand.Connection.Open();
MailChimpDataReader mailchimpReader = mailchimpCommand.ExecuteReader();
try
{
while(mailchimpReader.Read())
{
Console.WriteLine(mailchimpReader.GetString(0));
}
}
finally
{
mailchimpReader.Close();
mailchimpConnection.Close();
}
}
Public Sub CreateMailChimpDataReader(mySelectQuery As String, _
mailchimpConnectionString As String)
Dim mailchimpConnection As New MailChimpConnection(mailchimpConnectionString)
Dim mailchimpCommand As New MailChimpCommand(mySelectQuery, mailchimpConnection)
mailchimpCommand.Connection.Open()
Dim mailchimpReader As MailChimpDataReader = mailchimpCommand.ExecuteReader()
Try
While mailchimpReader.Read()
Console.WriteLine(mailchimpReader.GetString(0))
End While
Finally
mailchimpReader.Close()
mailchimpConnection.Close()
End Try
End Sub