CreateCommand Method (FreshBooksConnection)

In This Topic

Creates and returns a FreshBooksCommand object associated with the FreshBooksConnection.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateCommand() As FreshBooksCommand

public new FreshBooksCommand CreateCommand()

Return Value

A FreshBooksCommand object.

Remarks

You can use this method as an alternative to common FreshBooksCommand constructors.

Example

In this sample FreshBooksCommand object is created. It is automatically associated with FreshBooksConnection that created it.

csharp

public void CreateFreshBooksCommand(string myConnString)
{
  FreshBooksConnection freshbooksConnection = new FreshBooksConnection(myConnString);
  FreshBooksCommand freshbooksCommand = freshbooksConnection.CreateCommand();
  freshbooksCommand.CommandText = "INSERT INTO Client (Email, FirstName, LastName) VALUES ('[email protected]', 'John', 'Smith')";
  freshbooksConnection.Open();
  try
  {
    freshbooksCommand.ExecuteNonQuery();
  }
  finally
  {
    freshbooksConnection.Close();
  }
}

Visual Basic

Public Sub CreateFreshBooksCommand(ByVal myConnString As String)
  Dim freshbooksConnection As New FreshBooksConnection(myConnString)
  Dim freshbooksCommand As FreshBooksCommand = freshbooksConnection.CreateCommand()
  freshbooksCommand.CommandText = "INSERT INTO Client (Email, FirstName, LastName) VALUES ('[email protected]', 'John', 'Smith')"
  freshbooksConnection.Open()
  Try
    freshbooksCommand.ExecuteNonQuery()
  Finally
    freshbooksConnection.Close()
  End Try
End Sub

Reference

FreshBooksConnection Class
FreshBooksConnection Members
FreshBooksCommand Class

Send Feedback