Try Your Luck

[Karma31251]

Ok, so, I have a VB2005 Program linked to a database. I also have a datagrid on the form that displays a certain table in the database. Now, randomly the datagrid will rearrange the sort order for no apparent reason. I use PKeys that run off AutoNumbers, so you'd think it would not be that hard and 99.9 % of the time the code will load the correct order, 1,2,3,4,5,6,7,etc... But once in a while it will load up not just backwards or something but just all out of order, 2,5,4,1,6,3,7, etc... The fill code looks like this : "Me.TblFruitTableAdapter.Fill(Me.DbScreenDataSet.tblFruit, DatePro)" Its pretty much computer generated except for i added in a variable for the Date of Production so that when the program loads it only grabs the records for that day, but the records get put in, in order so that day 1 hour 1 is record 1 of the day. Can anyone explain why 99.9 % of the time it loads the records correctly but once in awhile it will load them distorted?

[Christian Graus]

Does your SQL have an order by statement ?

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[Karma31251]

I'm sorry I forgot to mention that i am using MS Access for my database purposes.

[Christian Graus]

OK, so build your SQL on each keypress, and filter your data direct from the DB.

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[Dave Kreskowiak]

An SQL query is not guaranteed to return records in a specific order unless told to with an ORDER BY clause in the SELECT statement.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007