dotConnect for SugarCRM Documentation
Devart.Data.Sugar Namespace / SugarCommand Class / SugarCommand Constructor / SugarCommand Constructor(String)
The text of the query.
Example

SugarCommand Constructor(String)
Initializes a new instance of the SugarCommand class with the text of the query.
Syntax
'Declaration
 
Public Function New( _
   ByVal commandText As String _
)
 

Parameters

commandText
The text of the query.
Remarks
The following table shows initial property values for an instance of SugarCommand.
Properties Initial value
CommandText commandText
CommandTimeout 30
CommandType System.Data.CommandType.Text
Connection null
Example
The following example creates a SugarCommand and sets some of its properties.
public void CreateSugarCommand()
{
  string mySelectQuery = "SELECT * FROM Campaigns";
  SugarCommand sugarCommand = new SugarCommand(mySelectQuery);
  sugarCommand.FetchSize = 100;
}
Public Sub CreateSugarCommand()
  Dim mySelectQuery As String = "SELECT * FROM Campaigns"
  Dim sugarCommand As New SugarCommand(mySelectQuery)
  sugarCommand.FetchSize = 100
End Sub
See Also