dotConnect for Salesforce Documentation
Devart.Data.Salesforce Namespace / SalesforceDataAdapter Class / SelectCommand Property
Example

In This Topic
    SelectCommand Property
    In This Topic
    Gets or sets Salesforce.com or Database.com statement used to select records in the data source.
    Syntax
    'Declaration
     
    Public Shadows Property SelectCommand As SalesforceCommand
    public new SalesforceCommand SelectCommand {get; set;}

    Property Value

    A SalesforceCommand that is used during a fill operation to select records from the data source for placement in the System.Data.DataSet.
    Remarks
    When SelectCommand is assigned to a previously created SalesforceCommand, the SalesforceCommand is not cloned. Instead, the SelectCommand maintains a reference to the previously created SalesforceCommand object.

    If SelectCommand does not return any rows, no tables are added to the System.Data.DataSet, and no exception is raised.

    Example
    The following example creates a SalesforceDataAdapter, sets some of its properties, retrieves data from a table, and displays it.
    public void CreateDataAdapter(SalesforceConnection salesforceConnection) 
    { 
            SalesforceDataAdapter myAdapter = new SalesforceDataAdapter(); 
            myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; 
            DataSet myDataSet = new DataSet(); 
            myAdapter.SelectCommand = new SalesforceCommand("SELECT ID, Name FROM Account", salesforceConnection); 
            myAdapter.Fill(myDataSet,"Accounts"); 
            //Get all data from all tables within the dataset 
            foreach(DataTable myTable in myDataSet.Tables) 
            { 
                    foreach(DataRow myRow in myTable.Rows) 
                    { 
                            foreach (DataColumn myColumn in myTable.Columns) 
                            { 
                                    Console.Write(myRow[myColumn]+"\t"); 
                            } 
                            Console.WriteLine(); 
                    } 
                    Console.WriteLine(); 
            } 
    }
    Public Sub CreateDataAdapter(ByVal salesforceConnection As SalesforceConnection)
            Dim myAdapter As SalesforceDataAdapter = New SalesforceDataAdapter
            myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
            Dim myDataSet As DataSet = New DataSet
            myAdapter.SelectCommand = New SalesforceCommand("SELECT ID, Name FROM Account", salesforceConnection)
            myAdapter.Fill(myDataSet, "Accounts")
            Dim myTable As DataTable
            Dim myRow As DataRow
            Dim myColumn As DataColumn
            ' Get all data from all tables within the dataset
            For Each myTable In myDataSet.Tables
                    For Each myRow In myTable.Rows
                            For Each myColumn In myTable.Columns
                                    Console.Write(myRow(myColumn) & Chr(9))
                            Next myColumn
                            Console.WriteLine()
                    Next myRow
                    Console.WriteLine()
            Next myTable
    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