I don't get data from the table in access with the same order as the table contents RRS feed

  • Question

  • Hi

    When I read a column from table in access database, I don't get the data with the same order that is in the table


    I use C# 2005


    Any  idea about this problem??

    Monday, July 2, 2007 7:31 PM


  • The records are not ordered by nature if you are referring to the records. Your query must force an ORDER BY explicitly.


    If you are referring to the order of the fields, they should be indexed.



    Monday, July 2, 2007 7:43 PM