Contains information about table columns returned from function WIDatabase.Table.GetColumnInfo()
Namespace: Wiker.WIDatabaseAssembly:
Syntax
C# |
---|
public class TableColumnItem |
Visual Basic |
---|
Public Class TableColumnItem |
Visual C++ |
---|
public ref class TableColumnItem |
Examples

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();
Field | Value |
---|---|
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
Field | Value |
---|---|
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
Field | Value |
---|---|
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 |