locked
Immobile rows equivalent in ADO.NET RRS feed

  • Question

  • Hi,

    We are inserting huge records to MS Access database (.mdb) in sorted order but after insertion the sorted order gets changed, I found an article which talks about "New rows are appended to end of row set." by using immobile rows database property. I need to use this so that all my inserted row order will be kept as is for the .mdb.

    Do we have an equivalent property in OLEDB or SQL Client command / connection objects? or how can I use that for ADO.NET OLEDB application??

    any help would help me a lot!!

    Thursday, March 25, 2010 3:25 AM

Answers

  • You can never rely on row insertion order. Instead you should select data using "orderby" where you specify the requested order.

    In your case you should add (if there is not) a field, or fields that specifies order position and later, when selecting, use it for order determination.


    Miha Markic [MVP C#] http://blog.rthand.com
    • Marked as answer by Harry Zhu Wednesday, March 31, 2010 2:55 AM
    Thursday, March 25, 2010 7:51 AM