Fields in Access database returned in alphabetical order

[Julian]

I'm using the following VB.Net code to retreive the field names of a table
in an Access db:

Dim NewField As ADOX.Column
Dim tblField As ADOX.Column

For Each tblField In adocat.Tables("tblData").Columns
The fields are returned in alphabetical order! I want to have the fields
returned in the order they were created. Can this be done?

-Julian

[Armin Zingler]

"Julian" <ad***@jdmils.com> schrieb

I'm using the following VB.Net code to retreive the field names of a
table in an Access db:

Dim NewField As ADOX.Column
Dim tblField As ADOX.Column

For Each tblField In adocat.Tables("tblData").Columns
The fields are returned in alphabetical order! I want to have the
fields returned in the order they were created. Can this be done?

-Julian

It is not available in ADOX. Use DAO for native Jet support. See the
Ordinalposition property of the Field object. The DAO docu also says that
two fields can have the same ordinal position. More information:
http://msdn.microsoft.com/archive/de.../D2/S5A2D1.asp
Armin

[Julian]

How do you use DAO in VB.Net?

--
|
+-- Julian
|
"Armin Zingler" <az*******@freenet.de> wrote in message
news:e7**************@TK2MSFTNGP11.phx.gbl...

"Julian" <ad***@jdmils.com> schrieb

I'm using the following VB.Net code to retreive the field names of a
table in an Access db:

Dim NewField As ADOX.Column
Dim tblField As ADOX.Column

For Each tblField In adocat.Tables("tblData").Columns
The fields are returned in alphabetical order! I want to have the
fields returned in the order they were created. Can this be done?

-Julian

It is not available in ADOX. Use DAO for native Jet support. See the
Ordinalposition property of the Field object. The DAO docu also says that
two fields can have the same ordinal position. More information:
http://msdn.microsoft.com/archive/de.../D2/S5A2D1.asp
Armin

[Chris]

Armin Zingler wrote:

"Julian" <ad***@jdmils.com> schrieb

I'm using the following VB.Net code to retreive the field names of a
table in an Access db:

Dim NewField As ADOX.Column
Dim tblField As ADOX.Column

For Each tblField In adocat.Tables("tblData").Columns
The fields are returned in alphabetical order! I want to have the
fields returned in the order they were created. Can this be done?

-Julian

It is not available in ADOX. Use DAO for native Jet support. See the
Ordinalposition property of the Field object. The DAO docu also says
that two fields can have the same ordinal position. More information:
http://msdn.microsoft.com/archive/de.../D2/S5A2D1.asp

Armin

You can get it in ADO which is the .net way of doing things. There is a
function on the connection or command object called gettableschema that
will get you the info you want.

Chris

[Armin Zingler]

"Chris" <[e-mail]> schrieb

It is not available in ADOX. Use DAO for native Jet support. See
the Ordinalposition property of the Field object. The DAO docu
also says that two fields can have the same ordinal position. More
information:
http://msdn.microsoft.com/archive/de.../D2/S5A2D1.asp

Armin

You can get it in ADO which is the .net way of doing things. There
is a function on the connection or command object called
gettableschema that will get you the info you want.

I thought ADOX is even closer to DAO than ADO.Net. Therefore I did
not even think of doing it in ADO.Net. But your probably right.
Armin

[Armin Zingler]

"Julian" <ad***@jdmils.com> schrieb

How do you use DAO in VB.Net?

Set a reference to "Microsoft Data Access Objects". But you should probably
better have a look at Chris' answer.

See also: System.Data.OleDb.OleDbConnection.GetOleDbSchemaTa ble

and

http://msdn.microsoft.com/library/en...mns_rowset.asp
Column "ORDINAL_POSITION"

http://msdn.microsoft.com/library/en...t_overview.asp
especially
http://msdn.microsoft.com/library/en...ma_rowsets.asp

Armin