retrieving columns from database

Question

Hello i retrieve this ways at the moment columns from the database: System.Data.DataTable schemaTable = Connection.GetOleDbSchemaTable( System.Data.OleDb.OleDbSchemaGuid.Columns new object [ ] {null null DefaultTable null} ); the problem is that the order in what they are returned doens't correspond with the structure of the database. How can this be solved? greetings Sander

s 0 · Answer

thx it worked :-) Sander

Andrzej Wegierski · Answer

Use DefaultView from output table. Sort on TABLE_NAME and ORDINAL_POSITION.