GetSchema - need Columns in Ordinal Position

  • Thread starter Thread starter Algonquin J. Calhoun
  • Start date Start date
A

Algonquin J. Calhoun

Hello All,

I'm writing a small utility to assist my coding when using access tables. In this phase, I want to get the schema columns when creating a datatable
of columns and attributes using the statement:

dtc = cn.GetSchema("Columns", dtcRest)

I retrieve all the columns OK, but I want them to be in ORDINAL_POSITION (a column in the resulting table) sequence. I've tried everything I could
think of (ORDER BY), but just can't get it.

Now its time to try something that others have thought of.

Need some help.

Thanks,

Al
 
For Access (JET) tables, many of the field properties can be read only
through DAO.

Here's an example of how to enumerate the fields of a table in order:
http://allenbrowne.com/func-06.html

If you need it, fields also have an OrdinalPosition property exposted via
DAO.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GetSchema to retrieve column properties 5
GetSchema( "Columns" ) results in ??? 6
How does GetSchema get foreign key constraints? 4
Access #Error & Excel Pivot 0
How do I get all column descriptions from a schema.table? 7
Sum using ordinal/relative positioning 3
How is System.Data.DataTable.Load() determining whether a column is a primary key? 1
Image not displaying in datagridview column in vb.net 1

Back
Top