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

'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); }

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

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