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