MySqlType Property (MySqlLoaderColumn)

In This Topic

Gets or sets the MySqlType of the column.

Syntax

Visual Basic
C#

'Declaration
 
Public Property MySqlType As MySqlType

public MySqlType MySqlType {get; set;}

Property Value

A MySqlType value of the column. The default value is MySqlType.VarChar.

Remarks

Use MySqlType property to specify MySQL data type for the column.

Example

csharp

public void GetDataColumns(MySqlConnection myConnection)
{
  myConnection.Database = "Test";
  myConnection.Open();
  MySqlLoader loader = new MySqlLoader();
  loader.Connection = myConnection;
  loader.TableName = "load_table";
  MySqlLoaderColumn myColumn;
  try
  {
    loader.CreateColumns();
    for (int i = 0; i < loader.Columns.Count; i++)
    {
      myColumn = loader.Columns[i];
      Console.WriteLine(myColumn.Name);
      Console.WriteLine(myColumn.MySqlType.ToString());
      Console.WriteLine(myColumn.Size);
      Console.WriteLine(myColumn.Scale);
      Console.WriteLine(myColumn.Precision);
      Console.WriteLine();
    }
   }
  finally
  {
    myConnection.Close();
  }
}

Visual Basic

Public Sub GetDataColumns(ByVal myConnection As MySqlConnection)
  myConnection.Database = "Test"
  myConnection.Open()
  Dim loader As MySqlLoader
  loader = New MySqlLoader
  loader.Connection = myConnection
  loader.TableName = "load_table"
  Dim myColumn As MySqlLoaderColumn
  Try
    loader.CreateColumns()
    Dim i As Integer
    For i = 0 To loader.Columns.Count - 1
      myColumn = loader.Columns(i)
      Console.WriteLine(myColumn.Name)
      Console.WriteLine(myColumn.MySqlType.ToString())
      Console.WriteLine(myColumn.Size)
      Console.WriteLine(myColumn.Scale)
      Console.WriteLine(myColumn.Precision)
      Console.WriteLine()
    Next i
  Finally
    myConnection.Close()
  End Try
End Sub

Reference

MySqlLoaderColumn Class
MySqlLoaderColumn Members
CreateColumns Method

Send Feedback