SalesforceType Property (SalesforceLoaderColumn)

In This Topic

Gets or sets the SalesforceType of the column.

Syntax

Visual Basic
C#

'Declaration
 
Public Property SalesforceType As SalesforceType

public SalesforceType SalesforceType {get; set;}

Property Value

A SalesforceType value of the column. The default value is SalesforceType.VarChar.

Remarks

Use SalesforceType property to specify Salesforce.com or Database.com data type for the column.

Example

csharp

public void GetDataColumns(SalesforceConnection salesforceConnection)
{
  salesforceConnection.Open();
  SalesforceLoader loader = new SalesforceLoader();
  loader.Connection = salesforceConnection;
  loader.TableName = "load_table";
  SalesforceLoaderColumn myColumn;
  try
  {
    loader.CreateColumns();
    for (int i = 0; i < loader.Columns.Count; i++)
    {
      myColumn = loader.Columns[i];
      Console.WriteLine(myColumn.Name);
      Console.WriteLine(myColumn.SalesforceType.ToString());
      Console.WriteLine(myColumn.Size);
      Console.WriteLine(myColumn.Scale);
      Console.WriteLine(myColumn.Precision);
      Console.WriteLine();
    }
   }
  finally
  {
    salesforceConnection.Close();
  }
}

Visual Basic

Public Sub GetDataColumns(ByVal salesforceConnection As SalesforceConnection)
  salesforceConnection.Open()
  Dim loader As SalesforceLoader
  loader = New SalesforceLoader
  loader.Connection = salesforceConnection
  loader.TableName = "load_table"
  Dim myColumn As SalesforceLoaderColumn
  Try
    loader.CreateColumns()
    Dim i As Integer
    For i = 0 To loader.Columns.Count - 1
      myColumn = loader.Columns(i)
      Console.WriteLine(myColumn.Name)
      Console.WriteLine(myColumn.SalesforceType.ToString())
      Console.WriteLine(myColumn.Size)
      Console.WriteLine(myColumn.Scale)
      Console.WriteLine(myColumn.Precision)
      Console.WriteLine()
    Next i
  Finally
    salesforceConnection.Close()
  End Try
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

SalesforceLoaderColumn Class
SalesforceLoaderColumn Members
CreateColumns Method

Send Feedback