Add(String,PgSqlType,Int32,Int32,Int32) Method

In This Topic

Adds a PgSqlLoaderColumn to the PgSqlLoaderColumnCollection given the column name, column data type, column size, precision, and scale.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Add( _
   ByVal name As String, _
   ByVal dbType As PgSqlType, _
   ByVal size As Integer, _
   ByVal precision As Integer, _
   ByVal scale As Integer _
) As Integer

public int Add( 
   string name,
   PgSqlType dbType,
   int size,
   int precision,
   int scale
)

Parameters

name: The name of the column.
dbType: One of the PgSqlType values.
size: Maximum size of the column data (only for strings).
precision: The precision of the column.
scale: The scale of the column.

Return Value

The new column's ordinal.

Example

The following example creates a PgSqlLoaderColumnCollection, adds an instance of PgSqlLoaderColumn to the collection, and returns a reference to the new PgSqlLoaderColumn.

csharp

public void CreatePgLoaderColumnColl(PgSqlLoader myLoader)
{
  PgSqlLoaderColumnCollection myColumnCollection = myLoader.Columns;
  myColumnCollection.Add("DeptNo", PgSqlType.Int);
  myColumnCollection.Add("DName", PgSqlType.VarChar);
  myColumnCollection.Add("Loc", PgSqlType.VarChar);
}

Visual Basic

Public Sub CreatePgLoaderColumnColl(myLoader As PgSqlLoader)
  Dim myColumnCollection As PgSqlLoaderColumnCollection = myLoader.Columns
  myColumnCollection.Add("DeptNo", PgSqlType.Int)
  myColumnCollection.Add("DName", PgSqlType.VarChar)
  myColumnCollection.Add("Loc", PgSqlType.VarChar)
End Sub 'CreatePgSqlLoaderColumnColl

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

PgSqlLoaderColumnCollection Class
PgSqlLoaderColumnCollection Members
Overload List

Send Feedback