Contains information about table columns returned from function WIDatabase.Table.GetColumnInfo()

Namespace: Wiker.WIDatabase
Assembly: 

Syntax

C#
public class TableColumnItem
Visual Basic
Public Class TableColumnItem
Visual C++
public ref class TableColumnItem

Examples

CopyC#
WIDatabase WIDB;
CDatabaseInfo DBInfo;
Collection<TableColumnItem>ColumnInfo;
string DataTypeName, ColumnName;
Type FieldType;

DBInfo = new CDatabaseInfo();
DBInfo.DatabaseType = eDatabaseType.SQL;
DBInfo.Location     = "SqlServer";
DBInfo.DBName       = "TestDatabase";
DBInfo.Username     = "LoginName";
DBInfo.Password     = "LoginPassword";

WIDB = new WIDatabase(DBInfo);

/*----------------------------------------------------------------------------*/

if (!WIDB.Table.GetColumnInfo("tblDataType", out ColumnInfo))
   {
   MessageBox.Show(string.Format("Failed To GetColumnInfo\n{0} - {1}", 
                   WIDB.LastError.ToString(), WIDB.LastErrorMessage));
   return(false);
   }

foreach(TableColumnItem Item in ColumnInfo)
   {
   DataTypeName = Item.DataTypeName;
   ColumnName = Item.ColumnName;
   FieldType = Item.FieldType;
   }

WIDB.Close();
Sql
FieldValue
ColumnName[0]ColumnID
DataTypeName[0]int
FieldType[0]System.Int32
ColumnName[1]Bool
DataTypeName[1]bit
FieldType[1]System.Boolean
ColumnName[2]Byte
DataTypeName[2]tinyint
FieldType[2]System.Byte
ColumnName[3]Int16
DataTypeName[3]smallint
FieldType[3]System.Int16
ColumnName[4]Int32
DataTypeName[4]int
FieldType[4]System.Int32
ColumnName[5]Int64
DataTypeName[5]bigint
FieldType[5]System.Int64

 

 

MySql
FieldValue
ColumnName[0]ColumnID
DataTypeName[0]INT
FieldType[0]System.Int32
ColumnName[1]Bool
DataTypeName[1]BIT
FieldType[1]System.UInt64
ColumnName[2]Byte
DataTypeName[2]TINYINT
FieldType[2]System.Byte
ColumnName[3]Int16
DataTypeName[3]SMALLINT
FieldType[3]System.Int16
ColumnName[4]Int32
DataTypeName[4]INT
FieldType[4]System.Int32
ColumnName[5]Int64
DataTypeName[5]BIGINT
FieldType[5]System.Int64

 

 

SQLite
FieldValue
ColumnName[0]ColumnID
DataTypeName[0]INTEGER
FieldType[0]System.Int64
ColumnName[1]Bool
DataTypeName[1]INTEGER
FieldType[1]System.Int64
ColumnName[2]Byte
DataTypeName[2]INTEGER
FieldType[2]System.Int64
ColumnName[3]Int16
DataTypeName[3]INTEGER
FieldType[3]System.Int64
ColumnName[4]Int32
DataTypeName[4]INTEGER
FieldType[4]System.Int64
ColumnName[5]Int64
DataTypeName[5]INTEGER
FieldType[5]System.Int64

Inheritance Hierarchy

System..::..Object
  Wiker.WIDatabase..::..TableColumnItem

See Also