'Declaration Public Shadows Property SelectCommand As SalesforceCommand
public new SalesforceCommand SelectCommand {get; set;}
'Declaration Public Shadows Property SelectCommand As SalesforceCommand
public new SalesforceCommand SelectCommand {get; set;}
If SelectCommand does not return any rows, no tables are added to the System.Data.DataSet, and no exception is raised.
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