dotConnect for Zoho Desk Documentation
Devart.Data.ZohoDesk Namespace / ZohoDeskCommand Class / CommandType Property
Example

In This Topic
    CommandType Property (ZohoDeskCommand)
    In This Topic
    Gets or sets a value indicating how the CommandText property is to be interpreted.
    Syntax
    'Declaration
     
    Public Overrides Property CommandType As CommandType
    public override CommandType CommandType {get; set;}

    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 ZohoDeskCommand and sets some of its properties.
    public void CreateCommand()
    {
      ZohoDeskCommand ZohoDeskCommand = new ZohoDeskCommand();
      ZohoDeskCommand.CommandText = "SELECT * FROM Accounts ORDER BY AccountID";
      ZohoDeskCommand.CommandType = CommandType.Text;
    }
    Public Sub CreateCommand()
      Dim ZohoDeskCommand As New ZohoDeskCommand()
      ZohoDeskCommand.CommandText = "SELECT * FROM Accounts ORDER BY AccountID"
      ZohoDeskCommand.CommandType = CommandType.Text
    End Sub
    See Also