Represents a SQL statement or stored procedure to execute against FreshBooks.
The following example uses the
ExecuteReader method of
FreshBooksCommand, along with
FreshBooksDataReader and
FreshBooksConnection, to select rows from a table.
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT Id, LastName FROM Client";
FreshBooksConnection freshbooksConnection = new FreshBooksConnection(myConnString);
FreshBooksCommand freshbooksCommand = new FreshBooksCommand(mySelectQuery,freshbooksConnection);
freshbooksConnection.Open();
FreshBooksDataReader freshbooksReader = freshbooksCommand.ExecuteReader();
try
{
while (freshbooksReader.Read())
{
Console.WriteLine(freshbooksReader.GetString(0) + ", " + freshbooksReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
freshbooksReader.Close();
// always call Close when done reading.
freshbooksConnection.Close();
}
}
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT Id, LastName FROM Client"
Dim freshbooksConnection As New FreshBooksConnection(myConnString)
Dim freshbooksCommand As New FreshBooksCommand(mySelectQuery, freshbooksConnection)
freshbooksConnection.Open()
Dim freshbooksReader As FreshBooksDataReader = freshbooksCommand.ExecuteReader()
Try
While freshbooksReader.Read()
Console.WriteLine(freshbooksReader.GetString(0) + ", " _
+ freshbooksReader.GetString(1))
End While
Finally
' always call Close when done reading.
freshbooksReader.Close()
' always call Close when done with connection.
freshbooksConnection.Close()
End Try
End Sub