changing ordinal position in access table

[adiel_g]

I want to re-arrange some of the fields in an access table. I know
this could be done from the previous microsoft database objects. I am
not sure if ADO.NET can do this. Can you change the ordinal position
of fields in a table from ADO.NET?

Thanks Before Hand,
Adiel

 

[Jeff Dillon]

Why? Select field1, field2 from Table1 then Select field2, field1 from
Table1

Jeff

 

[Miha Markic [MVP C#]]

Yep, Jeff is correct. Why would you want to re-arrange fields?
Just use a select statement(s) that address fields by name instead of index
(which is a bad way to address them).

 

[Paul Clement]

On 25 Oct 2006 12:43:24 -0700, (e-mail address removed) wrote:

¤ I want to re-arrange some of the fields in an access table. I know
¤ this could be done from the previous microsoft database objects. I am
¤ not sure if ADO.NET can do this. Can you change the ordinal position
¤ of fields in a table from ADO.NET?

No, not without dropping and re-adding the column.


Paul
~~~~
Microsoft MVP (Visual Basic)