Return Value
true if there are more rows; otherwise, false.
While the SqlShimDataReader is in use, the associated Devart.Data.Zoho.ZohoConnection is busy serving it until you call Close.
public void ReadMyData(string myConnString) { string mySelectQuery = "SELECT AccountID, \"Account Name\" FROM Accounts"; ZohoConnection zohoConnection = new ZohoConnection(myConnString); ZohoCommand zohoCommand = new ZohoCommand(mySelectQuery,zohoConnection); zohoConnection.Open(); ZohoDataReader zohoReader; zohoReader = zohoCommand.ExecuteReader(); // Always call Read before accessing data. while (zohoReader.Read()) { Console.WriteLine(zohoReader.GetString(0) + ", " + zohoReader.GetString(1)); } // always call Close when done reading. zohoReader.Close(); // Close the connection when done with it. zohoConnection.Close(); }
Public Sub ReadMyData(myConnString As String) Dim mySelectQuery As String = "SELECT AccountID, \"Account Name\" FROM Accounts" Dim zohoConnection As New ZohoConnection(myConnString) Dim zohoCommand As New ZohoCommand(mySelectQuery, zohoConnection) zohoConnection.Open() Dim zohoReader As ZohoDataReader zohoReader = zohoCommand.ExecuteReader() ' Always call Read before accessing data. While zohoReader.Read() Console.WriteLine(zohoReader.GetString(0) + ", " _ + zohoReader.GetString(1)) End While ' always call Close when done reading. zohoReader.Close() ' Close the connection when done with it. zohoConnection.Close() End Sub