The following example creates a
FreshBooksCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source.
public void CreateFreshBooksDataReader(string mySelectQuery,string freshbooksConnectionString)
{
FreshBooksConnection freshbooksConnection = new FreshBooksConnection(freshbooksConnectionString);
FreshBooksCommand freshbooksCommand = new FreshBooksCommand(mySelectQuery, freshbooksConnection);
freshbooksCommand.Connection.Open();
FreshBooksDataReader freshbooksReader = freshbooksCommand.ExecuteReader();
try
{
while(freshbooksReader.Read())
{
Console.WriteLine(freshbooksReader.GetString(0));
}
}
finally
{
freshbooksReader.Close();
freshbooksConnection.Close();
}
}
Public Sub CreateFreshBooksDataReader(mySelectQuery As String, _
freshbooksConnectionString As String)
Dim freshbooksConnection As New FreshBooksConnection(freshbooksConnectionString)
Dim freshbooksCommand As New FreshBooksCommand(mySelectQuery, freshbooksConnection)
freshbooksCommand.Connection.Open()
Dim freshbooksReader As FreshBooksDataReader = freshbooksCommand.ExecuteReader()
Try
While freshbooksReader.Read()
Console.WriteLine(freshbooksReader.GetString(0))
End While
Finally
freshbooksReader.Close()
freshbooksConnection.Close()
End Try
End Sub