SalesforceDataAdapter Constructor(String,SalesforceConnection)

In This Topic

Initializes a new instance of the SalesforceDataAdapter class with a SelectCommand and a SalesforceConnection object.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal selectCommandText As String, _
   ByVal selectConnection As SalesforceConnection _
)

public SalesforceDataAdapter( 
   string selectCommandText,
   SalesforceConnection selectConnection
)

Parameters

selectCommandText: A System.String that contains a SQL SELECT statement to be used as the CommandText of the SelectCommand property of the SalesforceDataAdapter.
selectConnection: A SalesforceConnection that represents the connection.

Remarks

This implementation of the SalesforceDataAdapter can be useful in an application that must call the Fill method for two or more SalesforceDataAdapter objects.

Example

The following example creates a SalesforceDataAdapter, sets some of its properties, retrieves data from a table, and displays it.

csharp

public void CreateDataAdapter(SalesforceConnection salesforceConnection) 
{ 
        SalesforceDataAdapter myAdapter = new SalesforceDataAdapter("SELECT ID, Name FROM Account", salesforceConnection); 
        myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; 
        DataSet myDataSet = new DataSet(); 
        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(); 
        } 
}

Visual Basic

Public Sub CreateDataAdapter(salesforceConnection As SalesforceConnection)
        Dim myAdapter As New SalesforceDataAdapter("SELECT ID, Name FROM Account", salesforceConnection)
        myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
        Dim myDataSet As New DataSet()
        myAdapter.Fill(myDataSet, "Accounts")

        'Get all data from all tables within the dataset 
        For Each myTable As DataTable In myDataSet.Tables
                For Each myRow As DataRow In myTable.Rows
                        For Each myColumn As DataColumn In myTable.Columns
                                Console.Write(myRow(myColumn) + vbTab)
                        Next
                        Console.WriteLine()
                Next
                Console.WriteLine()
        Next
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

Reference

SalesforceDataAdapter Class
SalesforceDataAdapter Members
Overload List
SalesforceConnection Class
SalesforceCommand Class

Send Feedback