Add(String,MySqlType,Int32,Int32,Int32) Method

In This Topic

Adds a MySqlLoaderColumn to the MySqlLoaderColumnCollection 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 MySqlType, _
   ByVal size As Integer, _
   ByVal precision As Integer, _
   ByVal scale As Integer _
) As Integer

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

Parameters

name: The name of the column.
dbType: One of the MySqlType values.
size: Maximum size of the column data (for strings only).
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 MySqlLoaderColumnCollection, adds an instance of MySqlLoaderColumn to the collection, and returns a reference to the new MySqlLoaderColumn.

csharp

public void CreateMyLoaderColumnColl(MySqlLoader myLoader)
{
  MySqlLoaderColumnCollection myColumnCollection = myLoader.Columns;
  myColumnCollection.Add("DeptNo", MySqlType.Int);
  myColumnCollection.Add("DName", MySqlType.VarChar);
  myColumnCollection.Add("Loc", MySqlType.VarChar);
}

Visual Basic

Public Sub CreateMyLoaderColumnColl(myLoader As MySqlLoader)
  Dim myColumnCollection As MySqlLoaderColumnCollection = myLoader.Columns
  myColumnCollection.Add("DeptNo", MySqlType.Int)
  myColumnCollection.Add("DName", MySqlType.VarChar)
  myColumnCollection.Add("Loc", MySqlType.VarChar)
End Sub

Reference

MySqlLoaderColumnCollection Class
MySqlLoaderColumnCollection Members
Overload List

Send Feedback