CommandType Property (FreshBooksCommand)

In This Topic

Syntax
Remarks
Example
See Also

Gets or sets a value indicating how the CommandText property is to be interpreted.

Syntax

Visual Basic
C#

public override CommandType CommandType {get; set;}

'Declaration
 
Public Overrides Property CommandType As CommandType

Property Value

One of the System.Data.CommandType values. The default value is System.Data.CommandType.Text.

Remarks

CommandType can be one of the following values: Text, StoredProcedure, TableDirect.

When the value is CommandType.Text, the property CommandText should contain text of a query that must be run on the server.

When the value is CommandType.StoredProcedure, CommandText property must be a name of a procedure to execute.

When the value is set to TableDirect, CommandText must be name of a table you want to get all data from. All rows and columns are retrieved.

Example

The following example creates an instance of a derived class FreshBooksCommand and sets some of its properties.

csharp

public void CreateCommand()
{
  FreshBooksCommand freshbooksCommand = new FreshBooksCommand();
  freshbooksCommand.CommandText = "SELECT * FROM Client ORDER BY Id";
  freshbooksCommand.CommandType = CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim freshbooksCommand As New FreshBooksCommand()
  freshbooksCommand.CommandText = "SELECT * FROM Client ORDER BY Id"
  freshbooksCommand.CommandType = CommandType.Text
End Sub

Reference

FreshBooksCommand Class
FreshBooksCommand Members
CommandText Property

Send Feedback