CreateParameter Method (SalesforceCommand)

In This Topic

Creates a new instance of a SalesforceParameter object.

Syntax

Visual Basic
C#

'Declaration
 
Public Shadows Function CreateParameter() As SalesforceParameter

public new SalesforceParameter CreateParameter()

Return Value

A SalesforceParameter object.

Remarks

This method is a strongly-typed version of System.Data.IDbCommand.CreateParameter. See SalesforceParameter to find out more ways to create a parameter.

Example

This sample shows how to create a parameter using CreateParameter function.

csharp

public void CreateParam(SalesforceConnection salesforceConnection) 
{ 
        SalesforceCommand salesforceCommand = new SalesforceCommand("SELECT * FROM Account WHERE Name=:Name",salesforceConnection); 
        SalesforceParameter myParam = salesforceCommand.CreateParameter(); 
        myParam.SalesforceDbType = Devart.Data.Salesforce.SalesforceType.String; 
        myParam.Value = "GenePoint"; 
        myParam.ParameterName = "Name"; 
        salesforceCommand.Parameters.Add(myParam); 
        salesforceConnection.Open(); 
        SalesforceDataReader salesforceReader = null;  
        try 
        { 
                salesforceReader = salesforceCommand.ExecuteReader();  
                while (salesforceReader.Read()) 
                { 
                        Console.WriteLine(salesforceReader.GetString(0) + ", " + salesforceReader.GetString(1) + ", " + salesforceReader.GetString(2)); 
                } 
        } 
        finally 
        { 
                salesforceReader.Close(); 
                salesforceConnection.Close(); 
        } 
}

Visual Basic

Public Sub CreateParam(salesforceConnection As SalesforceConnection)
        Dim salesforceCommand As New SalesforceCommand("SELECT * FROM Account WHERE Name=:Name", salesforceConnection)
        Dim myParam As SalesforceParameter = salesforceCommand.CreateParameter()
        myParam.SalesforceDbType = Devart.Data.Salesforce.SalesforceType.[String]
        myParam.Value = "GenePoint"
        myParam.ParameterName = "Name"
        salesforceCommand.Parameters.Add(myParam)
        salesforceConnection.Open()
        Dim salesforceReader As SalesforceDataReader = Nothing
        Try
                salesforceReader = salesforceCommand.ExecuteReader()
                While salesforceReader.Read()
                        Console.WriteLine(salesforceReader.GetString(0) & ", " & salesforceReader.GetString(1) & ", " & salesforceReader.GetString(2))
                End While
        Finally
                salesforceReader.Close()
                salesforceConnection.Close()
        End Try
End Sub

Reference

SalesforceCommand Class
SalesforceCommand Members
Parameters Property
SalesforceParameter Class

Send Feedback