ExecuteReader(CommandBehavior) Method
The following example creates a
SalesforceCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source. The
System.Data.CommandBehavior is then set to CloseConnection.
|
|---|
public void CreateSalesforceDataReader(string mySelectQuery,string salesforceConnectionString)
{
SalesforceConnection salesforceConnection = new SalesforceConnection(salesforceConnectionString);
SalesforceCommand salesforceCommand = new SalesforceCommand(mySelectQuery, salesforceConnection);
salesforceCommand.Connection.Open();
SalesforceDataReader salesforceReader = salesforceCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(salesforceReader.Read())
{
Console.WriteLine(salesforceReader.GetString(0));
}
salesforceReader.Close();
} |
|
|---|
Public Sub CreateSalesforceDataReader(mySelectQuery As String, _
salesforceConnectionString As String)
Dim salesforceConnection As New SalesforceConnection(salesforceConnectionString)
Dim salesforceCommand As New SalesforceCommand(mySelectQuery, salesforceConnection)
salesforceCommand.Connection.Open()
Dim salesforceReader As SalesforceDataReader = salesforceCommand.ExecuteReader(CommandBehavior.CloseConnection)
While salesforceReader.Read()
Console.WriteLine(salesforceReader.GetString(0))
End While
salesforceReader.Close()
End Sub |
