Represents a SQL statement or stored procedure to execute against Zoho Books.
The following example uses the
ExecuteReader method of
ZohoBooksCommand, along with
ZohoBooksDataReader and
ZohoBooksConnection, to select rows from a table.
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT AccountID, \"Account Name\" FROM Accounts";
ZohoBooksConnection ZohoBooksConnection = new ZohoBooksConnection(myConnString);
ZohoBooksCommand ZohoBooksCommand = new ZohoBooksCommand(mySelectQuery,ZohoBooksConnection);
ZohoBooksConnection.Open();
ZohoBooksDataReader ZohoBooksReader = ZohoBooksCommand.ExecuteReader();
try
{
while (ZohoBooksReader.Read())
{
Console.WriteLine(ZohoBooksReader.GetString(0) + ", " + ZohoBooksReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
ZohoBooksReader.Close();
// always call Close when done reading.
ZohoBooksConnection.Close();
}
}
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT AccountID, \"Account Name\" FROM Accounts"
Dim ZohoBooksConnection As New ZohoBooksConnection(myConnString)
Dim ZohoBooksCommand As New ZohoBooksCommand(mySelectQuery, ZohoBooksConnection)
ZohoBooksConnection.Open()
Dim ZohoBooksReader As ZohoBooksDataReader = ZohoBooksCommand.ExecuteReader()
Try
While ZohoBooksReader.Read()
Console.WriteLine(ZohoBooksReader.GetString(0) + ", " _
+ ZohoBooksReader.GetString(1))
End While
Finally
' always call Close when done reading.
ZohoBooksReader.Close()
' always call Close when done with connection.
ZohoBooksConnection.Close()
End Try
End Sub