Connection Property (SugarCommand)

In This Topic

Gets or sets the SugarConnection used by this instance of the SugarCommand.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Property Connection As SugarConnection

public new SugarConnection Connection {get; set;}

Property Value

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

Remarks

SugarConnection specified in this property will carry out all operations executed with this SugarCommand.

Example

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

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Campaigns ORDER BY id";
  SugarCommand sugarCommand = new SugarCommand(mySelectQuery);
  sugarCommand.Connection = new SugarConnection(
    "server=https://your_company.sugaropencloud.eu;user id=admin;password=AmFFA4ZryM;");
  sugarCommand.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Campaigns ORDER BY id"
  Dim sugarCommand As New SugarCommand(mySelectQuery)
  sugarCommand.Connection = New SugarConnection( _
    "server=https://your_company.sugaropencloud.eu;user id=admin;password=AmFFA4ZryM;")
  sugarCommand.CommandType = System.Data.CommandType.Text
End Sub

Reference

SugarCommand Class
SugarCommand Members
CommandText Property
CommandType Property

Send Feedback