Retrieve information about columns within table
Namespace: Wiker.WIDatabaseAssembly:
Syntax
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 (!GetColumnInfo("TableX", 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();
See Also