void GetTableColumns(DbSchemaTable table)
{
try
{
OpenConnection();
string table_name = table.table_name;
DataTable schema = dbConnection.GetSchema("Columns");
foreach (DataRow row in schema.Rows)
{
if (row["TABLE_NAME"].ToString() == table_name)
{
DbSchemaColumn column = new DbSchemaColumn();
foreach (DataColumn col in schema.Columns)
{
column.SetItem(col.ColumnName, row[col.ColumnName].ToString());
}
table.AddColumn(column);
}
}
}
catch (DbException ex)
{
Show(ex);
}
CloseConnection();
}
public void AddColumn(DbSchemaColumn column)
{
columns.Add(column);
}
