CreateCommand Method (QuickBooksConnection)

In This Topic

Creates and returns a QuickBooksCommand object associated with the QuickBooksConnection.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateCommand() As QuickBooksCommand

public new QuickBooksCommand CreateCommand()

Return Value

A QuickBooksCommand object.

Remarks

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

Example

In this sample QuickBooksCommand object is created. It is automatically associated with QuickBooksConnection that created it.

csharp

public void CreateQuickBooksCommand(string myConnString)
{
  QuickBooksConnection quickBooksConnection = new QuickBooksConnection(myConnString);
  QuickBooksCommand quickBooksCommand = quickBooksConnection.CreateCommand();
  quickBooksCommand.CommandText = "INSERT INTO Customer (DisplayName, Notes) VALUES ('John Smith', 'VIP Customer')";
  quickBooksConnection.Open();
  try
  {
    quickBooksCommand.ExecuteNonQuery();
  }
  finally
  {
    quickBooksConnection.Close();
  }
}

Visual Basic

Public Sub CreateQuickBooksCommand(ByVal myConnString As String)
  Dim quickBooksConnection As New QuickBooksConnection(myConnString)
  Dim quickBooksCommand As QuickBooksCommand = quickBooksConnection.CreateCommand()
  quickBooksCommand.CommandText = "INSERT INTO Customer (DisplayName, Notes) VALUES ('John Smith', 'VIP Customer')"
  quickBooksConnection.Open()
  Try
    quickBooksCommand.ExecuteNonQuery()
  Finally
    quickBooksConnection.Close()
  End Try
End Sub

Reference

QuickBooksConnection Class
QuickBooksConnection Members
QuickBooksCommand Class

Send Feedback