Connection Property (ZohoCommand)

In This Topic

Gets or sets the ZohoConnection used by this instance of the ZohoCommand.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Property Connection As ZohoConnection

public new ZohoConnection Connection {get; set;}

Property Value

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

Remarks

ZohoConnection specified in this property will carry out all operations executed with this ZohoCommand.

Example

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

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Accounts ORDER BY AccountID";
  ZohoCommand zohoCommand = new ZohoCommand(mySelectQuery);
  zohoCommand.Connection = new ZohoConnection(
    "API Version=V2;Refresh Token=1000.a6fde76542bfbb5244a7e539d4390e72.87e34ea57023c2d0e7dcb9ce55e3e7f3;ClientId=1000.M4FJLKYTSED90LJHUTVMKKAA432RUK;ClientSecret=89a0ed79957808814cdb20b9765423efffa767d1d0");
  zohoCommand.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Accounts ORDER BY AccountID"
  Dim zohoCommand As New ZohoCommand(mySelectQuery)
  zohoCommand.Connection = New ZohoConnection( _
    "API Version=V2;Refresh Token=1000.a6fde76542bfbb5244a7e539d4390e72.87e34ea57023c2d0e7dcb9ce55e3e7f3;ClientId=1000.M4FJLKYTSED90LJHUTVMKKAA432RUK;ClientSecret=89a0ed79957808814cdb20b9765423efffa767d1d0")
  zohoCommand.CommandType = System.Data.CommandType.Text
End Sub

Reference

ZohoCommand Class
ZohoCommand Members
CommandText Property
CommandType Property

Send Feedback