Add(String,SalesforceType,Int32,String) Method

In This Topic

Adds a SalesforceParameter to the SalesforceParameterCollection given the parameter name, data type, column width, and source column name.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Add( _
   ByVal parameterName As String, _
   ByVal type As SalesforceType, _
   ByVal size As Integer, _
   ByVal sourceColumn As String _
) As SalesforceParameter

public SalesforceParameter Add( 
   string parameterName,
   SalesforceType type,
   int size,
   string sourceColumn
)

Parameters

parameterName: The name of the parameter.
type
size: The maximum size, in bytes, of the data the parameter can contain.
sourceColumn: The name of the source column.

Return Value

The new SalesforceParameter object.

Example

The following example creates a SalesforceParameterCollection, adds instances of SalesforceParameter to the collection, and returns a reference to the new SalesforceParameter.

csharp

public void CreateSalesforceParamColl(SalesforceConnection myConn) { 
        SalesforceCommand salesforceCommand = new SalesforceCommand("SELECT * FROM Account WHERE Name = :Name", myConn); 
        SalesforceParameterCollection myParamCollection = salesforceCommand.Parameters; 
        object myParm = new SalesforceParameter("Name", SalesforceType.String, 255, "Name"); 
        int pIndex = myParamCollection.Add(myParm); 
}

Visual Basic

Public Sub CreateSalesforceParamColl(myConn As SalesforceConnection)
        Dim salesforceCommand As New SalesforceCommand("SELECT * FROM Account WHERE Name = :Name", myConn)
        Dim myParamCollection As SalesforceParameterCollection = salesforceCommand.Parameters
        Dim myParm As Object = New SalesforceParameter("Name", SalesforceType.[String], 255, "Name")
        Dim pIndex As Integer = myParamCollection.Add(myParm)
End Sub

Reference

SalesforceParameterCollection Class
SalesforceParameterCollection Members
Overload List

Send Feedback