Return Value
true if there are more rows; otherwise, false.
While the SqlShimDataReader is in use, the associated Devart.Data.MailChimp.MailChimpConnection is busy serving it until you call Close.
public void ReadMyData(string myConnString) { string mySelectQuery = "SELECT Id, Name FROM Folders"; MailChimpConnection mailchimpConnection = new MailChimpConnection(myConnString); MailChimpCommand mailchimpCommand = new MailChimpCommand(mySelectQuery,mailchimpConnection); mailchimpConnection.Open(); MailChimpDataReader mailchimpReader; mailchimpReader = mailchimpCommand.ExecuteReader(); // Always call Read before accessing data. while (mailchimpReader.Read()) { Console.WriteLine(mailchimpReader.GetString(0) + ", " + mailchimpReader.GetString(1)); } // always call Close when done reading. mailchimpReader.Close(); // Close the connection when done with it. mailchimpConnection.Close(); }
Public Sub ReadMyData(myConnString As String) Dim mySelectQuery As String = "SELECT Id, Name FROM Folders" Dim mailchimpConnection As New MailChimpConnection(myConnString) Dim mailchimpCommand As New MailChimpCommand(mySelectQuery, mailchimpConnection) mailchimpConnection.Open() Dim mailchimpReader As MailChimpDataReader mailchimpReader = mailchimpCommand.ExecuteReader() ' Always call Read before accessing data. While mailchimpReader.Read() Console.WriteLine(mailchimpReader.GetString(0) + ", " _ + mailchimpReader.GetString(1)) End While ' always call Close when done reading. mailchimpReader.Close() ' Close the connection when done with it. mailchimpConnection.Close() End Sub