Connection Property (QuickBooksCommand)

In This Topic

Gets or sets the QuickBooksConnection used by this instance of the QuickBooksCommand.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Property Connection As QuickBooksConnection

public new QuickBooksConnection Connection {get; set;}

Property Value

The connection to a data source. The default value is a null reference.

Remarks

QuickBooksConnection specified in this property will carry out all operations executed with this QuickBooksCommand.

Example

The following example creates a QuickBooksCommand and sets some of its properties.

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Customer ORDER BY Id";
  QuickBooksCommand quickBooksCommand = new QuickBooksCommand(mySelectQuery);
  quickBooksCommand.Connection = new QuickBooksConnection(
    "Company Id=1440905870;Refresh Token=AB11590759756UCO8O6CpRQcAMP00sIANafgS8Y4RN10rpLJNM;Token Server=file://D:\\temp\\QuickBooksToken.txt");
  quickBooksCommand.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Customer ORDER BY Id"
  Dim quickBooksCommand As New QuickBooksCommand(mySelectQuery)
  quickBooksCommand.Connection = New QuickBooksConnection( _
    "Company Id=1440905870;Refresh Token=AB11590759756UCO8O6CpRQcAMP00sIANafgS8Y4RN10rpLJNM;Token Server=file://D:\\temp\\QuickBooksToken.txt")
  quickBooksCommand.CommandType = System.Data.CommandType.Text
End Sub

Reference

QuickBooksCommand Class
QuickBooksCommand Members
CommandText Property
CommandType Property

Send Feedback