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); }