dotConnect for Zoho CRM Documentation
Devart.Data.Zoho Namespace / ZohoCommand Class / CommandType Property
Example

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