dotConnect for Salesforce Marketing Cloud Documentation
Devart.Data.ExactTarget Namespace / ExactTargetLoader Class / ExactTargetLoader Constructor / ExactTargetLoader Constructor(String,ExactTargetConnection)
Name of the table that will be loaded.
A ExactTargetConnection object that represents the connection to a data source.
Example

In This Topic
    ExactTargetLoader Constructor(String,ExactTargetConnection)
    In This Topic
    Initializes a new instance of the ExactTargetLoader class with table name that will be loaded and a ExactTargetConnection object.
    Syntax
    'Declaration
     
    Public Function New( _
       ByVal tableName As String, _
       ByVal connection As ExactTargetConnection _
    )
    public ExactTargetLoader( 
       string tableName,
       ExactTargetConnection connection
    )

    Parameters

    tableName
    Name of the table that will be loaded.
    connection
    A ExactTargetConnection object that represents the connection to a data source.
    Remarks
    Use this constructor to set TableName and Connection properties at the time of initialization.
    Example
    The following example creates a ExactTargetLoader and sets some of its properties. Then prepares data and loads it into the table.
    public void CreateMyLoader()
    {
      // Create and open connection
      ExactTargetConnection conn = new ExactTargetConnection(
          "user=MyCompanyAdmin;password=mypassword;url=https://webservice.s7.exacttarget.com/Service.asmx;");
      conn.Open();
    
      // Create loader instance
      ExactTargetLoader loader = new ExactTargetLoader("loader_test", conn);
         
      // Prepare for loading
      loader.Open();
    
      // Set row values
      for (int i = 0; i < 10000; i++) {
        loader.SetValue(0, i);
        loader.SetValue(1, "test string");
        loader.SetValue(2, DateTime.Now);
        // Load next table row
        loader.NextRow();
      }
    
      // Flush buffer and finish loading
      loader.Close();
    }
    Public Sub CreateMyLoader()
      ' Create and open connection
      Dim conn As ExactTargetConnection = new ExactTargetConnection( _
          "user=MyCompanyAdmin;password=mypassword;url=https://webservice.s7.exacttarget.com/Service.asmx;")
      conn.Open()
    
      ' Create loader instance
      Dim loader As ExactTargetLoader = new ExactTargetLoader("loader_test", conn)
         
      ' Prepare for loading
      loader.Open()
    
      ' Set row values
      Dim i As Integer
      For i = 0 To 10000
        loader.SetValue(0, i)
        loader.SetValue(1, "test string")
        loader.SetValue(2, DateTime.Now)
        ' Load next table row
        loader.NextRow()
      next
    
      ' Flush buffer and finish loading
      loader.Close()
    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

    Reference

    ExactTargetLoader Class
    ExactTargetLoader Members
    Overload List
    Devart.Data.ExactTarget.ExactTargetLoaderColumn
    Devart.Data.ExactTarget.ExactTargetLoaderColumnCollection