DbLoaderColumnCollection Class

Represents a collection of columns relevant to a DbLoader.

For a list of all members of this type, see DbLoaderColumnCollection members.

Inheritance Hierarchy

System.Object
   System.Collections.CollectionBase
      Devart.Common.DbLoaderColumnCollection
         Devart.Data.Oracle.OracleLoaderColumnCollection

Syntax

[Visual Basic]
Public Class DbLoaderColumnCollection 
   Inherits CollectionBase
   Implements ICollection, IEnumerable, IList

[C#]
public class DbLoaderColumnCollection : CollectionBase, ICollection, IEnumerable, IList

Remarks

Use DbLoaderColumnCollection class to add or remove columns that will be loaded. Order and number of columns in the collection must be equal to the order and number of columns in the loaded table.

Example

Following example displays all loader columns.

[C#]

public void DisplayColumns(string tableName, OracleConnection conn) { 
 
  // Create loader instance 
  OracleLoader loader = new OracleLoader(); 
 
  // Set up working connection 
  // Connection must be opened 
  loader.Connection = conn; 
 
  // Set up table name for loading 
  loader.TableName = tableName; 
 
  // Create column collection for loading table 
  loader.CreateColumns(); 
 
  // Iterate through column collection 
  foreach (OracleLoaderColumn column in loader.Columns) 
    Console.WriteLine(column.Name); 
}

[Visual Basic]

Public Sub DisplayColumns(tableName as string, conn as OracleConnection)
 
  ' Create loader instance
   Dim loader as OracleLoader = new OracleLoader()
 
  ' Set up working connection
   ' Connection must be opened
   loader.Connection = conn
 
  ' Set up table name for loading
   loader.TableName = tableName
 
  ' Create column collection for loading table
   loader.CreateColumns()
 
  ' Iterate through column collection
   Dim column as OracleLoaderColumn
   For Each column in loader.Columns
     Console.WriteLine(column.Name)
   Next
 End Sub

See Also

Language