dotConnect for SugarCRM Documentation
Devart.Data.Sugar Namespace / SugarCommand Class / Connection Property
Example

Connection Property (SugarCommand)
Gets or sets the SugarConnection used by this instance of the SugarCommand.
Syntax
'Declaration
 
Public Shadows Property Connection As SugarConnection
 

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.
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;
}
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
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also