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

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

Jeff
<adie***@hotmail.com> wrote in message
Show quoteHide quote

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).

Show quoteHide quote

On 25 Oct 2006 12:43:24 -0700, adie***@hotmail.com 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)

VB6 memory recordsets to .NET
DataSet help -- .Merge() & .GetChanges()
TableAdapters and Transactions again!
binding tables in many-to-many relationships
comparison reporting -- technique suggestions?