MailChimpDataReader Class
Reads a forward-only stream of rows from Mailchimp.
The following example creates a
MailChimpConnection, a
MailChimpCommand, and a
MailChimpDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the
MailChimpDataReader, then the
MailChimpConnection.
public void ReadMyData(string myConnString) {
MailChimpConnection mailchimpConnection = new MailChimpConnection(myConnString);
MailChimpCommand mailchimpCommand = (MailChimpCommand)mailchimpConnection.CreateCommand();
mailchimpCommand.CommandText = "SELECT Id, Name, Type FROM Folders";
mailchimpConnection.Open();
MailChimpDataReader mailchimpReader = mailchimpCommand.ExecuteReader();
try {
// Always call Read before accessing data.
while (mailchimpReader.Read()) {
Console.WriteLine(mailchimpReader.GetInt32(0).ToString() + " " +
mailchimpReader.GetString(1) + " " + mailchimpReader.GetString(2));
}
}
finally {
// always call Close when done reading.
mailchimpReader.Close();
// Close the connection when done with it.
mailchimpConnection.Close();
}
}
Public Sub ReadMyData(ByVal myConnString As String)
Dim mailchimpConnection As New MailChimpConnection(myConnString)
Dim mailchimpCommand As MailChimpCommand = mailchimpConnection.CreateCommand()
mailchimpCommand.CommandText = "SELECT Id, Name, Type FROM Folders"
mailchimpConnection.Open()
Dim mailchimpReader As MailChimpDataReader = mailchimpCommand.ExecuteReader()
Try
' Always call Read before accessing data.
While mailchimpReader.Read()
Console.WriteLine(String.Concat(mailchimpReader.GetInt32(0).ToString(), " ", _
mailchimpReader.GetString(1), " ", mailchimpReader.GetString(2)))
End While
Finally
' always call Close when done reading.
mailchimpReader.Close()
' Close the connection when done with it.
mailchimpConnection.Close()
End Try
End Sub